ITE Chapter 7
In a cell that contains a function, to copy the VALUE to another to cell—rather than the function—use the ________.
??
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
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
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
An Excel function that looks up values in a table array arranged as vertical columns is the ________ function.
VLOOKUP
Using various interest rates to determine the amount of loan payments is an example of using ________.
What-if analysis
________ 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 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
Each of the following is a rule for defining names except: ________.
defined names can contain spaces
A data table is useful for all of the following except for ________.
determining the Future value (Fv)
The ________ command checks for common errors that occur when using formulas.
error checking
In the PMT function, if the Type argument is not specified, it assumes the payment will be made at the beginning of each period.
false
The HLOOKUP function looks up values in a table array arranged in vertical columns.
false
VLOOKUP function looks up values in a table array arranged as horizontal rows.
false
When borrowing money, the interest rate and number of periods is quoted in months.
false
An advantage to naming a range of cells is that you can use the name in a ________.
formula
A method to find a specific value for a cell by adjusting the value of one other cell is ________.
goal seek
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
________ cells are cells that are referred to by a formula in another cell.
precendent
The total amount that a series of future payment is worth is called the ________.
principal
In the Excel PMT function, the term used to indicate the interest rate for a loan is called ________.
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
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
A command that displays arrows to indicate what cells affect the value of the cell that is selected is the ________.
trace Precedents command
Use the ________ command to locate and resolve an error in a formula.
trace error
An indicator that shows the relationship between the active cell and its related cell is called a(n) ________.
tracer arrow
An advantage to naming a range of cells is that you can use the name in a formula in other parts of your workbook.
true
Auditing is the process of examining a worksheet for errors in formulas.
true
Data validation improves the accuracy of the person entering data into a worksheet.
true
Excel includes a group of Formula Auditing features, which consists of tools and commands that help you to check a worksheet for errors.
true
Goal Seek is part of a suite of data tools used for What-If Analysis.
true
Goal Seek is useful to determine how much you can borrow to stay within a budget.
true
If you create a defined name and then decide that you no longer need it, you can delete the name and its associated range reference.
true
In a Lookup formula, the defined range is referred to as the table array.
true
In the PMT function, the type argument indicates when the loan payment is due.
true
Present value (Pv) represents the amount of the loan before any payments are made.
true
The Error Checking command checks for common errors that occur in formulas.
true
The PMT function calculates the payment for a loan based on constant payments and at a constant interest rate.
true
The Watch Window displays the results of specified cells.
true
The Watch Window is useful to monitor cells in one part of a workbook while working on another part of the workbook.
true
The data in a table array, which can be numbers or text, must be sorted in ascending order.
true
The first step in using a lookup function is to define the range of cells that will serve as the table array.
true
With Goal Seek, you can work backward from the desired outcome to find the number necessary to achieve your goal.
true
To see how different interest rates and different payment periods will affect a monthly payment, use a ________.
two-variable data table
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 Error Checking button displays as a ________.
yellow diamond
A defined name provides a logical reference to ________.
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
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
Cells that are referred to by a formula in another cell are called ________.
precedent cells
The Future value (Fv) at the end of the time period in an Excel function is usually ________ for loans.
zero
