Owner's manual

VIII AppleWorks 5 User’s Manual
Formatting cell data 7-9
Sorting cell data 7-11
Locking cell data 7-12
Naming cells and ranges 7-12
Assigning names to cells 7-13
Editing and deleting names 7-13
Using named cells in formulas 7-14
Replacing cell references with named cells 7-14
Example 1: Using cell names in a formula 7-15
Example 2: Replacing named cells with cell references 7-16
Changing cells, rows, and columns 7-17
Resizing or hiding rows and columns 7-17
Inserting and deleting cells, rows, and columns 7-18
Changing the number of rows and columns 7-18
Adding borders, colors, and patterns to cells 7-19
Locking row and column titles 7-19
Adding and removing page breaks 7-20
Changing the display 7-20
Printing a spreadsheet document 7-21
Working with formulas 7-21
Understanding formulas 7-21
Cell references in formulas 7-22
Entering formulas 7-23
Calculating formula results 7-24
Making corrections 7-25
Examples: Entering formulas 7-25
Working with functions 7-26
Entering functions 7-27
Example: Using the AVERAGE function 7-28
Displaying data in charts (graphs) 7-29
Making charts 7-29
Changing chart options 7-30
Deleting, copying, or moving a chart 7-31
Enhancing a chart’s appearance 7-32
Adding pictures or a text frame 7-33
Creating links in spreadsheet documents 7-35