Matching
Associate the following functions with its corresponding purpose:
Premises:
OR
MATCH
INDEX
RATE
IF
Responses:
Returns the interest rate of a loan or investment
Returns true if any criteria are true
Decision structure
Returns the value of the intersection of a specified row and column
Returns the position of a particular value
Correct Answer:
Premises:
Responses:
OR
MATCH
INDEX
RATE
IF
Premises:
OR
MATCH
INDEX
RATE
IF
Responses:
Related Questions
Q76: IF you use the function, =MATCH(66, A1:A4,0),
Q77: Which function calculates a periodic rate for
Q78: The database argument of a database function
Q79: If your database field contains empty cells,
Q80: What is the match_type argument value for
Q82: What type of match would the following
Q83: Match each of the following terms to
Q84: The NPV function is used mostly to
Q85: This is a correct example of the
Q86: A loan amortization table is a schedule