Auto Average in Excel

 AutoAverage is a feature in Microsoft Excel that automatically calculates the average of a range of selected cells. To use AutoAverage:

1. Select the cell where you want to display the average.
2. Click on the drop-down arrow next to the AutoSum button (Σ) in the "Editing" group on the "Home" tab of the ribbon.
3. Choose "Average" from the list of functions, or use the keyboard shortcut Alt+Down Arrow to open the drop-down list and then press A.
4. Excel will automatically select a range of cells that it thinks you want to average based on the adjacent cells.
5. If Excel has not selected the correct range, highlight the range of cells you want to average and press Enter to confirm the formula.

Alternatively, you can also type "=AVERAGE(" into the cell where you want to display the average, and then select the range of cells you want to average. Finish the formula with ")" and press Enter to confirm.