Question

MS-Excel includes built-in functions to perform calculations. Which of the following functions calculates the mean of numeric values entered into a range of cells?

• A. =SUM()
• B. =MEAN()
• C. =ADD()
• D. =AVERAGE()

Hint:

In Excel, use \texttt{=AVERAGE(range)} to compute the mean of a group of numbers. Avoid invalid functions like =MEAN().

Answer 1

The Correct Option is D

Step 1: Understanding the task
The question is asking for the Excel function that calculates the mean (average) of values in selected cells.


Step 2: Evaluating the options
=SUM(): Adds all numbers but doesn’t calculate mean.
=MEAN(): This is not a valid Excel function.
=ADD(): Also invalid in Excel.
=AVERAGE(): Correct function used in Excel to compute the mean.


Step 3: Function use
\texttt{=AVERAGE(A1:A5)} would calculate the average of values in cells A1 to A5.


Step 4: Conclusion
Hence, the correct answer is (4) =AVERAGE().