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
Q39: Case EX 13-1 Kim is a photographer.
Q57: To count the number of cells without
Q114: To use the HLOOKUP function, you will
Q216: The function number 5 calculates SUM.
Q234: You use the HLOOKUP function when the
Q426: _ functions allow you to find data
Q671: Using the COUNT function lets you count
Q750: After you name a range, Excel remembers
Q777: To count cells with text, you use
Q802: You can count numerical data in a