Ms Excel - Grade 8

(a)   is a small square used to copy cell content to adjacent cells.

What is default cell reference in MS Excel?

• Absolute

• Mixed

• Relative

• Fixed

To join two strings, we can use $ character.

• TRUE

• FALSE

(a)   are predefine formulas.

_____________ error message tells us that we have entered Invalid data.

• #VALUE!

• #N/A

• #NAME?

• #REF1

Which of the following methods is useful to reuse a formula?(This question has more than one answer)

• Pointing

• Copy and Paste

• Cell referencing

• Fill Handle

A formula must start with (a)   sign.

The sum( ) function is present under the ______________ function category.

• Logical

• Financial

• Text

• Maths and Trig

Cell reference ' $E1' is a valid mixed cell reference.

• TRUE

• FALSE

The range of cells in an argument of a function should be separated by a ____

• ,

• :

• ;

• =