MATCHING
Identify the letter of the choice that best matches the definition of the word or phrase.
-A lookup table in which the data to be searched is organized in columns
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
Q118: A lookup table can have only one
Q119: Q120: In the VLOOKUP function, if a type Q121: The INDEX function argument _ refers to Q122: The _ function returns the relative position Q124: With _, you can specify your own Q125: The final argument of the VLOOKUP function Q126: You could write a formula using the Q127: If a product or company has more Q128: When using the MATCH function, the lookup_array
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