Manual

Define a name that refers to a specific cell or range. For example, you might

define RATE as A3; then, when entering formulas, you can type RATE instead

of typing A3.

To define a name:

1. Select Define Name from,the Formula menu. A dialog box appears with a

list of any names you bare previously defined.

2. Click on New. Another dialog box appears:

Add a _ Llaw_.

.ar_ [

Derenitioe_ ,

You call use

absolute and relative

references when

defining a name for

cells. An absolute

reference tells

Spreadsheet the

specific addres_o'Ta

cell. A relative

reference tells

Spreadsheet how to

find a pa_'cular cell

starting from the cell

cont_'ning the

formula. For more

informa_on,see

page 86.

3. Fill in the dialog box, specifying the name and reference you want to use:

• Name. Enter the name (example, Cost).

• Definition. Enter the cell address or the addresses for the range of

cells. Use absolute references (example, $B$1) unless you want the

named cells to be relative (see page 86 for information on absolute

and relative references).

4. Click-on OK.-The na,_._ appears i_t-tbe list in the Define Name dialog box.

5. Click on Close.

Spreadsheet 99