Table of Contents
Advertisement
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 on page 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
Advertisement
Table of Contents
