How we can calculate average in Excel

To calculate the average using the keyboard shortcut Alt + H + U + A in Excel, follow these steps:

Steps:

1. Open your Excel worksheet.
2. Select the range of cells for which you want to calculate the average.
3. Press Alt + H (Opens the Home tab).
4. Press U (Opens the AutoSum drop-down).
5. Press A (Selects the Average function).

What Happens?

• Excel will automatically insert the AVERAGE formula for the selected range.
• Press Enter to confirm and calculate the average.

This shortcut quickly applies the AVERAGE function without manually typing the formula. 🚀