Title: (Optional) Apply intermediate functions.
Course: Computer Information Systems (10005-I) > Section: Developing Electronic Spreadsheets

Application of intermediate spreadsheet functions should include, but not be limited to,

- relative and absolute cell addressing
- IF statements
- PMT–calculates the payment for a loan based on constant payment and a constant interest rate
- PV–returns the present value of an investment
- FV–returns the future value of an investment based on an interest rate and a constant payment schedule
- COUNT–counts the number of cells that meet the selected criteria
- COUNTIF–counts the number of cells in a range that meet the selected criteria.