BUSI 520 CHAPTER 5 QUESTIONS AND ANSWERS
Ranges can be named in Excel to make it easier to reference the worksheet when using
formulas or functions. - Answers - True
A LOOKUP function is used to retrieve a value from _____. - Answers - a column or row
The ISERROR function refers to any error value except #N/A. - Answers - False
The function =HLOOKUP(F16,Discounts,2,TRUE) retrieves the value in _____. -
Answers - row 2 of the table_array
When using a VLOOKUP function, the first column of the lookup table that contains the
data you are comparing to your "lookup_value" is/are called the _____. - Answers - key
data
Use the _____ function to retrieve a value from a table based on the row and column
numbers specified. - Answers - The INDEX function returns the value of an element in a
table or an array selected by the row and column number indexes. (The LOOKUP
function returns a value either from a one-row or one-column range.)
The number of the column containing the data you want to retrieve for the VLOOKUP
function is the _____. - Answers - col_index_num
When using VLOOKUP or HLOOKUP to look up a number that can fall within a range of
values, you should be using an "Exact Match" lookup. - Answers - False
Use _____ to check whether a specified reference or formula returns an empty cell. -
Answers - ISBLANK
The lookup_value argument in a VLOOKUP or HLOOKUP function is often a number,
text, a logical value, or a cell reference...but the lookup_value argument can also be a
formula. - Answers - True
The ISERR function refers to any error value (#N/A, #VALUE!, #REF!, #DIV/0!, #NUM!,
#NAME?, or #NULL!). - Answers - False
When entered in a worksheet named Forecast, the formula =Costs!B5*C5 multiples the
value in cell B5 of the "Costs" worksheet by the value in cell C5 of the "Costs"
worksheet. - Answers - False
The _____ argument of the VLOOKUP function is the type of lookup...the value should
be either TRUE or FALSE. - Answers - range_lookup
Ranges can be named in Excel to make it easier to reference the worksheet when using
formulas or functions. - Answers - True
A LOOKUP function is used to retrieve a value from _____. - Answers - a column or row
The ISERROR function refers to any error value except #N/A. - Answers - False
The function =HLOOKUP(F16,Discounts,2,TRUE) retrieves the value in _____. -
Answers - row 2 of the table_array
When using a VLOOKUP function, the first column of the lookup table that contains the
data you are comparing to your "lookup_value" is/are called the _____. - Answers - key
data
Use the _____ function to retrieve a value from a table based on the row and column
numbers specified. - Answers - The INDEX function returns the value of an element in a
table or an array selected by the row and column number indexes. (The LOOKUP
function returns a value either from a one-row or one-column range.)
The number of the column containing the data you want to retrieve for the VLOOKUP
function is the _____. - Answers - col_index_num
When using VLOOKUP or HLOOKUP to look up a number that can fall within a range of
values, you should be using an "Exact Match" lookup. - Answers - False
Use _____ to check whether a specified reference or formula returns an empty cell. -
Answers - ISBLANK
The lookup_value argument in a VLOOKUP or HLOOKUP function is often a number,
text, a logical value, or a cell reference...but the lookup_value argument can also be a
formula. - Answers - True
The ISERR function refers to any error value (#N/A, #VALUE!, #REF!, #DIV/0!, #NUM!,
#NAME?, or #NULL!). - Answers - False
When entered in a worksheet named Forecast, the formula =Costs!B5*C5 multiples the
value in cell B5 of the "Costs" worksheet by the value in cell C5 of the "Costs"
worksheet. - Answers - False
The _____ argument of the VLOOKUP function is the type of lookup...the value should
be either TRUE or FALSE. - Answers - range_lookup
