Apple M9057 User Manual - Page 170
Calculating formula results, Auto Calc, Calculate Now
![]() |
UPC - 718908500040
View all Apple M9057 manuals
Add to My Manuals
Save this manual to your list of manuals |
Page 170 highlights
7-24 AppleWorks 5 User's Manual To Do this Example 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 =$A$1+B$1+$C1 cell address that you want to make absolute and then type a dollar sign ($). 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) In the Help index,* see: E Help, printing 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 In the Help index,* see: E Auto Calc command 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. * Choose Index from the or Help menu and scroll to the entry. Then choose a topic from the list and click Go To Topic.
![](/manual_guide/products/apple-m9057-user-manual-e586cb4/170.png)