O'Reilly logo

Learn Excel 2011 for Mac by Guy Hart-Davis

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

Creating Straightforward Formulas

Now that you know what the calculation operators are, try the following example of creating a worksheet (see Figure 5–1) with straightforward formulas that use the four most straightforward operators—addition, subtraction, multiplication, and division.

images

Figure 5–1. Create this simple worksheet to try using Excel's addition, subtraction, multiplication, and division operators.

To create the worksheet, follow these steps:

  1. Create a new workbook. The quickest way to do this is to press Cmd+N.
  2. Type the following text in cells A1 through A7:
    • A1. Gross
    • A2. Expenses
    • A3. Tax Rate
    • A4. Tax Amount
    • A5. Net
    • A6. Months ...

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