Matching
Associate the following functions with its corresponding purpose:
Premises:
INDEX
IF
OR
MATCH
RATE
Responses:
Returns the value of the intersection of a specified row and column
Decision structure
Returns true if any criteria are true
Returns the position of a particular value
Returns the interest rate of a loan or investment
Correct Answer:
Premises:
Responses:
INDEX
IF
OR
MATCH
RATE
Premises:
INDEX
IF
OR
MATCH
RATE
Responses:
Related Questions
Q8: In database functions, <>, >, =, <,
Q35: A MATCH function returns the value of
Q41: Which of these functions does not support
Q51: Which function calculates the total amount of
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
Q93: Match each of the following terms to