Ask a New Question

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

Please select your answer...

A
=SUM(A1:A10)/10 

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

C
=AVERAGE(A1:A10) 

D
=MAX(A1:A10) 

1 answer

The correct answer is:

C =AVERAGE(A1:A10)

Ask a New Question or answer this question.

Similar Questions

In Excel, which formula can be used to calculate the average of the values in cells A1 to A10?=MAX(A1:A10)
1. 1 answer
What is the purpose of the SUM function in Excel?To calculate the average of a range of cells To find the maximum value in a
1. 1 answer
In cell C8, create a formula using the FV function to calculate the accumulated savings amount using monthly rate, savings
1. 1 answer
How does using a table in Excel differ from using a range of cells?Using a table in Excel provides a higher level of data
1. 1 answer

more similar questions