Information and Communication Technology

Question 1

1What does =COUNT(B1:B20) do?

Easy

A. adds the numbers B. counts the letters C. finds the average D. counts the cells that contain numbers

Question 2

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

Easy

A. Fail B. Pass C. 45 D. error

Question 3

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

Hard

A. =$A$1*C3 B. =$A$1*B3 C. =$A$2*B3 D. =A2*B3

Question 4

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

Medium

A. =IF(C2<50,"Pass","Fail") B. =IF(C2>=50,"Pass","Fail") C. =COUNT(C2>=50) D. =SUM(C2,"Pass")

Question 5

5Which is an absolute cell reference?

Easy

A. $B$2 B. 2B C. B$ D. B2

Question 6

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

Hard

A. an error always B. the value in column 3 of the row where 101 is found exactly C. the row number of 101 D. the sum of column 3

Question 7

7=MAX(C1:C10) returns the

Easy

A. smallest value B. number of cells C. average D. largest value in the range

Question 8

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

Easy

A. 9 B. 3 C. 6 D. 12

Question 9

9Every spreadsheet formula must begin with

Easy

A. = B. # C. & D. @

Question 10

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

Easy

A. 20 B. 24 C. 14 D. 9