passwella.
Menu

WAEC Data Processing 2017 Question 21

Question 21

Spreadsheet

Which of these formulas will not be executed in MS Excel?

  1. A.=SUM(examscore)
  2. B.=SUM(Examscore)-12
  3. C.=SUM(exam_score)*8
  4. D.=SUM(exam score)/3
Show the answer and explanation

Answer: D (=SUM(exam score)/3)

Explanation

Names in Excel formulas cannot contain spaces, so =SUM(exam score)/3 gives an error; the others use valid names.