passwella.
Menu

WAEC Data Processing 2018 Question 20

Question 20

Spreadsheet

Table 1 is a part of MS Excel worksheet which shows the marks obtained by some students in an examination.
Which of the following formulas would calculate the average score of the students in Mathematics?

Diagram for this question
  1. A.=Average (C2: C6)
  2. B.=Average (C2: F2)
  3. C.=Average (C1: C6)
  4. D.=Average (C1: F1)
Show the answer and explanation

Answer: A (=Average (C2: C6))

Explanation

Mathematics is column C and the students are in rows 2 to 6, so use =AVERAGE(C2:C6).