Multiple Assessment Quiz- Gr 7- Formulas and Functions- Quiz

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 + '