Excel CH. 4

________ is the process of examining a worksheet for errors in formulas. (Segmenting, Tracing, Defining, Auditing)

Auditing

All of the following are methods to define a name for a cell or group of cells except: ________. (Group of answer choices: A. Select the range, open Name Manager, click New, and then type the name. | B. Select the range, click in the Formula bar, and then type the name. | C. Select the range, click in the Name box, and then type the name. | D. Select the range, click the Define Name button, and then type the name.)

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

Apply styles to cells, such as Headings and Titles and Data and Model, by using the ________ command in the Styles group. (Cell Styles, Conditional Formatting, Format as Table, Merge Styles)

Cell Styles

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 ________. (Goal Seek, Data validation, Data protection, What-If Analysis)

Data validation

The _______ command checks for common errors that occur when using formulas. (Hide Error, Audit, Error Checking, Seek Error)

Error Checking

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. (table array, Formula AutoComplete list, defined name, AutoFill)

Formula AutoComplete list

A method to find a specific value for a cell by adjusting the value of one other cell is ________. (Group of answer choices: lookup, protection, Goal Seek, validation)

Goal Seek

________ functions look up a value in a defined range of cells located in another part of the workbook to find a corresponding value. (Financial, Lookup, Statistical, Logical)

Lookup

In a cell that contains a function, to copy the VALUE to another to cell—rather than the function—use the ________. (Paste command, Format Painter command, Paste Special command to display commands for Paste Values, Paste Link command)

Paste Special command to display commands for Paste Values

_____ cells are cells that are referred to by a formula in another cell. (Dependent, Precedent, Trace, Related)

Precedent

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. (defined name, ScreenTip, cell reference, table array)

ScreenTip

________ displays arrows that indicate what cells are affected by the value of the currently selected cell. (Group of answer choices: Trace Dependents command | Trace Precedents command | Tracer Arrow | Trace Error command)

Trace Dependents

Use the ______ command to locate and resolve an error in a formula. (Find Error, Locate Error, Trace Error, Fix Error)

Trace Error

A command that displays arrows to indicate what cells affect the value of the cell that is selected is the ________. (Group of answer choices Trace Dependents command,Trace Precedents command, Trace Error command, Tracer command)

Trace Precedents

An Excel function that looks up values in a table array arranged as vertical columns is the ________ function. (COLUMN, VLOOKUP, HLOOKUP, MATCH)

VLOOKUP--V for Vertical

The process of changing the values in cells to see how those changes affect the outcome formulas in a worksheet is called ______. (Goal Seek, What-If Analysis, Lookup, Validation)

What-If Analysis

Using various interest rates to determine the amount of loan payments is an example of using (What-If Analysis, Protection, Validation, Lookup)

What-If Analysis

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 ________. (cell range, table array, validation list, defined name)

defined name

Each of the following is a rule for defining names EXCEPT: ________. (The letters C or R cannot be defined as a name. | The first character of a name must be a letter, underscore, or backslash. | Defined names can contain spaces. | A defined name can be no longer than 255 characters.)

defined named can contain spaces

A data tables is useful for all of the following except for ________. (Group of answer choices: calculating possible values for each argument, viewing and compare results, determining the Future value (Fv), calculating multiple versions in one operation)

determining the future value??

An advantage to naming a range of cells is that you can use the name in a ________. (data table, formula, table array, lookup table)

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. ( Group of answer choices: orange, green, red, blue)

green

For lookup functions to work properly, the data in the table array must be sorted ________. (by color, in reverse alphabetic order, in descending order, in ascending order)

in ascending order

The amount charged for the use of borrowed money is called ____. (capital, interest, Present value Pv, principal)

interest

To see how different interest rates affect a monthly payment, use a ______. (two-variable data table, one-variable data table, defined name, table array)

one-variable data table

Cells that are referred to by a formula in another cell are called ________. (dependent cells, precedent cells, Trace dependents, Trace precedents)

precedent cells

The total amount that a series of future payment is worth is called the _______. (principal, percentage, interest, rate)

principal

In the Excel PMT function, the term used to indicate the interest rate for a loan is called ________. (Present value Pv, rate, Future value Fv, payment period)

rate

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, links, pathways, sequences)

relationships

The location within which a defined name is recognized without qualification is referred to as the ____. (table array, cell range, formula, scope)

scope

In a lookup formula, the defined range is referred to as the ________. (table array, named range, validation list, defined name)

table array

An indicator that shows the relationship between the active cell and its related cell is called a(n) ________. (tracer arrow tracking arrow error triangle error diamond)

tracer arrow

To see how different interest rates *and different payment periods* will affect a monthly payment, use a ______. (two variable data table, one-variable data table, defined name, table array)

two-variable data table

Defined names can contain ________. (uppercase and lowercase letters with spaces | the letter C by itself | the same value as a cell reference, such as M$10 | uppercase and lowercase letters)

uppercase and lowercase letters

A ________ is a list of values that are acceptable for a range of cells. table array data table validation list cell range

validation list

The ______ function looks up values in a table array arranged in horizontal rows. (VLOOKUP, MATCH, LOOKUP, HLOOKUP)

HLOOKUP--H for Horizontal

A defined name provides a logical reference to ________. (Group of answer choices: data, tables, functions, formulas)

data

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, column, row, array)

data table

The Error Checking button displays as a _________. (purple arrow, blue circle, red square, yellow diamond)

yellow diamond

The Future value (Fv) at the end of the time period in an Excel function is usually ______ for loans. (twice the principal, zero, half the principal, the same as the principal)

zero