ITE 140 Chapter 7 Multiple Question
________ cells contain formulas that refer to other cells. - CORRECT
ANSWER-Dependent
________ cells are referred to by a formula in another cell. - CORRECT
ANSWER-Precedent
________ functions search for a value in a defined range of cells located in another
part of the workbook to find a corresponding value. - CORRECT ANSWER-Lookup
________ is a method to find a specific value for a cell by adjusting the value of one
other cell. - CORRECT ANSWER-Goal Seek
________ is the process of examining a worksheet for errors in formulas. -
CORRECT ANSWER-Auditing
A(n) ________ 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. - CORRECT
ANSWER-green
A command that displays arrows to indicate what cells affect the value of the cell that
is selected is the ________ command. - CORRECT ANSWER-Trace Precedents
A data table is useful for all of the following except ________. - CORRECT
ANSWER-determining the Future value (Fv)
A defined name provides a logical reference to ________. - CORRECT
ANSWER-data
A range of cells that shows how changing certain values in your formula affects the
results of those formulas is a(n) ________. - CORRECT ANSWER-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 ________. - CORRECT
ANSWER-data validation
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 ________. - CORRECT ANSWER-defined
name
All of the following are methods to define a name for a cell or group of cells except
________. - CORRECT ANSWER-select the range, click in the Formula Bar, and
then type the name
________ cells contain formulas that refer to other cells. - CORRECT
ANSWER-Dependent
________ cells are referred to by a formula in another cell. - CORRECT
ANSWER-Precedent
________ functions search for a value in a defined range of cells located in another
part of the workbook to find a corresponding value. - CORRECT ANSWER-Lookup
________ is a method to find a specific value for a cell by adjusting the value of one
other cell. - CORRECT ANSWER-Goal Seek
________ is the process of examining a worksheet for errors in formulas. -
CORRECT ANSWER-Auditing
A(n) ________ 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. - CORRECT
ANSWER-green
A command that displays arrows to indicate what cells affect the value of the cell that
is selected is the ________ command. - CORRECT ANSWER-Trace Precedents
A data table is useful for all of the following except ________. - CORRECT
ANSWER-determining the Future value (Fv)
A defined name provides a logical reference to ________. - CORRECT
ANSWER-data
A range of cells that shows how changing certain values in your formula affects the
results of those formulas is a(n) ________. - CORRECT ANSWER-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 ________. - CORRECT
ANSWER-data validation
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 ________. - CORRECT ANSWER-defined
name
All of the following are methods to define a name for a cell or group of cells except
________. - CORRECT ANSWER-select the range, click in the Formula Bar, and
then type the name
