WorksheetsMultiple Assessment Quiz- Gr 7- Formulas and Functions- Quiz
Total questions: 10
Worksheet time: 5mins
Which operator we use to add numeric values.
&
+
=
!
Formula must begin with which sign?
@
=
!
None of the above
Which function we use to find the sum of given range.
AVG()
TOTAL()
SUM()
ALL OF THE ABOVE
How many types of Referencing are there in Excel?
1
2
3
4
When column have not enough space to accomodate the value, which type of error occured?
#DIV/0
#NAME
ERROR
######
Which symbol we use to specify the range in formula.
-
:
+
None of the Above
Which function displays the Current Date.
DATE()
DAY()
MONTH()
None of the Above
Which function we use to find the Minimum value from a given range.
MIN()
MAX()
MINIMUM()
MAXIMUM()
What we call the Group of Contiguous cells.
Concatenation
Cell Referencing
Range
Formula
Which key combination is used to get the sum of the values of adjacent cells?
Shift +S
Ctrl + S
Alt + =
Ctrl + '
