Multiple Choice
When using the CHOOSE function, if the index_num argument is less than 1 or greater than the last value in the list, the function displays the error ____.
A) #VALUE!
B) #NAME
C) #REF
D) #ERROR
Correct Answer:
Verified
Correct Answer:
Verified
Related Questions
Q117: Identify the letter of the choice that
Q118: The syntax of the HLOOKUP function is
Q119: When you use the HLOOKUP function, you
Q120: When creating a vertical lookup table with
Q121: If you have a valid range that
Q123: If you use an INDEX formula that
Q124: Excel provides nine functions, called the _
Q125: In a LOOKUP function, the argument _
Q126: The _ function allows you to retrieve
Q127: A data list that categorizes values you