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