Communications, 1-13 to 1-14
Database, 1-11 to 1-12
Graphics, 1-7 to 1-8
Spreadsheet, 1-9 to 1-10
Word Processing (Text), 1-5 to 1-6
Apply Ruler command (Format menu), 3-24
arc tool, 4-9
Arrange. See sorting.
arcs, 4-9, 4-26, 4-28 to 4-29
arrowheads, 4-24
ASCII
inserting documents, 2-13
opening documents, 2-11
saving translator, 2-21
ASIN function, A-59
ATAN function, A-59 to A-60
ATAN2 function, A-60
Auto Calc command (Calculate menu), 5-30
Auto Number Footnotes, 2-38
AVERAGE function, A-46
�? B �?
backing up
on 3.5-inch disk, 2-24
on hard disk, 2-24
bar charts, 5-40, 5-42 to 5-43
BEEP function, A-22
Boolean Logic. See AND function; OR function.
Borders command (Format menu), 5-27
breaks
removing, 2-41
setting page or column breaks, 2-41
Browse command (Layout menu), 6-8
�? C �?
Calculate Now command (Calculate menu), 5-30
case sensitivity, 2-35
functions and arguments, A-3
cell range
cutting, copying, clearing, and pasting, 5-13 to 5-16
described, 5-7
formulas, 5-55
sorting, 5-31 to 5-32
cells
adding borders, 5-26 to 5-27
addresses, 5-6
anchor, 5-7
changing appearance, 5-28 to 5-29
current, 5-6
cutting, copying, clearing, and pasting, 5-13 to 5-16
described, 5-6 to 5-7
filling down, 5-17 to 5-18
filling right, 5-17, 5-18 to 5-19
formats for, 5-22 to 5-27
formulas, 5-55
inserting and deleting, 5-19 to 5-21
moving contents of, 5-16 to 5-17
protecting from change, 5-32
sorting range of, 5-31 to 5-32
CHAR function, A-50
charts, 5-35 to 5-48, 5-59 to 5-61
axes, 5-60
bar, 5-40, 5-42 to 5-43
choosing scale, 5-59
choosing type, 5-40
color, 5-61
creating new, 5-35 to 5-38
label overruns, 5-60
line, 5-40, 5-44
parts of, 5-59 to 5-61
pie, 5-40, 5-41 to 5-42
revising, 5-38 to 5-40
scatter, 5-41, 5-45
title, 5-60
X,Y (line or scatter), 5-45 to 5-48
Check Document command (Spelling submenu), 2-27
CHOOSE function, A-22
Chooser command (Apple menu), 2-16
Claris products
inserting documents, 2-13
opening documents, 2-11
saving translators, 2-20 to 2-21
ClarisWorks Help, 1-21 to 1-22, 2-6 to 2-7
ClarisWorks Stationery (Save As pop-up menu), 2-25
Clear command (Edit menu), 3-10, 4-15, 5-15
Close command (File menu), 2-15, 2-16
CODE function, A-50
color
database fields, changing attributes, 6-40
graphics, filling objects, 4-20 to 4-22
spreadsheet charts, 5-61
text, changing, 3-17
COLUMN function, A-22 to A-23
Column Width command (Format menu), 5-26
columns
arranging database records, 6-38 to 6-39
breaks, setting and removing, 2-40 to 2-41, 3-14 to 3-15
changing number of, 3-25 to 3-26, 5-27 to 5-28
changing size, 5-25 to 5-26
hiding and restoring, 5-29
inserting and deleting, 5-19 to 5-21
layouts, 6-30 to 6-31
tables, 3-24 to 3-25
transposing, 5-16
Columns command (Format menu), 3-25
communications
described, 1-13 to 1-14
CONCAT function, A-50 to A-51
Copy command (Edit menu), 2-26, 3-11, 5-14 to 5-16, 6-16
Copy Ruler command (Format menu), 3-24
copying a document, 2-23 to 2-24
copying and pasting, 2-26 to 2-27
cells, 5-13 to 5-16
text, 3-11 to 3-12
copying format settings, 3-24
COS function, A-60
COUNT function, A-47
COUNT2 function, A-47
customizing, 2-36 to 2-54
adding automatic dates and times, 2-44 to 2-45
adding automatic page numbers, 2-43 to 2-44
adding headers or footers, 2-42 to 2-43
changing basic settings, 2-37 to 2-38
changing page settings, 2-39 to 2-40
changing ruler settings, 2-45 to 2-47
changing view of page, 2-47 to 2-48
hiding or showing tools and rulers, 2-48 to 2-49
setting page breaks, 2-40 to 2-41
setting custom zoom percentage, 2-50
splitting windows into panes, 2-51 to 2-52
stacking windows, 2-53 to 2-54
tiling windows, 2-52 to 2-53
working in multiple views, 2-50 to 2-51
zooming in and out, 2-49
Cut command (Edit menu), 2-26, 3-10 to 3-11, 3-25, 3-27, 4-15, 5-14 to 5-15, 6-16
cutting and pasting
for editing, 2-26 to 2-27
graphic objects, 4-15
spreadsheet data, 5-13 to 5-16
text, 3-11
cutting, copying, clearing, and pasting
database records, 6-19
�? D �?
data
constants, 5-8, 5-49
cutting, copying, clearing, and pasting, 5-13 to 5-16
date serial numbers, 5-49
editing, 5-12 to 5-13
entering, 5-8 to 5-9
finding, 5-21 to 5-22
searching for, 5-21 to 5-22
selecting, 5-12 to 5-13
series, 5-40, 5-59
time serial numbers, 5-49 to 5-50
types, 5-8, 5-49 to 5-50
database, 6-5 to 6-54
Browse command, 6-8
described, 1-11 to 1-12, 6-6
fields, 6-7 to 6-8, 6-10 to 6-16, 6-48, 6-52 to 6-53
Find command, 6-9
formulas, 6-12 to 6-13, 6-51
functions, A-3 to A-62
hiding status panel in, 2-49
labels, 6-31 to 6-33
Layout command, 6-9
layouts, 6-9, 6-28 to 6-49
mail merge, 1-15
multiple views in, 2-50
new, 6-8
numbers, 6-41, 6-52
printing, 2-20
records, 6-16 to 6-28, 6-50 to 6-51
ruler divisions in, 2-46
searches, complex, 6-50 to 6-51
sliding objects, 6-37 to 6-38
date
automatic, 2-38, 2-44 to 2-45
database, 6-15 to 6-16, 6-42, 6-52
fixed, 2-45
format, 2-38
in headers or footers, 2-44 to 2-45
serial numbers, 5-49
spreadsheet, 5-49, 5-58
DATE function, A-13
DATETOTEXT function, A-13 to A-14
DAY function, A-14
DAYNAME function, A-14
DAYOFYEAR function, A-15
Default Font command (Options menu), 5-24
Define Fields command (Layout menu), 6-10, 6-11, 6-13
DEGREES function, A-61
delete. See Cut command, cutting, and pasting.
Delete Cells command (Calculate menu), 5-21
Delete Layout command (Layout menu), 6-33
delete, objects, 4-15
dictionaries
closing, 2-32
creating, 2-30
installing, 2-29
user, 2-31
DIF Format, 2-12
opening documents, 2-11
saving translator, 2-22
Display command (Options menu), 5-28
display pages, 2-40
document, types, illustrated, 1-4
Document command (Format menu), 2-39, 4-31, 5-27
documents, 2-5 to 2-54
arrow keys, 3-7 to 3-8
backing up, 2-23 to 2-24
changing appearance, 3-15 to 3-18
closing, 2-7 to 2-15
column break, 3-14 to 3-15
communications, 1-13 to 1-14
correcting and revising, 3-8, 3-10 to 3-12
creating new, 2-8 to 2-9
customizing, 2-36 to 2-54
cutting, copying, and pasting, 3-10 to 3-11
database, 1-11 to 1-12
defined, 2-7
deleting text in, 3-9 to 3-10
editing, 2-26 to 2-27
finding/changing, 2-34 to 2-35
font size and style, 3-15 to 3-17
footnotes, 3-26 to 3-27
format changes, 2-10 to 2-11
format characters, 3-12 to 3-13
formatting, 3-18 to 3-24
graphics, 1-7 to 1-8, 4-5
Help system, 2-6 to 2-7
inserting graphics, 3-27
inserting whole, 2-13 to 2-14
invisible characters in, 2-36
line spacing, 3-20 to 3-21
linked text frames, 7-4 to 7-8
margins. See margins.
merging data with. See mail merge.
moving text in, 3-11
numbering. See numbers.
opening, 2-6 to 2-13
operators, 6-24
page breaks, 3-14 to 3-15
page guides, 3-13 to 3-14
page setup. See page setup.
page viewing, 3-14
pages, working with, 3-13 to 3-14
paragraph settings, 3-18 to 3-21
paragraphs, 3-7, 3-18 to 3-20
preset options, 3-5
renaming, 2-9
saving. See saving.
selecting text, 3-8 to 3-9
spreadsheet, 1-9 to 1-10
stationery, 2-24 to 2-26
tables in, 3-24 to 3-25
tabs in, 3-22 to 3-23
text insertion point, 3-6 to 3-7
text ruler, 3-18
text tool, 1-17
text, new, 3-5 to 3-6
types, illustrated, 1-4
word processing (text), 1-5 to 1-6, 3-5
word wrap, 3-7
writing in, 3-6 to 3-7
drawing tools, 1-16 to 1-18, 4-7 to 4-8
constraining, 4-12 to 4-13
drawing arc with, 4-9
drawing frames with, 4-8
drawing freehand with, 4-11
drawing lines, rectangles, or ovals with, 4-9
drawing polygons with, 4-9 to 4-10
filling shapes with, 4-11 to 4-12
locking with, 4-11
preset options, 4-11
reshaping with, 4-12
duplicate, objects 4-12
Duplicate command (Edit menu), 4-12
Duplicate Record command (Browse) (Edit menu), 6-17
�? E �?
Edit Macros command (File menu), 7-17 to 7-18
editing, 2-26 to 2-27
EPS(F) Format
inserting documents, 2-13
opening documents, 2-10
ERROR function, A-23
EXACT function, A-51
EXP function, A-39
exporting data. See translators.
�? F �?
FACT function, A-39 to A-40
Field Format command (Options menu), 6-41 to 6-42
fields, 6-10 to 6-16
adding date and time, 6-15
calculation, 6-11 to 6-13, 6-53
copying or moving data, 6-16
creating new, 6-10 to 6-11
date, 6-15, 6-52
definitions, 6-7, 6-13 to 6-14
deleting, 6-14
described, 6-7
editing text in, 6-16
number, 6-15, 6-52
selecting, 6-15
summary, 6-48, 6-53
text, 6-15 to 6-16, 6-52
time, 6-53
types, 6-52 to 6-53
typing data in, 6-14 to 6-16
file formats
documents, 2-9, 2-11, 2-21 to 2-26
graphics, 2-11
text, 2-12 to 2-13
fill, objects. See objects, filling with pattern and color.
Fill Down command (Calculate menu), 5-18, 5-48
Fill Right command (Calculate menu), 5-19
Find Again command (Find/Change submenu), 2-35
Find command (Layout menu), 6-9, 6-22
FIND function, A-52
Find Selection command (Find/Change submenu), 2-35
Find/Change command (Edit menu), 5-22
Find/Change command (Find/Change submenu), 2-34
Find/Change submenu, 2-34
finding
database records, 6-21 to 6-24
versus matching, 6-50 to 6-51
finding and changing
information, 2-34 to 2-35
invisible characters, 2-36
selected text, 2-35 to 2-36
text by hand, 2-36
Flip Horizontal command (Arrange menu), 4-18
Flip Vertical command (Arrange menu), 4-18
Font menu, 3-16
Font submenu (Format menu), 6-40
fonts
database, changing field attributes, 6-40
preset, 3-5, 3-15
size and style, 3-15 to 3-17
substitution, 2-18
footers
adding, 2-41 to 2-43
database, 6-44 to 6-45
date or time in, 2-44 to 2-45
page, 6-45
page numbers in, 2-44
viewing on screen, 2-50 to 2-51
footnotes
adding and removing, 3-26 to 3-27
automatic numbering of, 2-38
format characters, 3-12 to 3-13
formats. See file formats.
formatting. See rulers.
formulas
cell references, 5-55 to 5-56
cutting, copying, clearing, and pasting, 5-13 to 5-16
database, 6-11 to 6-13
editing, 5-13
entering, 5-9 to 5-11
parts of, 5-52
precedence, 5-54 to 5-55
spreadsheet, 5-47 to 5-48, 5-51
types of operators, 5-52 to 5-54
types of results, 5-52
See also spreadsheet formulas; spreadsheet functions; functions; spreadsheet.
FRAC function, A-40
Fractional Character Widths, 2-38
Frame Links command (Options menu), 7-4, 7-10, 7-12
frames, 1-17, 7-4 to 7-14
changing appearance and size, 7-14
changing spreadsheets, 4-24 to 4-25
drawing, 4-8, 7-4 to 7-7, 7-12
linking spreadsheet, 7-9 to 7-12
linking text, 7-4 to 7-9
making charts, 7-13
objects within other frames, 7-13
opening spreadsheet, 7-12
returning to and from documents, 7-14
spreadsheet, 3-24 to 3-25, 3-27
text. See text frames.
within other frames, 7-13
freehand tool, 4-11
functions, spreadsheet, A-2 to A-62
arguments (values), 5-57
Business and Financial, 5-58, A-6 to A-12
constants, 5-58
Date and Time, 5-58, A-12 to A-21
described, A-3
entering, 5-10 to 5-11
errors, A-5
how to use, A-4
Information, 5-58, A-21 to A-33
Logical, 5-58, A-33 to A-38
Numeric, 5-58, A-39 to A-46
Statistical, 5-58, A-46 to A-49
terminology, A-3
Text, 5-58, A-50 to A-58
Trigonometric, 5-58, A-58 to A-62
types by category, 5-58, A-5 to A-6
See also specific functions.
FV (Future Value) function, A-6 to A-7
�? G �?
Go To Record command (Organize menu), 6-26
graphics, 4-4 to 4-35
arrow pointer, 1-16
clip art, 4-33 to 4-34
creating multipage spread, 4-31 to 4-32
described, 1-7 to 1-8, 4-5
drawing tools, 1-16 to 1-18, 4-7 to 4-8
grid, 4-16
tool, 1-16, 4-7
graphics tool, 7-10
graphs. See charts.
grid
aligning objects to, 4-17 to 4-18
auto, 4-16 to 4-17
handles, 4-5 to 4-6, 4-9, 4-27
hiding, 4-16
line attributes, 4-9, 4-11, 4-22 to 4-24
Group command (Arrange menu), 4-30
�? H �?
headers
adding, 2-41 to 2-42, 6-45
database, 6-43
date or time in, 2-44 to 2-45
page, 6-43
page numbers in, 2-44
viewing on screen, 2-50 to 2-51
Help
arranging windows in, 2-7
online, 1-21 to 1-22, 2-6 to 2-7
opening and using, 2-6 to 2-7
Hide Graphics Grid command (Options menu), 4-16
Hide Rulers command (View menu), 2-49
Hide Selected Records command (Organize menu), 6-19
Hide Tools command (View menu), 2-48
Hide Unselected Records command (Organize menu), 6-19
HLOOKUP function, A-23 to A-25
HOUR function, A-15
�? I �?
I-beam pointer, 1-17, 3-7 to 3-8
IF function, A-33 to A-34
ImageWriter
labels, 2-20
page breaks, 2-19
Import Options flag, 2-11 to 2-12
importing data, 2-13
INDEX function, A-25 to A-26
Information functions, A-21 to A-33
Insert Break command (Format menu), 2-41, 3-15
Insert Cells command (Calculate menu), 5-19, 5-20
Insert command (File menu), 2-14, 2-43, 4-34
Insert Date command, 2-45
Insert Field command (Layout menu), 6-36, 6-48
Insert Footer command (Format menu), 2-42, 2-44 to 2-45
Insert Footnote command (Format menu), 3-26
Insert Header command (Format menu), 2-42, 2-44 to 2-45
Insert Page # command (Edit menu), 2-44
Insert Part command (Layout menu), 6-45, 6-47
Insert Time command (Edit menu), 2-45
Install Dictionaries command (Spelling submenu), 2-29 to 2-30, 2-32
INT function, A-40 to A-41
invisible characters, 2-36
IRR (Internal Rate of Return) function, A-7 to A-8
ISBLANK function, A-34
ISERROR function, A-35 to A-36
ISLOGICAL function, A-35
ISNA function, A-37
ISNUMBER function, A-37
ISTEXT function, A-37 to A-38
�? J,K �?
justification, text, 3-22
�? L �?
labels
creating in database layouts, 6-31 to 6-33
overruns in spreadsheet charts, 5-60
printing, 2-19 to 2-20, 6-31 to 6-33
LaserWriter, 2-16
font substitution, 2-18
percentage reductions and enlargements, 2-17
printing fractional character widths, 2-38
printing from, 2-19
Layout command (Layout menu), 6-9
Layout Info command (Layout menu), 6-34, 6-38 to 6-39
layouts, 6-7, 6-28 to 6-49
adding and deleting fields, 6-35 to 6-36
adding borders around fields, 6-37
arranging records, 6-38 to 6-39
body parts, 6-44
changing appearance of data, 6-40 to 6-42
changing number, date, and time formats, 6-41 to 6-42
changing size of a field, 6-36
changing space when printing, 6-37 to 6-38
columnar, 6-30 to 6-31
creating new, 6-28 to 6-29
deleting, 6-33
described, 6-7, 6-28
duplicating, 6-33
footers, 6-44 to 6-45
headers, 6-43, 6-45
rearranging and customizing, 6-34 to 6-39
renaming, 6-34
resizing and deleting parts, 6-49
setting text attributes, 6-40
summary parts, 6-44 to 6-49
tiling windows, 6-35
types, 6-29 to 6-30
understanding parts, 6-43 to 6-45
using parts to organize data, 6-43 to 6-49
LEFT function, A-53
LEN function, A-52
line attributes
adding arrowheads, 4-24
changing, 4-22 to 4-24
changing pen color, 4-22 to 4-24
changing pen pattern, 4-22 to 4-24
changing pen width, 4-22 to 4-24
drawing, 4-7, 4-9, 4-11
preset options, 4-24
line charts, 5-40, 5-44
X-Y charts, 5-45 to 5-48
line spacing
changing, 3-20 to 3-21
preset, 3-5
line tool, 4-9, 4-12
List View command (Layout menu), 6-20
LN function, A-41
Load Macros command (Macros submenu), 7-20
Lock command (Arrange menu), 4-32
LOG function, A-41 to A-42
LOG10 function, A-42
Logical functions, A-33 to A-38
LOOKUP function, A-26 to A-27
LOWER function, A-53
�? M �?
MacPaint
bitmap printing, 2-18
inserting documents, 2-13
opening documents, 2-11
MACRO function, A-28
Macro Wait command (Macros submenu), 7-16
macros, 7-15 to 7-20
creating new, 7-15 to 7-16
deleting, 7-18
described, 7-15
editing, 7-17 to 7-18
opening set of, 7-20
saving set of, 7-18 to 7-19
using, 7-16 to 7-17
Macros submenu (File menu), 7-15 to 7-20
MacWrite
inserting documents, 2-13
opening documents, 2-11
saving translator, 2-20
mail merge, 7-20 to 7-26
changing type style, 7-25
closing without printing, 7-25
defining database document, 7-22
defining text document, 7-22
described, 7-20 to 7-21
inserting fields into text, 7-23 to 7-25
setting up, 7-22 to 7-23
steps, 7-21
Mail Merge command (File menu), 7-23
mailing labels, 6-31 to 6-33
Make Chart command (Options menu), 5-36, 5-41, 5-48, 7-13
margins
changing, 3-18 to 3-20
hiding, 1-20
preset, 3-5 to 3-6
screen display, 2-40, 2-47 to 2-48
text, 3-13 to 3-14
word processing (text), 1-19 to 1-20, 2-45 to 2-47
MATCH function, A-28 to A-29
Match Records command (Browse) (Organize menu), 6-50
matching and finding records, 6-50 to 6-51
MAX function, A-47 to A-48
measurements
for ruler settings, 2-45 to 2-47
for unit abbreviations, 2-39
Microsoft products
inserting documents, 2-13
opening documents, 2-11
saving translator, 2-20
MID function, A-54
MIN function, A-48
MINUTE function, A-15 to A-16
MIRR (Modified Internal Rate of Return) function, A-8 to A-9
MOD function, A-42 to A-43
Modify Arc command (Options menu), 4-26
Modify Chart command (Options menu), 5-38 to 5-40
Modify Frame command (Options menu), 3-24, 4-24, 7-12
MONTH function, A-16
MONTHNAME function, A-16
Move Backward command (Arrange menu), 4-19
Move command (Calculate menu), 5-16
Move Forward command (Arrange menu), 4-19
Move to Back command (Arrange menu), 4-19, 7-13
Move to Front command (Arrange menu), 4-19
multipage spread, 4-31 to 4-32
�? N �?
NA function, A-29 to A-30
New command (File menu), 2-8
New Layout command (Layout menu), 6-29, 6-31, 6-33
New Record command (Browse) (Edit menu), 6-17
New Request command (Edit menu), 6-23
New View command (View menu), 2-50
NOT function, A-38
NOW function, A-17
NPER (Number of Periods) function, A-9
NPV (Net Present Value) function, A-10
Number command (Format menu), 5-23
numbers
database, 6-41
page, 2-40, 2-43 to 2-44
spreadsheet, 5-22 to 5-24, 5-49 to 5-51
Numeric functions, A-39 to A-46
NUMTOTEXT function, A-54
�? O �?
objects
adjusting corners, 4-25 to 4-26
aligning, 4-17 to 4-18
aligning to grid, 4-17
arcs, 4-9, 4-26, 4-28 to 4-29
arranging, 4-15
changing appearance, 4-20 to 4-22
changing orientation, 4-18 to 4-19
combining, into group, 4-30 to 4-31
described, 4-5
drawing, 4-7 to 4-12
duplicating, 4-12
filling with patterns or color, 4-11 to 4-12, 4-20 to 4-22
flipping, 4-18
frames, 4-8
freehand, 4-11, 4-28 to 4-30
imported, 4-34
inserting into documents, 2-44, 3-27
locking, 4-32 to 4-33
moving, 4-15 to 4-16
ovals, 4-9
overlapping, 4-19
polygons, 4-9 to 4-10, 4-12, 4-28 to 4-29
rectangles, 4-9, 4-25 to 4-26
removing or undoing, 4-15
reshaping, 4-12, 4-25 to 4-26, 4-30
resizing, 4-27 to 4-28, 4-34
rotating, 4-19
selecting and deselecting, 2-38, 4-5 to 4-6, 4-13 to 4-14
sliding, 6-38
smoothing, 2-18
spreadsheet frames, 4-24 to 4-25
squares, 4-25 to 4-26
stacking order, 4-6, 4-19
Open command (File menu), 2-8, 2-10 to 2-11
Open Frame command (View menu), 7-12
opening, 2-6 to 2-14
ClarisWorks documents, 2-9 to 2-10
ClarisWorks Help, 2-6
documents, 2-10 to 2-12
new documents, 2-8
non-ClarisWorks documents, 2-10 to 2-12
operations, precedence of, 5-54 to 5-55
operators, 6-24
OR function, A-38
oval tool, 4-9
�? P �?
page
breaks, 2-40 to 2-41
columns. See columns.
guides, 1-19 to 1-20, 3-5 to 3-6, 3-13 to 3-14
margins. See margins.
numbers, 2-40 to 2-41, 2-43 to 2-44
range, 2-20
settings, changing, 2-39 to 2-40
view, 1-20 to 1-21, 2-47 to 2-48
page layout
frames in graphics document, 7-4
multipage spreads, 4-31 to 4-32
page numbers
automatic, 2-43 to 2-44
fixed, 2-44
in headers or footers, 2-44
starting, 2-40
page setup
automatic dates and times, 2-37, 2-44 to 2-45
automatic footnote numbering, 2-38
automatic page numbers, 2-43 to 2-44
bitmap printing, 2-18
changing page settings, 2-39 to 2-41
cover page, 2-20
font substitution, 2-18
graphics, 2-18, 2-38
headers or footers, 2-42 to 2-43
numbering title page, 2-40
page breaks, 2-41
paper size, 2-17, 2-19
preset options, 2-16, 2-20
printer effects, 2-18 to 2-19
reduction and enlargement, 2-17
saving changes, 2-19
setting or removing breaks, 2-40 to 2-41
shift constraint, 2-38
smart quotes, 2-37
starting page number, 2-40
text or graphics smoothing, 2-18
Page Setup command (File menu), 2-17
page view
changing, 5-34 to 5-35
closing panes, 5-34
splitting, 5-33 to 5-34
switching, 5-35
See also spreadsheet.
Page View command (View menu), 2-47, 5-35
panes, 1-18, 2-51 to 2-52
paper size, 2-17, 2-19
paragraphs
changing settings, 3-18 to 3-20
copying format, 3-24
creating, 3-7
ruler settings, 2-45 to 2-46
Paste command (Edit menu), 2-26, 3-11 to 3-12, 3-25, 5-14 to 5-15, 6-16
Paste Function command (Edit menu), 5-10
Paste Special command (Edit menu), 5-15 to 5-16
PI function, A-43
PICT Format
inserting documents, 2-13
opening documents, 2-11
pie charts, 5-40 to 5-42
Play Macro command (File menu), 7-17
PMT (Payment) function, A-10 to A-11
polygon
closing, 4-10
tool, 4-9
precedence of operations, 5-54 to 5-55
Preferences command (Edit menu), 2-37, 4-10, 4-13, 4-27
Print command (File menu), 2-19
printer
choosing, 2-15 to 2-16
options, 2-16
See also page setup.
printing, 2-19 to 2-20
bitmap, 2-18
choosing a printer, 2-15 to 2-16
fractional character widths, 2-38
page setup for. See page setup.
removing space in database layouts, 6-37 to 6-38
PRODUCT function, A-48
PROPER function, A-55
Protect Cells command (Options menu), 5-32
PV (Present Value) function, A-11
�? Q �?
quotation, 6-12
quotation marks
double, 2-37, 5-44, 5-49, 5-53
formula, 5-44
single, in formulas, 6-12
smart, 2-37
quotations
indenting, 3-18
�? R �?
RADIANS function, A-61
RAND function, A-43 to A-44
range. See cell range.
RATE function, A-12
Record Macro command (Macros submenu), 7-15
records, 6-16 to 6-28
activating, 6-15
changing tab order, 6-17, 6-20 to 6-21
creating new, 6-16 to 6-17
cutting, copying, and pasting, 6-19
deleting, 6-19
described, 6-6
duplicate, 6-17
find request, 6-22
finding, 6-21 to 6-26
hiding, 6-19
matching, 6-50 to 6-51
moving, 6-18
moving between, 6-17 to 6-18
multiple find requests, 6-23, 6-25
omitting, 6-25
renumbering, 6-17
search criteria, 6-21 to 6-22
search fields, 6-22, 6-23
rectangle tool, 4-9
Redo command (Edit menu), 3-10
Remove All Breaks command (Options menu), 2-41
Remove Page Break command (Options menu), 2-41, 5-33
renaming documents, 2-9
REPLACE function, A-55
REPT function, A-55 to A-56
Reshape command (Edit menu), 4-28
RIGHT function, A-56
Rotate command (Arrange menu), 4-19
Round Corners command (Options menu), 4-25
ROUND function, A-44
ROW function, A-30
Row Height command (Format menu), 5-26
rows
changing number of, 5-27 to 5-28
changing size, 5-25 to 5-26
described, 5-6
hiding and restoring, 5-29
inserting and deleting, 5-19 to 5-21
transposing, 5-16
RTF Format
opening documents, 2-11
saving translator, 2-21
ruler
hiding or showing, 2-48 to 2-49
measurements and divisions, 2-45 to 2-47, 4-15, 4-17
preset, 3-5
settings and controls, 2-45 to 2-47
text, 1-6, 3-18 to 3-20, 3-24
Rulers command (Format menu), 2-45, 4-15
�? S �?
Save As command (File menu), 2-23, 2-25, 7-7
Save As pop-up menu, 2-25
Save As pop-up menu (File menu), 7-8
Save command (File menu), 2-21 to 2-22
Save Macros command (Macros submenu), 7-19
Save versus Save As, 2-23
for use in other applications, 2-22
saving, 2-20 to 2-24
changes to page setup, 2-19
file translation (saving out), 2-12, 2-23
first time, 2-21
importance of, 2-20
preferences in stationery, 2-25
previously saved document, 2-22
under different name, 2-22
when closing documents, 2-15
when disk is full, 2-23
Scale Selection command (Options menu), 4-27 to 4-28
scatter charts, 5-41, 5-45
X-Y charts, 5-45 to 5-48
screen setup
changing ruler settings, 2-45 to 2-47
changing view of page for, 2-47 to 2-48
hiding or showing tools and rulers, 2-48 to 2-49
margin display, 2-40
page display, 2-40
page guide, 2-40
setting custom zoom percentage, 2-50
splitting windows into panes, 2-51 to 2-52
stacking windows, 2-53 to 2-54
tiling windows, 2-52 to 2-53
working in multiple views, 2-50 to 2-51
zooming in and out, 2-49
searching
and replacing. See finding and changing.
database, 6-21 to 6-23, 6-50 to 6-51
for information, 2-34
for invisible characters, 2-36
spreadsheet data, 5-21 to 5-22
SECOND function, A-17
Select All command (Edit menu), 3-9, 3-20 to 3-21, 4-14, 4-32, 5-26
shift constraint, 2-38
Show All Records command (Organize menu), 6-20, 6-23, 6-25
Show Clipboard command (Edit menu), 3-10
Show Graphics Grid command (Options menu), 4-16
Show Margins, 2-40
Show Page Guides, 2-40
Show pop-up menu, 2-11, 2-14, 2-22
Show Rulers command (View menu), 2-49, 3-18, 3-20, 3-22
Show Tools (View menu), 7-14
Show Tools command (View menu), 2-48, 3-24, 5-38 to 5-39, 7-4, 7-10, 7-13
SIGN function, A-45
SIN function, A-62
Size menu, 3-16
Size submenu (Format menu), 6-40
sliding objects, 6-37 to 6-38
Smart Quotes, 2-37
Smooth command (Edit menu), 4-29
Sort command (Calculate menu), 5-31
Sort Records command (Organize menu), 6-27, 6-48
sorting
database records, 6-26 to 6-28
range of cells, 5-31 to 5-32
Spacing submenu, 6-40
spell checking
creating a user dictionary, 2-30
installing a dictionary, 2-29 to 2-30
working with a user dictionary, 2-31 to 2-32
Spelling submenu (Edit menu), 2-27, 2-29 to 2-33
splitting windows, 2-51 to 2-52
spreadsheet, 1-9, 5-5 to 5-61
calculating and recalculating, 5-30
calculating formulas, 6-11 to 6-13
cell range, 5-7, 5-13 to 5-16, 5-31 to 5-32
cell references, 5-55 to 5-57
cells, 5-6 to 5-7, 5-13, 5-16 to 5-21, 5-28, 5-31 to 5-33
changing appearance, 4-24 to 4-25, 5-22, 5-24 to 5-29
changing size, 5-27 to 5-28
charts, 5-35 to 5-48, 5-59 to 5-61
columns, 5-6, 5-16, 5-19 to 5-21
cutting, copying, clearing, and pasting, 5-13 to 5-16
data, 5-8 to 5-9, 5-12 to 5-16, 5-21 to 5-22
data entry bar, 5-7, 5-13
data types, 5-49 to 5-50
described, 1-9 to 1-10, 5-5
display, 5-28 to 5-29
formats, 2-10 to 2-11
formulas, 5-9 to 5-10, 5-51 to 5-55
frames, 3-24 to 3-25, 3-27, 4-24 to 4-25
functions, 5-10 to 5-11, 5-57 to 5-58, A-3 to A-62
linking frames, 7-9 to 7-12
number formats, 5-22 to 5-24, 5-50 to 5-51
numbers, 5-22 to 5-24, 5-49 to 5-50
page breaks, 5-33
page view, 5-33 to 5-35
pasting in, 5-13 to 5-16
revising, 5-12 to 5-21
rows, 5-6 to 5-7, 5-16, 5-19 to 5-21, 5-25 to 5-28
values, pasting, 5-14 to 5-15
spreadsheet tool, 1-17, 4-7, 7-10
SQRT function, A-45
Stack Windows command (View menu), 2-54
Starting Page Number, 2-40
stationery, 2-24 to 2-26
Statistical functions, A-46 to A-49
STDEV function, A-49
Style menu, 3-16
Style submenu (Format menu), 6-40
SUM function, A-49
SYLK Format, 2-12
opening documents, 2-11
saving translator, 2-22
synonyms, finding, 2-32 to 2-34
�? T �?
Tab Order command (Layout menu), 6-20
tables, 3-24 to 3-25
tabs
database, changing order, 6-20 to 6-21
text, 3-22 to 3-23
TAN function, A-62
templates. See stationery.
text
alignment, 3-21 to 3-22
ASCII. See ASCII.
database, 6-40, 6-52
document, 1-5 to 1-6, 1-16 to 1-17, 3-5 to 3-27, 7-4 to 7-9
frames, 7-4 to 7-9
inserting into documents, 2-43
linking frames, 7-4 to 7-8
smoothing, 2-18
Text Color submenu (Format menu), 6-40
Text Color submenu (Style menu), 3-17
Text functions, A-18 to A-19, A-50 to A-58
text margins
changing, 3-14, 3-18 to 3-20
hiding, 1-20 to 1-21, 3-13 to 3-14
preset, 1-19 to 1-20, 3-5 to 3-6, 3-13
text ruler
changing paragraph settings, 3-18 to 3-20
copying format settings, 3-24
format options, 3-18
preset, 3-5 to 3-6
text tool, 1-17, 4-7, 7-4
TEXTTODATE function, A-18
TEXTTONUM function, A-57
TEXTTOTIME function, A-18 to A-19
thesaurus, 2-32 to 2-34
Thesaurus command (Spelling submenu), 2-33
TIFF Format
inserting documents, 2-13
opening documents, 2-11
Tile Windows command (View menu), 2-53
tiling
database layouts, 6-35
time
automatic, 2-44 to 2-45
database fields, 6-15 to 6-16, 6-42, 6-53
functions, A-12 to A-21
in headers or footers, 2-45
TIME function, A-18
time serial numbers, 5-49 to 5-50
TIMETOTEXT function, A-19
title page, 2-40
tool(s)
fill and pen, 1-16, 1-18, 4-7
graphics, 1-16, 4-7, 7-10
line, 4-9, 4-12
palette, 1-16 to 1-18, 4-5
pen, 4-7, 4-22
spreadsheet, 1-17, 4-7, 7-10
text, 1-17, 4-7
See also graphics tools.
transfer. See importing data, translators.
translators
file (saving out), 2-12, 2-22
file format, defined, 2-10
for spreadsheet applications, 2-12
other, 2-13
Trigonometric functions, A-58 to A-62
TRIM function, A-57 to A-58
TRUNC function, A-45 to A-46
Turn Autogrid Off command (Options menu), 4-17
TYPE function, A-30 to A-31
�? U �?
Undo command (Edit menu), 3-10, 4-15, 4-31
Ungroup command (Arrange menu), 4-31
Unlock command (Arrange menu), 4-33
Unprotect Cells command (Options menu), 5-33
Unsmooth command (Edit menu), 4-30
UPPER function, A-58
User Dictionary command (Spelling submenu), 2-31
�? V �?
VAR function, A-49
View Scale command (View menu), 2-50
VLOOKUP function, A-31 to A-33
�? W,X �?
WEEKDAY function, A-20
WEEKOFYEAR function, A-20
windows
arranging Help, 2-7
closing, 2-14 to 2-15
described, 1-4, 1-18 to 1-19
panes, 1-18, 2-51 to 2-52
splitting, into panes, 1-18, 2-51 to 2-52
stacking, 2-53 to 2-54
text page views, 3-5, 3-14
tiling, 2-52 to 2-53
working in multiple, 1-19, 2-50 to 2-51
zooming. See zooming.
Word Perfect
inserting documents, 2-13
opening documents, 2-11
saving translator, 2-21
word processing, 3-4 to 3-28
described, 1-5 to 1-6, 3-5
I-beam pointer, 1-17, 3-7 to 3-8
text tool, 1-17
Word Processing (Text) document, 1-5
word wrap, 3-7
WriteNow
inserting documents, 2-13
opening documents, 2-11
saving translator, 2-21
X-Y charts, 5-45 to 5-48
�? Y �?
YEAR function, A-20 to A-21
�? Z �?
zoom controls, 2-49, 4-32
zooming
in and out, 1-18 to 1-19, 2-49
percentage box, 2-49
reduction and enlargement, 2-49
setting custom percentage, 2-50