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