Multiple Choice
MATCHING
Identify the letter of the choice that best matches the definition of the word or phrase.
-Allows you to retrieve data from multidimensional tables
A) vertical lookup table
B) horizontal lookup table
C) LOOKUP function
D) INDEX function
E) MATCH function
F) CHOOSE function
G) IFERROR
Correct Answer:

Verified
Correct Answer:
Verified
Q62: <img src="https://d2lvgg3v3hfg70.cloudfront.net/TB3934/.jpg" alt=" Violet is
Q63: With the INDEX function, if you are
Q64: The syntax of the HLOOKUP function is
Q65: The _ function returns the relative position
Q66: The ISBLANK function tests for a(n) _.<br>A)
Q68: When using an INDEX function, if you
Q69: MATCHING<br>Identify the letter of the choice that
Q70: In a(n) two-dimensional table, Excel can search
Q71: The IS function called ISLOGICAL is for
Q72: When solving a(n) _ formula, Excel looks