Solved

If You Use an INDEX Formula That Refers to Ranges

Question 80

Multiple Choice

If you use an INDEX formula that refers to ranges on separate worksheets, Excel displays the ____ error message.

A) #VALUE
B) #REF!
C) #ERROR
D) none of the above

Related Questions

Q75: The function named IFERROR combines aspects of

Q76: The INDEX function allows you to retrieve

Q77: With _, you can specify your own

Q78: In a LOOKUP function, the argument _

Q79: The _ function is designed to return

Q81: MATCHING<br>Identify the letter of the choice that

Q82: Headings at the top of each column

Q83: If a product or company has more

Q84: The INDEX function argument _ refers to

Q85: A function named IFWRONG can be used