In this exercise, you’ll create a formula to calculate the difference between two cell values, duplicate the formula within a cell range, and then copy the formula to another table.
SET UP Open the AnnualSales workbook from the ~/Documents/Microsoft Press/ 2008OfficeMacSBS/CreateFormulas/ folder. Display the Standard and Formatting toolbars.
If the Formula Bar isn’t already open, click Formula Bar on the View menu.
Click cell B5 to activate it. On the Standard toolbar, click the AutoSum arrow.
Clicking the AutoSum button ...