Choose correct Function  in MS-Excel that  helps you calculate Average of a column?[1]AAverage()BAvg()CMean()Reset

Break Down the Problem

1. Identify the function needed to calculate the average of a column in MS Excel.
2. Evaluate the options provided.

Relevant Concepts

1. Average calculation can be represented mathematically as: $\text{Average} = \frac{\text{Sum of values}}{\text{Number of values}}$
2. In MS Excel, there are functions specifically designed for calculating averages.

Analysis and Detail

1. The function AVERAGE() is a built-in function in Excel that calculates the average of a set of values.
2. The function AVG() is not a recognized function in Excel; it is often found in SQL as a function for averaging but does not apply in Excel.
3. The term Mean() is a statistical term but is not a function available in Excel. The correct function to use is AVERAGE().

Verify and Summarize

• The function AVERAGE() correctly calculates the average in Excel.
• Other options provided (Avg() and Mean()) do not exist in Excel as functions.

Final Answer

The correct function to calculate the average of a column in MS Excel is A. AVERAGE().