Apply intermediate functions.
Application of intermediate spreadsheet functions includes, but is not limited to
- relative and absolute cell addressing
- macros
- 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.