Match the following terms with their description:
i. VLOOKUP
II. HLOOKUP
III. Lookup table
IV. Lookup value
v. Column index number
A) Data is organized in rows
B) Column that contains the return values
C) Cell that contains the value to be looked up
D) Has the data used with HLOOKUP or VLOOKUP
E) Data is organized in columns
Correct Answer:
Verified
Q42: The TODAY()and NOW()functions are updated every time
Q43: The range that contains the lookup table
Q45: Using _ simplifies adding complex mathematical formulas
Q48: It is called a(n)_ function when a
Q61: The _ is the lowest value for
Q63: In a lookup table, the number of
Q81: Match the following terms with their description:
i.
Q82: Match the following terms with their description:
i.
Q87: If the annual interest rate is 12%
Q88: Match the example by replacing the ???
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