Match the following five terms to their meanings:
i.Lookup function
II.table array
III.VLOOKUP function
IV.HLOOKUP function
v.name
A) looks up values arranged in horizontal rows
B) looks up value in a defined range of cells located in another part of the workbook to find a corresponding value
C) word or string of characters that represents a cell,a range of cells,a formula,or a constant value
D) looks up values arranged in vertical columns
E) defined range in lookup formula
Correct Answer:
Verified
Q77: In a lookup formula,the defined range is
Q78: A _ list is a list of
Q79: The first step in using a lookup
Q80: Goal Seek is part of a suite
Q81: Cells containing formulas that refer to other
Q83: Match the following five terms to their
Q84: _ is the process of examining a
Q85: The _ command displays arrows that indicate
Q86: Equations that perform calculations on values in
Q87: _ are equations that perform calculations on
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