Question

You've been asked to find the average of a range of numbers. Which of the following could you use to find the average of cells A1:A10?

A. =MIN(A1:A10)
B. =SUM(A1:A10)
C. =MAX(A1:A10)
D. =AVERAGE(A1:A10)

Answer 1

D. =AVERAGE(A1:A10)

Step-by-step explanation:

The answer is D.

With option A. It means the cell should contain the minimum figure in the range of cells (A1:A10).

With option B. It means the cell should contain the total sum of the figures in the range of cells (A1:A10).

With option C. It means the cell should contain the maximum figure of the range of cells (A1:A10)