When using an INDEX function, if you enter a row_num, column_num, or area_num outside of the range you referenced in the first argument, Excel displays ____.
A) an error message
B) the INDEX wizard
C) the next nearest column or row
D) none of the above
Correct Answer:
Verified
Q90: In an INDEX function, the argument _
Q91: The ISBLANK function tests for a(n) _.
A)
Q92: If you use an INDEX formula that
Q93: The syntax of the CHOOSE function is
Q94: When using the CHOOSE function, if the
Q96: The INDEX function allows you to specify
Q97: The CHOOSE function can return a value
Q98: The function named IFERROR combines aspects of
Q99: When using an INDEX function, you can
Q100: The INDEX function can solve for _.
A)
Unlock this Answer For Free Now!
View this answer and more for free by performing one of the following actions
Scan the QR code to install the App and get 2 free unlocks
Unlock quizzes for free by uploading documents