104. Finding averages with the AVERAGE function
Finding Averages with the AVERAGE Function
The **AVERAGE** function in Excel calculates the mean of a set of numbers. It is a quick way to determine the central value of your data.
Syntax of the AVERAGE Function
=AVERAGE(number1, [number2], ...)
- number1: The first number, cell reference, or range.
- [number2]: (Optional) Additional numbers, cell references, or ranges.
Steps to Use the AVERAGE Function
- Select the cell where you want the result to appear.
- Type
=AVERAGE(
followed by the range or numbers to average. - Close the parentheses
)
and press Enter to see the result.
Interactive Example: AVERAGE Function
Item | Value |
---|---|
Test 1 | 80 |
Test 2 | 90 |
Test 3 | 85 |
Average | Click Calculate |
Edit the values in the table above and click "Calculate Average" to see the AVERAGE function in action.
This example demonstrates how the AVERAGE function calculates the mean of a range of numbers in Excel.
Comments
Post a Comment