Apple AppleWorks 5 : Windows 95/NT 4.0 - Manual (Page 158)

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-16.
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.
Making corrections
If you see ### in a cell, it means the column is too narrow to display the
number. To widen the column, select the column and then increase its width
by choosing Column Width from the Format menu. Type a width, and then click
OK. For more information on changing the size of a column, see “Resizing or
hiding rows and columns” on page 7-16.
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 Help menu and type the first few letters of the entry. Double-click the
entry and then double-click a topic.
To Do this Example
In the Help index, * see:
E
Help, printing
In the Help index, * see:
E
Auto Calc command
In the Help index, * see:
E
formulas, spreadsheet
E
resizing, spreadsheet cells
E
troubleshooting
Before After