GO! Microsoft Excel Chapt. 4 Matching

Card Set Information

Author:
joshrw1
ID:
43426
Filename:
GO! Microsoft Excel Chapt. 4 Matching
Updated:
2010-10-19 15:44:07
Tags:
GO Microsoft Excel Chapter Matching
Folders:

Description:
GO! Microsoft Excel Chapter 4 Matching
Show Answers:

Home > Flashcards > Print Preview

The flashcards below were created by user joshrw1 on FreezingBlue Flashcards. What would you like to do?


  1. Predefined formulas that perform common business calculations, and which typically involve a period of time such as months or years
    Financial functions
  2. The amount charged for the use of borrowed money
    Interest
  3. In the Excel PMT function, the term used to indicate the interest rate for a loan
    Rate
  4. The total amount that a series of future payments is worth now
    Present Value (Pv)
  5. Another term for present value
    Principle
  6. The abbreviation for number of time periods in various excel functions
    Nper
  7. The value at the end of the time periods in an excel function; the cash balance you want to attain after the last payment is made--usually zero for loans
    Future Value (Fv)
  8. The values that an excel function that uses to perform calculations or operations
    Data Table
  9. An Excel function that calculates the payment for a loan based on constant payments and at a constant interest rate
    PMT Function
  10. An optional argument in the PMT function that assumes that the payment will be made at the end of each time period
    Type Arguments
  11. The process of changing the values in cells to see how those changes affect the outcome of formulas in the worksheet
    What-if Analysis
  12. One of Excel's What-If Analysis tools that provides a method to find a specific value for a cell by adjusting the value of one other cell--you can find the right input when you know the result you want
    Goal Seek
  13. A range of cells that shows how changing certain values in your formulas affects the results of those formulas, and which makes it easy to calculate multiple versions in one operation
    Arguments
  14. A data table that changes the value in only one cell
    One Variable Data Table
  15. A data table that changes the values in two cells
    Two Variable Data Table

What would you like to do?

Home > Flashcards > Print Preview