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

The formula =$A$1*B2 copied to C3 becomes

Question 2 of 10

Question 2 of 10

=MAX(C1:C10) returns the

Question 3 of 10

Question 3 of 10

The function =COUNT(A1:A10) counts

Question 4 of 10

Question 4 of 10

What is the result of =ROUND(3.456, 1)?

Question 5 of 10

Question 5 of 10

In =IF(B2>=50,"Pass","Fail"), a score of 45 gives

Question 6 of 10

Question 6 of 10

What does =SUM(A1:A4) do?

Question 7 of 10

Question 7 of 10

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

Question 8 of 10

Question 8 of 10

What is the result of the formula =2+3*4?

Question 9 of 10

Question 9 of 10

Which formula gives "Pass" if C2 is 50 or more and "Fail" otherwise?

Question 10 of 10

Question 10 of 10

What does =COUNT(B1:B20) do?

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