beautypg.com

Printing a spreadsheet document, Working with formulas, Understanding formulas – Apple AppleWorks 5 : Mac OS User Manual

Page 167

background image

Spreadsheet

7-21

Printing a spreadsheet document

You can control various aspects of how your spreadsheet document prints.

Working with formulas

Use formulas to perform calculations on spreadsheet data. You can combine
numbers, cell references, named cells or ranges and functions (predefined
formulas) to build your formulas. For some simple formula examples, see
“Examples: Entering formulas” on page 7-25.

Important The examples in this documentation are based on U.S.
conventions. For example, dates and numbers are shown in U.S. formats. In
English-speaking countries other than the United States, functions, formulas,
and calculations might be formatted differently. For example, in the U.S.,
commas act as separators in formulas. In other countries, semicolons might
be used as separators.

Understanding formulas

Within a single formula, you can calculate a result using:

1

values, such as $4.95, Ms. Jane Smith, or February 2, 1997

1

operators, such as +, -, *, =, >, or ()

1

cell references, such as B2, P66, or D7

1

functions, such as =SUM(B2+N66) or =PRODUCT(A1..C1)

1

named ranges

To print

Choose

Row and column titles on every page

Lock Title Position from the Options menu

The range of cells that you
specify, rather than all formatted
cells and cells that contain data

Set Print Range from the Options menu. In the
Print Range dialog box, click Print Cell Range, type
the range you want to print, and then click OK.

Row and column headings or the
cell grid

Click

on the Default button bar (or choose Print

from the File menu). In the dialog box, select or
deselect the Print Column Headings, Print Row Headings,
and Print Cell Grid checkboxes.

*

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

printing, spreadsheets

E

Set Print Range command

In the Help index,

*

see:

E

spreadsheets, calculations