Question

Given below are two statements.
Assertion (A):
The arithmetic mean of \(A1:
A10\) cells can be calculated using Microsoft Excel with the formula \(\texttt{=SUM(A1:
A10)/10\).
Reason (R):
The direct formula does not exist to calculate arithmetic mean in Microsoft Excel.}

• A. Both (A) and (R) are correct and (R) is the correct explanation of (A)
• B. Both (A) and (R) are correct but (R) is not the correct explanation of (A)
• C. (A) is correct but (R) is not correct
• D. (A) is not correct but (R) is correct

Hint:

In Excel, mean can be calculated using \(\texttt{=SUM(range)/n}\) or directly by \(\texttt{=AVERAGE(range)}\).

Answer 1

The Correct Option is C