Home » MCQs » Google Sheets MCQs

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

22. Which function is used to find the average (arithmetic mean) of a range based on one or more true or false conditions?

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

Answer: C) AVERAGEIFS

Explanation:

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

Syntax:

=AVERAGEIFS(average_range, criteria_range1, criterion1, ...)