To calculate the average of a range of values using the AVERAGE function in Excel, follow these steps:
- Select an empty cell where you want the average to be displayed.
- Type the formula "=AVERAGE(" into the cell, without the quotation marks.
- Select the range of values for which you want to calculate the average.
- You can select individual cells by clicking and dragging the cursor over them, or you can select a range of cells by clicking on the first cell and holding down the Shift key while clicking on the last cell.
- The cell references will automatically be added to the formula as you make the selection.
- Close the parentheses by typing ")" after the range selection, without the quotation marks.
- Press Enter or Return to calculate the average.
The cell will now display the average of the selected range of values.