Spreadsheets: logical and lookup functions

Question 1 of 10

=ROUND(3.456, 2) returns ___.

Question 2 of 10

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

Question 3 of 10

In =VLOOKUP(A2,$F$2:$G$10,2,FALSE), the number 2 means

Question 4 of 10

=IF(10>5,"Yes","No") returns ___.

Question 5 of 10

CONCAT or & is used to

Question 6 of 10

COUNTIF is used to

Question 7 of 10

=OR(B2="Yes", C2="Yes") returns TRUE when

Question 8 of 10

Marks are in B2:B41. Write formulas to find (a) how many pupils passed (50 or more), (b) the average of those who passed, and (c) "Pass" or "Fail" for the pupil in row 2.

Question 9 of 10

FALSE as the last argument of VLOOKUP means

Question 10 of 10

The function that looks up a value down the first column of a table is ___.