Term3 - Grade 7 - Revision 2023-2024

In MS Excel Count Function will tell us the number of cells that contain ..............

• Numbers

• Text

• Anything

Which function should be used to get the number of the absent students In MS Excel?

• Count

• CountA

• CountBlank

Which function will display the number of the cells that are not empty?

• Count

• CountA

• CountBlank

Formula always begins with this symbol ...........

• %

• *

• =

The bar where we can write the functions above the column headers is called.........

• Data bar

• Function bar

• Formula bar

The cell name is displayed in ...............

• Location box

• Reference box

• Name box

To succeed you must get greater than or equal to 50, otherwise you fail.

select the correct code :

• =if(g1>50,"success","fail")

• =if(g1>=50,"success","fail")

• =if(g1>50 or equal 50,"success","fail")

In if function, the condition part is part number ............

• 1

• 2

• 3

In if function, the else part is part number ............

• 1

• 2

• 3

In if function, the result_if_true part is part number .....................

• 1

• 2

• 3