Home » MCQs » Google Sheets MCQs

Which function is used to find the average (arithmetic mean) of a range based on a true or false condition?

21. Which function is used to find the average (arithmetic mean) of a range based on a true or false condition?

1. AVERAGE
2. AVERAGEIF
3. AVERAGEIFS
4. AM

Answer: B) AVERAGEIF

Explanation:

The AVERAGEIF() function is used to calculate the average (arithmetic mean) of a range based on a true or false condition.

Syntax:

=AVERAGEIF(criteria_range, criterion, [average_range])