Information and Communication Technology

Question 1

1ROUND(7.468, 1) returns

Easy

A. 7.5 B. 7 C. 7.47 D. 7.4

Question 2

2A nested IF is used to

Hard

A. join two sheets B. print rows C. make charts D. test several conditions, such as grading A, B, C and F

Question 3

3The function that counts non-empty cells is ___.

Medium

Your answer (fill in the blank)

Question 4

4Which formula gives "Distinction" for 75+, "Credit" for 60–74 and "Fail" otherwise when the mark is in B2?

Hard

A. =VLOOKUP("Distinction") B. =IF(B2>=60,"Credit","Distinction") C. =IF(B2,"Fail") D. =IF(B2>=75,"Distinction",IF(B2>=60,"Credit","Fail"))

Question 5

5RANK can be used to find a pupil's position in class.

Easy

A. True B. False

Question 6

6COUNT counts

Medium

A. formulas only B. cells containing numbers C. only text D. all non-empty cells

Question 7

7AVERAGEIF is used to

Medium

A. sort data B. find the mode C. count text D. average only the cells that meet a condition

Question 8

8SUMIF adds cells that meet a condition.

Easy

A. True B. False

Question 9

9=AND(TRUE, FALSE) returns TRUE.

Easy

A. True B. False

Question 10

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

Medium

Your answer (fill in the blank)