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
Q82: The RATE function returns the periodic rate
Q91: Match each of the following terms to
Q92: Match each of the following functions to
Q93: Match each of the following terms to
Q94: Match each of the following nested functions
Q95: Match each of the following terms with
Q96: Match each of the following functions to
Q97: Match each of the following terms to
Q99: Match the following functions with their categories
Q100: Match each of the following functions its
Unlock this Answer For Free Now!
View this answer and more for free by performing one of the following actions
Scan the QR code to install the App and get 2 free unlocks
Unlock quizzes for free by uploading documents