Excel Chapter 4 Quiz
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
When you use a defined name in a formula, the result is the same as if you typed a:
Cell reference
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 range of cells that shows how changing certain values in your formulas affects the results of those formulas.
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
A word or string of characters that represents a cell, a range of cells, a formula, or a constant value is a:
Defined name
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
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 word or string or characters in Excel that represents a cell, a range or cells, a formula, or a constant value.
Name
An element of the Excel window that displays the name of the selected cell, table, chart, or object.
Name Box
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 defined name is recognized without qualification—usually either to a specific worksheet or to the entire workbook.
Scope
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
A command that displays arrows that indicate what cells are affected by the value of the currently selected cell.
Trace Precedents command
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 list of values that are acceptable for a group of cells is a:
Validation list
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
Loans are typically made for a period of:
years
The future value at the end of a loan is typically:
zero