Which formula in cell H1 computes the mean of the values in E2:E13?

Which formula in cell H1 computes the mean of the values in E2:E13?

• A. =MEAN(E2:E13)
• B. =AVERAGE(G2:G13)
• C. =AVERAGE(E2:E13)
• D. =MEDIAN(E2:E13)

Answer: (C)

To find the mean of a set of numbers in Excel, use the AVERAGE function. The mean is the sum of all values divided by how many values there are. For values in E2:E13, the correct formula is =AVERAGE(E2:E13). This uses the proper function name and the exact range, giving the arithmetic average of those twelve cells. Other options don’t fit: using a non-existent MEAN function wouldn’t work, using a different range (G2:G13) would average the wrong cells, and using MEDIAN would return the middle value, not the average.

To find the mean of a set of numbers in Excel, use the AVERAGE function. The mean is the sum of all values divided by how many values there are. For values in E2:E13, the correct formula is =AVERAGE(E2:E13). This uses the proper function name and the exact range, giving the arithmetic average of those twelve cells. Other options don’t fit: using a non-existent MEAN function wouldn’t work, using a different range (G2:G13) would average the wrong cells, and using MEDIAN would return the middle value, not the average.