Question

10 multiple choice 2 points which function would you use to check a condition and return one value if it is true and another if it is false? sum max average if

Explanation:

• The SUM function is used to add up a range of numbers.
• The MAX function returns the largest value in a set of values.
• The AVERAGE function calculates the arithmetic mean of a set of numbers.
• The IF function checks a condition. If the condition is TRUE, it returns one value; if the condition is FALSE, it returns another value.

Answer:

IF