O'Reilly logo

Microsoft® Office 2008 for Mac Step by Step by Joan Lambert

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

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.

  1. If the Formula Bar isn’t already open, click Formula Bar on the View menu.

    Practice Creating Formulas
  2. Click cell B5 to activate it. On the Standard toolbar, click the AutoSum arrow.

    Practice Creating Formulas

    Note

    Clicking the AutoSum button ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required