Solved

To Find and Retrieve Data from a Vertical Lookup Table

Question 34

Multiple Choice

To find and retrieve data from a vertical lookup table in the most efficient way, create a simple worksheet that contains related data, and organize this data in ____ to form the vertical lookup table.


A) columns
B) rows
C) either a or b
D) neither a nor b

Correct Answer:

verifed

Verified

Unlock this answer now
Get Access to more Verified Answers free of charge

Related Questions

Q29: The first row (key values) of the

Q30: <img src="https://d2lvgg3v3hfg70.cloudfront.net/TB3934/.jpg" alt=" Violet is

Q31: You can only use a LOOKUP function

Q32: The ISBLANK function checks whether a specified

Q33: <img src="https://d2lvgg3v3hfg70.cloudfront.net/TB3934/.jpg" alt=" Violet is

Q35: A vertical lookup table is a lookup

Q36: In an INDEX function, the argument _

Q37: When using the CHOOSE function, if the

Q38: The INDEX function allows you to retrieve

Q39: <img src="https://d2lvgg3v3hfg70.cloudfront.net/TB3934/.jpg" alt=" Violet is