Which formula in MS-Excel would you use to calculate the average of a range of cells (A1 to A10)?

Answer as guest — Start Free Practice Test to earn Practice PointsHow to earn pointsAsk a question+3Answer a question+1Someone answers yours+1Your Q gets upvoted+1Pioneer bonus (first 5)+51 point = ₹1 discount on purchases, ask questions & climb the leaderboard!

• A SUM(A1:A10)
• B MEDIAN(A1:A10)
• C AVERAGE(A1:A10)
• D COUNT(A1:A10)

Submit Answer

Show answer and explanation

Answer: C. AVERAGE(A1:A10)

The AVERAGE function calculates the arithmetic mean of the specified cells in Excel.

Answering after opening this box earns no Practice Points.