Create an account
Predefined formulas that perform common business calculations, and which typically involve a period of time such as months or years.
Future value (Fv)
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.
An Excel function that calculates the payment for a loan based on constant payments and at a constant interest rate.
An optional argument in the PMT function that assumes that the payment will be made at the end of each time period.
The process of changing the values in cells to see how those changes affect the outcome of formulas in the worksheet.
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.
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.
A word or string of characters that represents a cell, a range of cells, a formula, or a constant value is a defined:
In the Cell Styles gallery, the Currency  style and the Comma  style format the selected cell with how many decimal places?
A group of Excel functions that look up a value in a defined range of cells located in another part of the workbook to find a corresponding value is referred to as:
An Excel function that looks up values that are displayed vertically in a column is the:
A defined range of cells, arranged in a column or row, used in a VLOOKUP or HLOOKUP function, is called a table:
When creating a VLOOKUP or an HLOOKUP function, the one requirement is that the data in the table array is sorted in:
Please allow access to your computer’s microphone to use Voice Recording.
Having trouble? Click here for help.
We can’t access your microphone!
Click the icon above to update your browser permissions and try again
Reload the page to try again!Reload
Press Cmd-0 to reset your zoom
Press Ctrl-0 to reset your zoom
It looks like your browser might be zoomed in or out. Your browser needs to be zoomed to a normal size to record audio.
Please upgrade Flash or install Chrome
to use Voice Recording.
For more help, see our troubleshooting page.
Your microphone is muted
For help fixing this issue, see this FAQ.
Star this term
You can study starred terms together