Matching
Match each of the following terms to its best description:
Premises:
Column_num
Position
Array
Row_num
Lookup value
Responses:
Return of the Match function
The first argument in the match function,the value to be found
The range of values to be used in an index function's first argument
The second argument in the INDEX function
The last argument in the INDEX function
Correct Answer:
Premises:
Responses:
Column_num
Position
Array
Row_num
Lookup value
Premises:
Column_num
Position
Array
Row_num
Lookup value
Responses:
Related Questions
Q8: In database functions, <>, >, =, <,
Q10: Which function returns a value at the
Q35: A MATCH function returns the value of
Q41: Which of these functions does not support
Q56: A(n)_ is a group of two or
Q61: If you have 3 possible outcomes in
Q77: Which function calculates a periodic rate for
Q79: If your database field contains empty cells,
Q91: You need to know how many clients
Q92: Associate the following functions with its corresponding