Practice Creating Formulas
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.
Note
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.
Note
Clicking the AutoSum button ...
Get Microsoft® Office 2008 for Mac Step by Step now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
