Apple M9057 User Manual - Page 173
Entering functions, Paste Function
UPC - 718908500040
View all Apple M9057 manuals
Add to My Manuals
Save this manual to your list of manuals |
Page 173 highlights
Spreadsheet 7-27 AppleWorks provides over 100 functions in nine general categories. A complete list of these functions is in onscreen Help. Category Business and Financial Date and Time Information Logical Numeric Statistical Text Trigonometric Purpose Calculates mortgage and payment values Example PMT (Payment) Manipulates dates and times DATE Looks up and evaluates information in LOOKUP spreadsheet cells, cell ranges, and database fields Evaluates Boolean expressions, which result in ISBLANK either TRUE or FALSE Performs general mathematical calculations ROUND Calculates general statistics, such as standard AVERAGE deviation and variance Finds, compares, and manipulates text expressions CODE (ASCII code) Creates and evaluates mathematical and SIN scientific values Entering functions In the Help index,* see: E 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. * Choose Index from the or Help menu and scroll to the entry. Then choose a topic from the list and click Go To Topic.