Apple M9057 User Manual - Page 174
Example: Using the AVERAGE function, select the sample values between the parentheses.
UPC - 718908500040
View all Apple M9057 manuals
Add to My Manuals
Save this manual to your list of manuals |
Page 174 highlights
7-28 AppleWorks 5 User's Manual Select the sample values Replace the sample values Cell address of result Function Click to cancel or confirm entry 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. Function's result goes here Numbers to average 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. Address of cell where function is stored Select the sample values but not 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.