Datasheet

14
Chapter 1

Navigating in Excel and Understanding the Interface
Once data is in a worksheet, there are various ways to modify that data at a later time, if
you need to update it.
An important thing to note is that anything typed within a cell is not committed until you
press the Enter key. When in Edit or Enter mode, if you start to change or replace the content
of any cell but change your mind, pressing the Esc key on your keyboard will revert the con-
tent to what it was originally, as long as you have not yet pressed Enter and left the cell. If
you have already left the cell, use the Undo button on your Standard toolbar to undo the last
action.
6. In cells B9 through E9 enter the numbers shown here, pressing your Tab key after you
type each one:
In B9, type 450, and then press Tab to move to C9.
Type 550.5, and then press Tab to move to D9.
Type 675.95, and then press Tab to move to E9.
Type 1000.
7. After you type 1000 in E9, press Enter to move down to E10, then press Home to move
to the beginning of row 10.
8. In rows 10 and 11, add the data shown here, using the method described earlier:
In A10, Flora; in B10, 300; in C10, 899.5; in D10, 1600; in E10, 1297
In A11, Fauna; in B11, 1499; in C11, 1076; in D11, 1187.99; in E11, closed
9. You have now added three new stores to your worksheet, and it should look like the
worksheet shown here:
10. Leave this workbook open for the next exercise.
EXERCISE 1.4 (continued)
4002book.fm Page 14 Friday, March 24, 2006 11:36 PM