NEW
Font size
WorksheetsFormulas & Functions
Total questions: 10
Worksheet time: 8mins
Which function return the remainder after a number is divided by the divisor ?
MOD
POWER
SUM
AvG
Which of the given cell reference can be included in relative reference?
$D6
A$1
A3
&D6
Which key combination is used to get the total of adjacent cell?
Ctrl+
SUM()
Alt+
AVG()
Which function find the largest number in range ?
Count ()
AVG()
max()
Min()
Which function finds the lowest number in range?
Max()
Min()
Count ()
AVG ()
A Formula always begin with an _____ sign.
+
-
=
!
Formula are used to perform ______
Manipulation
Saturation
Substraction
Calculation
The cell address in a Formula is also called_______
Cell reference
Relative reference
Absolute reference
Record reference
In absolute referencing '$'sign is used to before the co - ordinates
✔️
✖️
Sheet tab cannot be renamed
✔️
✖️
