Matching
Match the following terms with the corresponding description.
Premises:
INDEX
Lookup_value
MATCH
VLOOKUP
HLOOKUP
Responses:
Looks for a value in the left most column of a table,and then returns a value in the same row from a column you specify
Returns a value or the reference to a value within a range based on X and Y coordinates
The value that you want to find in the array or list.
Returns the position of a value in a list
Looks for a value in the top row of a table or array of values and returns the value in the same column from a row you specify
Correct Answer:
Premises:
Responses:
INDEX
Lookup_value
MATCH
VLOOKUP
HLOOKUP
Premises:
INDEX
Lookup_value
MATCH
VLOOKUP
HLOOKUP
Responses:
Related Questions
Q74: In the FV function,the rate argument refers
Q75: Which function will return the intersection of
Q76: Which of the following functions returns a
Q77: What is the first argument of the
Q78: When using the MATCH function with an
Q80: The maximum number of IF statements in
Q81: If the criteria of an advanced filter
Q82: Which of the following functions should be
Q83: The database argument of any database function
Q84: A PMT of zero can be used