passwella.
Menu

WAEC Data Processing 2018 Question 21

Question 21

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 total score of ONYEBUEKE DEBORAH in the five subjects?

Diagram for this question
  1. A.=SUM(B2: B6)
  2. B.=SUM(A6: G6)
  3. C.=SUM(A2: A6)
  4. D.=SUM(B6: F6)
Show the answer and explanation

Answer: D (=SUM(B6: F6))

Explanation

Onyebueke Deborah is in row 6 and the five subjects are columns B to F, so =SUM(B6:F6).