Class - 6 Quiz on Formulas and Function

To use the sheet reference, which address is appropriate out of the following options?

• D4!Sheet1

• Sheet1, D4

• Sheet1!D4

• All of the above

Which of the given cell reference can be used in a relative reference?

• $d6

• A3

• A$1

• None of these

Which function returns the remainder after a number is divided by the divisor?

• MOD

• POWER

• SUM

• None of these

Which function is used to count the number of numeric values in a range?

• COUNT()

• SUM()

• COUNTNUMBER()

• All of the above

Formulas are used to perform (a)  

A formula always begin with __________________ sign

• :

• =

• ( )

• None of these

The ________________ character is used for the concatenation of the strings.

• +

• &

• *

• @

The cell address of a formula that does not change on copying, is considered as _______________

• Relative Reference

• Absolute Reference

• Mixed Reference

• Circular Reference

Which key combination us used to get the sum of the values of adjacent cells?

• Ctrl+=

• Alt+=

• Alt+

• Shift+'

In absolute referencing, the relative position of the rows and columns change when you copy a formula.

• True

• False