passwella.
Menu

WAEC Data Processing 2022 Question 20

Question 20

Spreadsheet

Table 1 is a portion of a Microsoft Excel Worksheet which shows the marks obtained by some students in an examination.
Which of the following formulas can be used to find the average score for ENEH GRACE?

Diagram for this question
  1. A.=AVERAGE(B4:B6)
  2. B.=AVERAGE(B5:F5)
  3. C.=AVERAGE(B4:F4)
  4. D.=AVERAGE(A4:F4)
Show the answer and explanation

Answer: C (=AVERAGE(B4:F4))

Explanation

Eneh Grace is in row 4 and her marks are in columns B to F, so =AVERAGE(B4:F4).