Excel Chapter 2
Text wrap - CORRECT ANSWER-The ________ format shows text on multiple lines
within a cell.
series - CORRECT ANSWER-A ________ is a group of numbers, text, dates, or
time periods that come in succession.
AutoFit - CORRECT ANSWER-The Excel feature used to automatically adjust
column width to the longest column entry is ________.
the column is too narrow to display the entire value - CORRECT ANSWER-The
displayed value of a cell is replaced with a series of # symbols when ________
green triangle - CORRECT ANSWER-Which symbol is the error indicator that
appears in a cell having a formula that has broken a rule?
Quick Analysis button - CORRECT ANSWER-When a section of a worksheet
displaying numeric values is selected, the ________ appears; this is used to apply
conditional formatting or to insert a chart or table based on the selected content.
range finder - CORRECT ANSWER-The ________ outlines all the cells referenced
in a formula.
absolute cell reference - CORRECT ANSWER-A cell that remains the same when it
is copied or filled to other cells is a(n) ________.
error value - CORRECT ANSWER-A message that appears in a cell when a formula
cannot perform the specified calculations is a(n) ________.
format - CORRECT ANSWER-The number of decimals places and the appearance
commas, dollar signs, or other symbols are features of number ________.
AVERAGE - CORRECT ANSWER-The ________ function is a statistical function
that adds a group of values and then divides the result by the number of values in
the group.
argument - CORRECT ANSWER-In a function, the range in parentheses is the
________.
double-click on the name of the function in the list - CORRECT ANSWER-When the
Function AutoComplete list is used to enter the MAX function into an active cell,
________.
Text wrap - CORRECT ANSWER-The ________ format shows text on multiple lines
within a cell.
series - CORRECT ANSWER-A ________ is a group of numbers, text, dates, or
time periods that come in succession.
AutoFit - CORRECT ANSWER-The Excel feature used to automatically adjust
column width to the longest column entry is ________.
the column is too narrow to display the entire value - CORRECT ANSWER-The
displayed value of a cell is replaced with a series of # symbols when ________
green triangle - CORRECT ANSWER-Which symbol is the error indicator that
appears in a cell having a formula that has broken a rule?
Quick Analysis button - CORRECT ANSWER-When a section of a worksheet
displaying numeric values is selected, the ________ appears; this is used to apply
conditional formatting or to insert a chart or table based on the selected content.
range finder - CORRECT ANSWER-The ________ outlines all the cells referenced
in a formula.
absolute cell reference - CORRECT ANSWER-A cell that remains the same when it
is copied or filled to other cells is a(n) ________.
error value - CORRECT ANSWER-A message that appears in a cell when a formula
cannot perform the specified calculations is a(n) ________.
format - CORRECT ANSWER-The number of decimals places and the appearance
commas, dollar signs, or other symbols are features of number ________.
AVERAGE - CORRECT ANSWER-The ________ function is a statistical function
that adds a group of values and then divides the result by the number of values in
the group.
argument - CORRECT ANSWER-In a function, the range in parentheses is the
________.
double-click on the name of the function in the list - CORRECT ANSWER-When the
Function AutoComplete list is used to enter the MAX function into an active cell,
________.
