Apple AppleWorks 5 : Mac OS - Manual (Page 174)

7-28 AppleWorks 5 User’s Manual
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.
3. Choose Paste Function from the Edit menu.
4. Select AVERAGE from the list and click OK.
5. Hold down the mouse button and drag the I-beam pointer in the entry bar to
select the sample values between the parentheses.
6. In the spreadsheet, hold down the mouse button and drag the pointer over the
three cells whose values you want to average, and then click to accept the
function.
AppleWorks replaces the sample values with the selected cell range and
displays the average value (85) of the selected cells as the result.
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
Select the sample values
but not the parentheses Address of cell where
function is stored