Matching
Identify the letter of the choice that best matches the phrase or definition.
Premises:
The value that Excel will look for in the first column of the lookup table.
A requirement that needs to be met.
The range of cells for the lookup table.
A number that represents a calculation in the Subtotal function.
The range of data you create in either a vertical or horizontal format, which Excel will use to match against the criteria.
Responses:
Table_array
lookup table
function number
Lookup_value
condition
Correct Answer:
Premises:
Responses:
The value that Excel will look for in the first column of the lookup table.
A requirement that needs to be met.
The range of cells for the lookup table.
A number that represents a calculation in the Subtotal function.
The range of data you create in either a vertical or horizontal format, which Excel will use to match against the criteria.
Premises:
The value that Excel will look for in the first column of the lookup table.
A requirement that needs to be met.
The range of cells for the lookup table.
A number that represents a calculation in the Subtotal function.
The range of data you create in either a vertical or horizontal format, which Excel will use to match against the criteria.
Responses:
Related Questions
Q629: _ functions allow you to find data
Q631: You will use the _ function to
Q634: Use the _ function when the data
Q637: The _ function can be used to
Q639: Case EX 13-2 Gregory works for the
Q645: Explain why you might need to use
Q656: To use the HLOOKUP function, you will
Q657: The SUMIF function is another form of
Q658: The VLOOKUP function is found on the
Q660: The _ lets you control the calculation
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