Week 11 Chapter 7

12345678910111213141516
Across
  1. 1. cannot see data
  2. 3. total amount that a series of future payments that is worth now
  3. 9. A window that displays the results of spedified cells
  4. 10. used to perform calculations or operations
  5. 14. An indicator that shows the relationship between the active cell and its related cell
  6. 16. function looks up values in a table array arranged as vertical columns
Down
  1. 2. Cannot use a text field in a formula
  2. 3. function that calculates payment of a loan
  3. 4. defined range of cells
  4. 5. list of values that are acceptable for a group of cells
  5. 6. function that finds a value in a defined range of cells
  6. 7. location within which a defined name is recognized without qualification
  7. 8. changing values in cells to determine how those changes affect the outcome of a formula
  8. 11. equation that performs mathematical calculations
  9. 12. number of time periods
  10. 13. Cannot divide by zero
  11. 15. the excel PMT function