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

  • A = AVERAGE (B2+D4)
  • B =AVERAGE (B2:D4)
  • C =AVERAGE(B2, D4)
  • D =AVERAGE(B2;D4)
waec 2021dataprocessing

The correct answer is B. =AVERAGE (B2:D4)

No explanation given
Previous question Next question