Matching
Match each of the following terms with its best conceptual description:
Premises:
AND
Nested Function
IF
NOT
OR
Responses:
At least one condition must be met for a true return
Tests conditions to process decisions
All conditions must be met for a true return
Use the results of one function as an argument in another
False = true
Correct Answer:
Premises:
Responses:
AND
Nested Function
IF
NOT
OR
Premises:
AND
Nested Function
IF
NOT
OR
Responses:
Related Questions
Q59: The _ function calculates the periodic interest
Q60: When using advanced filtering, leaving a cell
Q61: If you have 3 possible outcomes in
Q62: The _ function returns the position of
Q63: The _ function returns the difference between
Q65: The PPMT function calculates the monthly principal
Q66: _ can copy filtered information to a
Q67: An OR condition in an advanced filter
Q68: The _ function evaluates two or more
Q69: The formula = _ (10/15/2018,2)would return 12/15/2018.