Excel Chapter 4
In the Cell Styles gallery, the Currency [0] style and the Comma [0] style format the selected cell with how many decimal places
0
The process of examining a worksheet for errors in formulas.
Auditing
A range of cells that shows how changing certain values in your formulas affects the results of those formulas
Data table
A range of cells that shows how changing certain values in your formulas affects the results of those formulas, and that makes it easy to calculate multiple versions in one operation.
Data table
A technique to improve accuracy when completing a worksheet that controls the type of data or the values that are entered into a cell.
Data validation
Cells that contain formulas that refer to other cells are
Dependent cells
Predefined formulas that perform common business calculations, and that typically involve a period of time such as months or years.
Financial functions
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)
A method to find a specific value for a cell by adjusting the value of one other cell. With this, you can work backward from the desired outcome to find the number necessary to achieve your goal
Goal Seek
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
The amount charged for the use of borrowed money.
Interest
The abbreviation for number of time periods in various Excel functions.
Nper
An Excel function that calculates the payment for a loan based on constant payments and at a constant interest rate.
PMT function
Cells that are referred to by a formula in another cell are
Precedent cells
The total amount that a series of future payments is worth now.
Present value (Pv)
Another term for present value.
Principal
In the Excel PMT function, the term used to indicate the interest rate for a loan.
Rate
The location within which a name is recognized without qualification
Scope
The command that displays arrows to indicate what cells affect the value of the cell that is selected is
Trace Precedents
An indicator that shows the relationship between the active cell and its related cell.
Tracer arrow
An Excel function that looks up values that are displayed vertically in a column is the
VLOOKUP
A window that displays the results of specified cells.
Watch Window
The process of changing the values in cells to see how those changes affect the outcome of formulas in the worksheet.
What-if analysis
Tracer arrows are red if a cell contains
an Error Value
When you use a defined name in a formula, the result is the same as if you typed a
cell reference
A word or string of characters that represents a cell, a range of cells, a formula, or a constant value is a
defined name
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
lookup functions
A list of values that are acceptable for a group of cells is a
validation list
Loans are typically made for a period of
years
The future value at the end of a loan is typically
zero