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

Question

Quizplus · Accepted Answer

The CHOOSE function in Excel displays the #VALUE! error when the index_num argument is less than 1 or greater than the number of values in the list, indicating an issue with the value used in the function.

When Using the CHOOSE Function, If the Index_num Argument Is