beautypg.com

Apple AppleWorks 5 : Windows 95/NT 4.0 User Manual

Page 161

background image

Spreadsheet

7-27

Entering functions

To enter a function:

1.

Click the cell where you want the result to appear.

If you’re including the function as part of a larger formula, click in the
formula where you want the function to appear.

2.

Choose Paste Function from the Edit menu (or click on the entry bar).

3.

Choose the type of function you want from the Category pop-up menu in the
Paste Function dialog box, select a function from the alphabetical list, and then
click OK.

4.

In the entry bar, select the sample values and replace them with values, named
cells, or cell references.

For more information, see “Naming cells and ranges” on page 7-12, and
“Cell references in formulas” on page 7-22.

5.

When you’re satisfied with your entry, click to confirm it.

Tip

If you know the name and format of a function, you can type it, rather

than paste it, in the entry bar.

Example: Using the AVERAGE function

This example shows how to use the AVERAGE function to calculate the
average of three numbers.

1.

In your spreadsheet, type

74

,

88

, and

93

in cells A1, B1, and C1.

2.

Click cell D1 to select it.

*

Choose Index from the Help menu and type the first few letters of the entry. Double-click the
entry and then double-click a topic.

In the Help index,

*

see:

E

functions

Select the sample values

Replace the sample values

Cell address of result

Function

Click to cancel or
confirm entry

Function’s result goes here

Numbers to average