Apple AppleWorks 5 : Mac OS - Manual (Page 170)

7-24 AppleWorks 5 User’s Manual
Tip If you want a paper copy of all the AppleWorks functions, you can print
an alphabetical summary from onscreen Help. See “Printing a document or
Help topic” on page 2-20.
Calculating formula results
When you enter and confirm a formula, AppleWorks computes the result.
AppleWorks is preset to calculate formulas automatically each time you
confirm an entry in a cell. To turn automatic calculation on or off, choose
Auto Calc from the Calculate menu. When Auto Calc is on, you see a
checkmark next to the Auto Calc command.
Because automatic recalculation of large spreadsheets can be time
consuming, you may want to work with Auto Calc off. To calculate formula
results when Auto Calc is off, choose Calculate Now from the Calculate menu.
Enter a reference to
a cell range Drag to select the range that you want to
refer to. The reference to the cell range
appears at the insertion point in the
formula. Then enclose the range in
parentheses.
Or type the addresses of the cell at the
upper left of the range and the cell at the
lower right with two dots between them
and enclose the range in parentheses.
=SUM(B1..C1)
Enter an absolute
cell reference Click in the entry bar before the part of the
cell address that you want to make absolute
and then type a dollar sign ($). =$A$1+B$1+$C1
Enter a reference to
a named cell or
range Choose the name of the cell or range from
the
menu in the entry bar.
For more information, see “Naming cells
and ranges” on page 7-12.
=Revenue-Expenses
Have AppleWorks
interpret a number
or punctuation as
text Begin and end the entry with a double
quotation mark. =“1992”
=”!”
Use a function
(ready-made
formula) See “Entering functions” on page 7-27. =DATE(95,10,10)
* Choose Index from the or Help menu and scroll to the entry. Then choose a topic from
the list and click Go To Topic.
To Do this Example
In the Help index, * see:
E
Help, printing
In the Help index, * see:
E
Auto Calc command