Quiz 4

________ is the process of examining a worksheet for errors in formulas.

Auditing

Apply styles to cells, such as Headings and Titles and Data and Model, by using the ________ command in the Styles group.

Cell Styles

A range of cells that shows how changing certain values in your formula affects the results of those formulas and that makes it easy to calculate multiple versions in one operation is a(n) ________.

Data Table

A technique to improve accuracy when entering data in a worksheet by controlling the type of data or the values that can be entered is called ________.

Data validation

Each of the following is a rule for defining names except: ________.

Defined names can contain spaces

The ________ command checks for common errors that occur when using formulas

Error Checking

In a cell that contains a function, to copy the VALUE to another to cell—rather than the function—use the ________.

Format Painter command

When you start typing a formula, such as =SUM(B Excel will display the ________, which contains all of Excel's built in functions starting with the letter B.

Formula Autocomplete list

In the Excel PMT function, the term used to indicate the interest rate for a loan is called ________.

Future Value (FV)

A method to find a specific value for a cell by adjusting the value of one other cell is ________.

Goal seek

The ________ function looks up values in a table array arranged in horizontal rows.

HLOOKUP

________ functions look up a value in a defined range of cells located in another part of the workbook to find a corresponding value

Lookup

cells are cells that are referred to by a formula in another cell.

Precedent

Cells that are referred to by a formula in another cell are called ________.

Precedent cells

In the Data Validation dialog box, you can create a ________ that will display when the cell is selected and that provides instructions to the person entering data.

Screentip

All of the following are methods to define a name for a cell or group of cells except: ________.

Select the range, click in the Formula bar, and then type the name

displays arrows that indicate what cells are affected by the value of the currently selected cell.

Trace Dependents command

A command that displays arrows to indicate what cells affect the value of the cell that is selected is the ________

Trace Precedents command

An Excel function that looks up values in a table array arranged as vertical columns is the ________ function

VLOOKUP

The process of changing the values in cells to see how those changes affect the outcome formulas in a worksheet is called ________.

What-If-Analysis

Using various interest rates to determine the amount of loan payments is an example of using ________.

What-If-Analysis

Use the ________ command to locate and resolve an error in a formula.

command to locate and resolve an error in a formula

A defined name provides a logical reference to ________.

data

A word or string of characters in Excel that represents a cell, a range of cells, a formula, or a constant value is called a ________.

defined name

An advantage to naming a range of cells is that you can use the name in a ________.

formula

A ________ triangle in the upper left corner of a cell indicates that the formula in the cell is suspect for some reason and could be a potential error.

green

For lookup functions to work properly, the data in the table array must be sorted

in ascending order

The amount charged for the use of borrowed money is called ________.

interest

To see how different interest rates affect a monthly payment, use a ________.

one-variable data table

To see how different interest rates and different payment periods will affect a monthly payment, use a ________.

one-variable data table

The total amount that a series of future payment is worth is called the ________.

principle

The Error Checking button displays as a ________.

red square

Excel's Formula Auditing features can show ________ between cells and formulas to ensure that formulas are logical and correct and also to resolve error messages.

relationships

The location within which a defined name is recognized without qualification is referred to as the ________.

scope

In a lookup formula, the defined range is referred to as the ________.

table array

An indicator that shows the relationship between the active cell and its related cell is called a(n) ________.

tracer arrow

Defined names can contain ________.

uppercase and lowercase letters

A ________ is a list of values that are acceptable for a range of cells.

validation list

The Future value (Fv) at the end of the time period in an Excel function is usually ________ for loans.

zero