Excel for Marketing Managers

Calculation Basics

Calculation
Basics

1. Start your formula with an equals sign.
   As shown in the image below, type an equals sign in cell B7.


2. Select the first element.

a. Using the arrow keys on your keyboard, type the Up arrow key three

times. After the first press of the Up arrow key, the screen will think

that you want to start your formula as =B6.

b. That is OK. Ignore the screen and press the Up arrow key a second

time. Now the screen thinks that you must want to start your formula

with =B5.

c. Again, ignore what is on the screen and type the Up arrow key one

more time. Now the screen suggests that your formula should start with

=B4. This is correct.

Figure 14

Screen after pressing the Up arrow key twice

Figure 12

Solving a subtraction problem in

Excel using the arrow keys

Figure 13

Screen after pressing the Up arrow key once