Which Excel formula correctly calculates the average of values in cells A1 through A10?
A=AVERAGE(A1:A10)
B=AVG(A1-A10)
C=MEAN(A1:A10)
D=CALCULATE_AVG(A1,A10)
Explanation
=AVERAGE(A1:A10) is the correct built-in function syntax in Excel to compute the arithmetic mean of a range of cells. Note that Excel uses ‘AVERAGE’, not ‘AVG’ or ‘MEAN’.
Exam Relevance
- Topic: MS Office
- Subtopic: MS Excel
No Comments