Manual

Working with Values and Labels
Build a spreadsheet by entering values, labels, andformu/as.
Values. Values are numbers, for example, sales figures for the past four
quarters.
Dates can be entered
as labels or as formulas,
depending on how you
want to us'ethem. See
Entering and Changing
Dates onpage 75.
/abe/.,. Labels are text; they are the titles or descriptive text that describe the
contents of rows and columns, for example, First Quarter, Second Quarter,
Third Quarter, and Fourth Quarter.
Formu/as. Formulas perform calculations, like averaging a list of values.
Spreadsheet contains prewritten formulas called Built-_ Functions; for
example, a built-in function called SUM totals values, such as the sales for all
four quarters.
This section explains how to enter values and labels in a spreadsheet. For
more information about formulas, see Working with Formulas on page 85.
Entering Values and Labels
If you have selected a
range of cells, press
ENTER to move down
columns and press
TAB to move across
rOWS.
I_ To enter values or labels:
1. Select the cell in which you want the entry to appear.
2. Type the entry (numbers or words) in the cell. If you are using the
numeric keypad to enter numbers, besure the NUM LOCK key is on. To
turn it-one click on_theNUM button in the lower left comer of the screen
or press NOM I_OCK. If you make a typing mistake, press BACKSPACE
to erase characters to the left of the insertion point in the Edit Area.
3. Press one of the following keys to complete the entry:
• ENTER. Moves the highlighting down one cell.
• SHIFT + ENTER. Moves the highlighting up one cell.
• TAB. Moves the highlighting to the right one cell.
• SHIFT + TAB. Moves the highlighting to the left one cell.
• (t X _ X _-- X -*). Moves the highlighting one cell in the direction of
the arrow.
• CTRL + ENTER. Keeps the highlighting in the current cell; the active
cell does not change.
You can also complete your entry by clicking on Enter in the Edit bar. In this
case, the highlighting does not move.
Spreadsheet 72