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-9
To copy cell contents—including formulas—into adjacent cells, drag to
select the cells with the data to duplicate and continue dragging down or to
the right over the cells you want to fill. Then choose Fill Down or Fill Right from
the Calculate menu.
Use the Fill Special command in the Calculation menu to fill cells with:
1 a logical series of numbers, times, or dates
1 a day (Monday), month (January), or quarter name (Qtr 1)
1 any pattern of text or data
For example, you can prepare a schedule by filling a range of cells with times
and another range of cells with the days of the week. To fill a range of cells
with a logical series or a repeated pattern of data, select the cells and then
choose Fill Special from the Calculate menu. Select options and click OK. For a
complete description of the Fill Special command, see onscreen Help.
Formatting cell data
You can change the format of any part of your spreadsheet. Start by selecting
the cell, cell range, column, or row that you want to change.
*
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 filling cells
Selected cells AppleWorks copies the
formula to the selected cells
Result of a
formula
Fill Right
Selected cells AppleWorks fills the
selected cells with data
Fill Special
Cells filled with a
sequence of times
In the Help index,* see:
E spreadsheets
E spreadsheets, formatting