Apple AppleWorks 5 : Windows 95/NT 4.0 User Manual
Page 161

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