# Intro to IT_Ch.4 Study Guide

Predefined formulas that perform common business calculations, adn which typically involve a period of time such a months or years
Financial Function
The amount charged for the use of borrowed money
Interest
In the Excel PMT function, the term used to indicate the interest rate for a loan
Rate
The total amount that a series of future payments is worth now
Present Value
Another term for present value
Principal
The abbreviation for number of time periods in various Excel functions
Nper
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
Future Value
The values that an Excel function uses to perform calculations or operations
Aruments
An excel function that calculates the payment for a loan based on sconstant payments and at a constant interest rate
MPT Function
An optional argument in the PMT function that assumes that the payment will be made at the end of each time period
Type Argument
The process of changing the values in cells to see how those changes affect the outcome of forumlas in the worksheet
What if Analysis
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.
Goal Seek
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
Data table
A data table that changes the value in only one cell
One variable data table
A data table that changes the values in two cells
Two variable data table
Loans are typically made for period of
Years
The future value at the end of a loan is typically
Zero
A word or string of characters that represents a cell
Name
In cell styles gallery, the currency [0] style and the comma [0] style format the selected cell with how many decimal places?
When you use a defined name in a formula, the result is the same as if you typed a
Cell Reference
A group of excel functions that look up a value in a defined range of cells is called
Lookup Functions
An excel function that looks up values that are displayed vertically in a column is the
VLOOKUP Function
A defined range of cells arranged in a column or a row used in a VLOOKUP or HLOOKUP function is called a table
Array
A list of values that are acceptable for a group of cells is a
Validation List

Need essay sample on "Intro to IT_Ch.4 Study Guide"? We will write a custom essay sample specifically for you for only \$ 13.90/page

#### Can’t wait to take that assignment burden offyour shoulders?

Let us know what it is and we will show you how it can be done!
×
Sorry, but copying text is forbidden on this website. If you need this or any other sample, please register

No, thanks. I prefer suffering on my own
Sorry, but copying text is forbidden on this website. If you need this or any other sample register now and get a free access to all papers, carefully proofread and edited by our experts.
No, thanks. I prefer suffering on my own
Not quite the topic you need?
We would be happy to write it
Service Open At All Times
|