Question 22

Question

In Excel, which formula can be used to calculate the average of the values in cells A1 to A10?


=MAX(A1:A10)


=SUM(A1:A10)/COUNT(A1:A10)


=AVERAGE(A1:A10)


=SUM(A1:A10)/10

Answer 1

The correct formula to calculate the average of the values in cells A1 to A10 in Excel is:

=AVERAGE(A1:A10)

This formula directly computes the average of the specified range of cells.