SPREAD SHEET APPLICATION - Quiz

1) Which function in Excel is used to find the biggest value in a range?

Ceiling DMAX LEN MAX

2) 12 Which one of the following is a text function in MS Excel?

MID() NOW() COUNT() SIGN

3) Which one of the following is a ?Date & Time? function in Excel?

FIND() MOD() NOW() MID()

4) Which function is used to find the middle number in a range?

MEDIAN() MID() TRIM() MODE()

5) What is the purpose 'Tab' key in MS Excel?

Moves cell pointer to previous column Moves cell pointer to next column Moves cell pointer previous row Moves cell pointer next row