BUSI 520 WEEK 7 QUIZ QUESTIONS AND ANSWERS
True or False: Ranges can be named in Excel to make it easier to reference the
worksheet when using formulas or functions. - Answers - True
Use _____ to check whether a specified reference or formula returns an empty cell.
A. ISBLANK
B. ISEMPTY
C. ISNONTEXT
D. None of the answers listed
E. ISNA - Answers - A
The function =HLOOKUP(F16,Discounts,2,TRUE) retrieves the value in _____.
A. column F of the worksheet
B. column 2 of the table array
C. row 16 of the worksheet
D. row 2 of the table_array
E. None of the answers listed. - Answers - D
True or False: The ISERR function refers to any error value (#N/A, #VALUE!, #REF!,
#DIV/0!, #NUM!, #NAME?, or #NULL!). - Answers - False
True or False: Values in a "closest match" vlookup table must be sorted in descending
order so that the VLOOKUP function can make accurate comparisons. - Answers -
False
True or False: In order to correctly use an "exact match" VLOOKUP function, the values
in the first column of the lookup table must be sorted in ascending order. - Answers -
False
A data list that categorizes values for retrieval is a(n) _____ table.
A. index
B. data
C. category
D. None of the answers listed.
E. lookup - Answers - E
The _____ argument of the VLOOKUP function is the type of lookup...the value should
be either TRUE or FALSE.
True or False: Ranges can be named in Excel to make it easier to reference the
worksheet when using formulas or functions. - Answers - True
Use _____ to check whether a specified reference or formula returns an empty cell.
A. ISBLANK
B. ISEMPTY
C. ISNONTEXT
D. None of the answers listed
E. ISNA - Answers - A
The function =HLOOKUP(F16,Discounts,2,TRUE) retrieves the value in _____.
A. column F of the worksheet
B. column 2 of the table array
C. row 16 of the worksheet
D. row 2 of the table_array
E. None of the answers listed. - Answers - D
True or False: The ISERR function refers to any error value (#N/A, #VALUE!, #REF!,
#DIV/0!, #NUM!, #NAME?, or #NULL!). - Answers - False
True or False: Values in a "closest match" vlookup table must be sorted in descending
order so that the VLOOKUP function can make accurate comparisons. - Answers -
False
True or False: In order to correctly use an "exact match" VLOOKUP function, the values
in the first column of the lookup table must be sorted in ascending order. - Answers -
False
A data list that categorizes values for retrieval is a(n) _____ table.
A. index
B. data
C. category
D. None of the answers listed.
E. lookup - Answers - E
The _____ argument of the VLOOKUP function is the type of lookup...the value should
be either TRUE or FALSE.
