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-3
Creating a spreadsheet
About the spreadsheet window
When you create a spreadsheet document or frame, you see the spreadsheet
menus and the entry bar in the spreadsheet.
To create a Do this Example
Blank spreadsheet
document
Choose New from the File menu,
select Spreadsheet, and then click OK.
Or, click on the Default button
bar. (If you don’t see the button bar,
choose Show Button Bar from the
Window menu.)
Spreadsheet frame
within a document
(except communi-
cations)
Select the spreadsheet tool
(choose Show Tools from the
Window menu if it isn’t visible)
and drag the pointer in the
document.
(In a spreadsheet document, hold
down Option as you draw the
frame.)
*
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 New command
E spreadsheet frames
A spreadsheet document
A spreadsheet frame in a
word processing document
In the Help index,* see:
E spreadsheets, documents
Buttons for common
tasks in spreadsheet
documents or frames
Column
headings
Cell grid
Cell
Active cell
Row headings
Entry bar
Spreadsheet menus
Function button










