Excel for Marketing Managers

Calculation Basics

Calculation

Basics

3. Enter a plus sign to the first element.
   The next part is a little tricky. In your formula, you want to add B5 to the
   formula. Type the plus sign on your keyboard. This tells Excel that you are
   accepting the B4 portion of the formula and that you are ready to enter an-
   other cell. Instead of a flashing box around B4, you now have a solid box
   around B4. Here is the tricky part: as soon as you type the plus sign, Excel
   returns the focus back to the original cell location of B7.


4. Select the second element.
   You want to point to the 3 in cell B5 now. Many people trying this method
   for the first time think that they should type the Down arrow to move down
   from B4. This is not correct. You actually have to type the Up arrow twice
   to move up from cell B7 to B5.
   Type the Up arrow twice and Excel will propose a formula of =B4+B5.

Figure 16

The flashing box turns solid blue when you

accept a portion of the formula by typing the

plus sign

Figure 15

Screen after pressing the Up arrow key

thrice