Excel for Marketing Managers

(Dana P.) #1
Calculation Basics

Calculation
Basics



  1. Select the first term.
    After typing the equals sign, use the mouse to touch cell B4. Because you
    are in formula entry mode, the formula in cell B6 automatically types B
    for you.

  2. Enter a minus sign.
    Now, back on the keyboard, type the minus sign. Notice that when you type
    the minus sign, the flashing dots around B4 become a solid blue color. Excel
    is waiting for you to touch another cell with the mouse.

  3. Select the second element.
    With the mouse, touch the 30 in cell B5. Excel will enter B5 in the formula.


Figure 9
A solid blue box indicates that Excel is
waiting for your input.

Figure 7
Formulas start with an equals sign

Figure 8
Solving a subtraction problem in Excel using the
mouse
Free download pdf