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

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

Spreadsheets: logical and lookup functions

Question 1 of 10

Question 1 of 10

TODAY() returns

Question 2 of 10

Question 2 of 10

SUMIF adds cells that meet a condition.

Question 3 of 10

Question 3 of 10

=ROUND(3.456, 2) returns ___.

Question 4 of 10

Question 4 of 10

The function that counts cells meeting a condition is ___.

Question 5 of 10

Question 5 of 10

SUMIF is used to

Question 6 of 10

Question 6 of 10

What does =IF(B2>=50,"Pass","Fail") return when B2 is 49?

Question 7 of 10

Question 7 of 10

VLOOKUP searches the first column of the lookup table.

Question 8 of 10

Question 8 of 10

AVERAGEIF is used to

Question 9 of 10

Question 9 of 10

Explain how the RANK function can be used to produce class positions and one problem with ties.

Question 10 of 10

Question 10 of 10

The function that counts non-empty cells is ___.

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