passwella.
Menu

WAEC Data Processing 2021 Question 21

Question 21

Spreadsheet

The formula to calculate the average of a given range of data from cell B2 to cell D4 in a Microsoft Excel worksheet is

  1. A.=AVERAGE(B2+D4).
  2. B.=AVERAGE(B2:D4)
  3. C.=AVERAGE(B2, D4)
  4. D.=AVERAGE(B2:D4).
Show the answer and explanation

Answer: B (=AVERAGE(B2:D4))

Explanation

A range is written with a colon, so =AVERAGE(B2:D4) averages every cell from B2 to D4.