Using AutoSum
The AutoSum button in Excel provides a quick way to add together values in a spreadsheet.

To use AutoSum:
- Select the cell where the formula is to appear in the spreadsheet
- Click the AutoSum button - Excel automatically enters a formula into the cell for you
- Check the formula to ensure it is accurate - edit the formula if necessary
- Press Enter to confirm the formula and display the formula result.
Try it!
On Sheet 1 of Sales report.xls use the AutoSum button to calculate Total actual and target sales for each quarter in row 11.



Course updates

