grade 6

To display today’s date in MS Excel we use ………………….

• =Day(c2)

•       =today ()

•       =month(c2)

•       =year(c2)

The ……… Function used in Excel to evaluate a condition

•   IF

• Sum

• Average

• Max

  One of the following is the correct use of IF Function:

• IF( c4 > 10  passed , failed)

• =IF( c4 > 10 ,  passed failed)

• IF( c4 > 10  “passed” , “failed”)

• =IF( c4 > 10 ,  “passed” , “failed”)

The If function is formed of 3 parts separated by two ---------------

• Spaces

• Lines

•    Commas

• Stars

   In Excel the cell that contains the value “0” considered as empty cell.

• True

• False

=COUNTblank(D7:D16)

will count the empty cells between D7 & D16

• True

• False

Formulas in Excel should start with equal sign

• True

• False