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
Spreadsheet 7-5
As you work with spreadsheet frames, keep the following points in mind:
1 You can’t change or open any type of frame in a paint document. See
“Adding text and spreadsheets” on page 6-14 for more information.
1 You can link two or more spreadsheet frames in a document. See
“Linking frames” on page 9-29.
Typing in a spreadsheet
Each cell in a spreadsheet can contain numbers, words, or formulas.
To enter a negative number, begin the number with a minus sign (–).
To enter a formula or function, begin the entry with an equal sign (=). See
“Working with formulas” on page 7-21 and “Examples: Entering formulas”
on page 7-25 for more information.
Note You can also print, or merge, database information on a spreadsheet.
For more information on merging documents and printing them, see
“Merging data into documents (mail merge)” on page 9-22.
Selecting cells and ranges
You must select a cell or cell range (group of adjacent cells) before you can
change, format, or work with data.
*
Choose Index from the or Help menu and scroll to the entry. Then choose a topic from
the list and click Go To Topic.
In the Help index,* see:
E entering spreadsheet data
E spreadsheets, documents
Click to
confirm the entry
or to cancel
To type numbers or words
in a cell, click a cell and
begin typing
What you type
appears in the
entry bar
The entry
appears in
the cell
In the Help index,* see:
E Go To Cell command
E selecting cells










