Week 10 Chapter 7

12345678910111213141516
Across
  1. 5. Excel's What-If Analysis tools
  2. 6. equation that performs mathematical calculations
  3. 7. function that calculates payment of a loan
  4. 9. cells that contain formulas that refer to other cells
  5. 10. function that finds the position of an item in a range of cells
  6. 12. examining the worksheets for errors
  7. 14. used to perform calculations or operations
  8. 15. function that finds a value within a table based on relative row or column
  9. 16. word or string of characters that represents a range of cells
Down
  1. 1. cells that are referred to by a formula in another cell
  2. 2. looks up values that are displayed horizontally in a row
  3. 3. formula that excel cannot evaluate correctly
  4. 4. function that finds a value in a defined range of cells
  5. 6. value at the end of the time period in an Excel function
  6. 8. number of time periods
  7. 11. prebuilt formulas that perform common business calculations
  8. 13. amount charged for the use of borrowed money