$2$

$4$ points

Match the function to its purpose.

Test a cell to see if it meets one of multiple criteria and return a

unique value for each criteria.

Test a suite of conditions, and return one value all conditions are

met, and another value if one ore more conditions are not met.

Check to see if a statement is true, and return one value if it is and

another value if it not true.

Test a suite of conditions, and return one value if at least one

condition is true and another value if no conditions are true.