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?
- AVERAGE
- AVERAGEIF
- AVERAGEIFS
- 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])