Skip to content
OtisamLMS
Sign in Sign up
Information and Communication Technology

Information and Communication Technology · Quick practice · answer shown after each question

Spreadsheets: cells, formulas and functions

Question 1 of 10

Question 1 of 10

=MAX(C1:C10) returns the

Question 2 of 10

Question 2 of 10

All spreadsheet formulas begin with

Question 3 of 10

Question 3 of 10

The function =COUNT(A1:A10) counts

Question 4 of 10

Question 4 of 10

A range of cells from A1 to C3 contains how many cells?

Question 5 of 10

Question 5 of 10

In a spreadsheet, the cell reference C5 means

Question 6 of 10

Question 6 of 10

The formula =SUM(A1:A5) adds

Question 7 of 10

Question 7 of 10

The cell reference that changes when a formula is copied is a

Question 8 of 10

Question 8 of 10

=VLOOKUP(101, A2:C10, 3, FALSE) returns

Question 9 of 10

Question 9 of 10

Which function gives the average of the cells B2 to B10?

Question 10 of 10

Question 10 of 10

What does =SUM(A1:A4) do?

Questions written by OtisamLMS in the style of the WASSCE. They are not WAEC past questions.