Intro to IT_Ch.4 Study Guide – Flashcards
23 test answers
Unlock all answers in this set
Unlock answers 23question
Another term for present value
answer
Principal
Unlock the answer
question
The abbreviation for number of time periods in various Excel functions
answer
Nper
Unlock the answer
question
The value at the end of the time periods in an Excel function; the cash balance you want to ttain after the last payment is made - usually zero for loans
answer
Future Value
Unlock the answer
question
The values that an Excel function uses to perform calculations or operations
answer
Aruments
Unlock the answer
question
An excel function that calculates the payment for a loan based on sconstant payments and at a constant interest rate
answer
MPT Function
Unlock the answer
question
An optional argument in the PMT function that assumes that the payment will be made at the end of each time period
answer
Type Argument
Unlock the answer
question
The process of changing the values in cells to see how those changes affect the outcome of forumlas in the worksheet
answer
What if Analysis
Unlock the answer
question
One of excels what if analysis tools that provides a method to find a specific value for a cell by adjusting the value of another cell.
answer
Goal Seek
Unlock the answer
question
A range of cells that shows how changing certain vales in your formulas affects the results of those formulas, and which makes it easy to calculate multiple versions in one operation
answer
Data table
Unlock the answer
question
A data table that changes the value in only one cell
answer
One variable data table
Unlock the answer
question
A data table that changes the values in two cells
answer
Two variable data table
Unlock the answer
question
Loans are typically made for period of
answer
Years
Unlock the answer
question
The future value at the end of a loan is typically
answer
Zero
Unlock the answer
question
A word or string of characters that represents a cell
answer
Name
Unlock the answer
question
When you use a defined name in a formula, the result is the same as if you typed a
answer
Cell Reference
Unlock the answer
question
A group of excel functions that look up a value in a defined range of cells is called
answer
Lookup Functions
Unlock the answer
question
An excel function that looks up values that are displayed vertically in a column is the
answer
VLOOKUP Function
Unlock the answer
question
A defined range of cells arranged in a column or a row used in a VLOOKUP or HLOOKUP function is called a table
answer
Array
Unlock the answer
question
A list of values that are acceptable for a group of cells is a
answer
Validation List
Unlock the answer
