Calculation Basics
Calculation
Basics- Press Enter to tell Excel that the formula is complete.
When you type the Enter key, Excel calculates the result.
If you are comfortable using the mouse, this technique of entering formulas is
fairly quick and easy.
Using the Arrow Key Method (Addition and Subtraction)..............................................
The next story problem requires both addition and subtraction. The Arrow key
method was introduced in 1981 by Lotus 1-2-3. The method became very
popular for accountants who hated typing obscure cell references like B4 and
AJ62. This was before computers typically had a mouse (the first Macintosh
didn’t come out until late 1983).
Tip:
If your keyboard has a numeric keypad, the upper right keys on the keypad will let
you type the common operator keys without using the Shift key.Figure 11
Excel calculates the result and automatically
moves the cursor down one cell.Figure 10
Excel automatically enters the cell
location you click on with the mouse.