Apple M9057 User Manual - Page 171
Making corrections, Examples: Entering formulas, Column Width
UPC - 718908500040
View all Apple M9057 manuals
Add to My Manuals
Save this manual to your list of manuals |
Page 171 highlights
Spreadsheet 7-25 Making corrections In the Help index,* see: E formulas, spreadsheet E resizing, spreadsheet cells E troubleshooting 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-17. Before After Error messages AppleWorks tells you if it can't evaluate a formula you've entered. Error messages start with the symbol # and end with an exclamation point (!), or you may see a message on the screen. Check your formula for the correct placement of parentheses, be sure parentheses are correctly paired, and check to see that you have entered operators between the cell references. For more spreadsheet and formula tips, see onscreen Help. Examples: Entering formulas These examples show how to use formulas to add numbers. Example 1: Simple arithmetic To enter a formula that sums three numbers: 1. Click a cell to make it active. 2. Type =12+3-5 in the entry bar. 3. Click to confirm the entry. AppleWorks sums the numbers and displays the result, 10, in the cell. Tip To total the value quickly, select the cells and click on the Default button bar. Example 2: Using cell references To sum three numbers using cell references: 1. Type 75, 150, and 725 as shown here. * Choose Index from the or Help menu and scroll to the entry. Then choose a topic from the list and click Go To Topic.