Matching
Match the following functions with the corresponding description.
Premises:
AND
NOT
OR
INDEX
IF
Responses:
A function to test if no arguments are met
A function to test to see if multiple conditions are met
A function to test if at least one or more conditions are met
Returns a value or the reference to a value within a range based on X and Y coordinates
A function that tests if one argument is met
Correct Answer:
Premises:
Responses:
AND
NOT
OR
INDEX
IF
Premises:
AND
NOT
OR
INDEX
IF
Responses:
Related Questions
Q86: Which of the following logical functions will
Q87: Which of the following functions does not
Q87: The RATE function returns the periodic rate
Q88: When using Advanced Filtering empty cells in
Q89: Which of the following has the ability
Q91: The end_period argument should have the value
Q92: Which of the following database functions is
Q93: Match the following terms with the corresponding
Q94: The criteria range of a database function
Q95: Which function will return the total number