5
Table Of Contents
- Contents
- Chapter 1: Introduction
- Chapter 2: Creating, opening, and printing documents
- Starting AppleWorks
- Creating a document
- Saving a document
- Opening a document
- Finding documents
- Linking to other documents
- Saving document formatting as templates (stationery)
- Identifying your documents
- Protecting documents with passwords
- Importing and exporting documents
- Converting documents
- Closing a document and leaving AppleWorks
- Printing a document or Help topic
- Chapter 3: Basics
- Chapter 4: Text (word processing)
- When to use a word processing document
- Text basics
- Changing text appearance
- Changing paragraph formats
- Sorting paragraphs
- Outlining
- Creating tables
- Working with pages
- Dividing a document into sections
- Adding footnotes and endnotes
- Finding and changing text
- Using writing tools
- Adding pictures and frames to text
- Creating links in word processing documents
- Chapter 5: Drawing
- When to use a drawing
- Drawing basics
- Changing the appearance of objects
- Connecting objects
- Arranging objects
- Locking objects to prevent changes
- Creating a master page
- Adding pages to a draw document
- Creating custom colors, patterns, gradients, and textures
- Adding clip art
- Adding text, spreadsheet, or paint frames
- Creating links in draw documents
- Chapter 6: Painting
- Chapter 7: Spreadsheet
- When to use a spreadsheet
- Spreadsheet basics
- Modifying cell data
- Naming cells and ranges
- Changing cells, rows, and columns
- Adding and removing page breaks
- Changing the display
- Printing a spreadsheet document
- Working with formulas
- Cell references in formulas
- Working with functions
- Displaying data in charts (graphs)
- Adding pictures or a text frame
- Creating links in spreadsheet documents
- Chapter 8: Database
- When to use a database
- Database basics
- Example: Creating a simple database
- Designing a database
- Entering data in fields
- Duplicating, deleting, and moving records
- Moving through records
- Viewing records
- Playing movies in multimedia fields
- Working with rows and columns in List mode
- Selecting and hiding records
- Sorting records
- Finding information
- Working with layouts
- Changing the appearance of data
- Presenting and summarizing data with parts
- Creating reports
- Importing data from other documents
- Printing a database document
- Chapter 9: Beyond the basics
- Chapter 10: Communications
- Chapter 11: AppleWorks and the Internet
7-16 AppleWorks 5 User’s Manual
9. Select cell B3 and type an equal sign (=).
10. Choose Income from the menu in the entry bar and type a minus sign (-).
11. Choose Expenses from the menu in the entry bar and press Enter.
The formula contains the named cells Income and Expenses.
Example 2: Replacing named cells with cell references
This example shows you how to replace the named cells you defined in
Example 1 with cell references.
1. Select cell B3 and choose Replace Names from the menu in the entry bar.
2. In the dialog box, note that Expenses and Income are suggested for replacement
with cell addresses. You want to replace them both, so click Replace.
The named cells are replaced with their corresponding cell addresses.