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

Google Sheets - Quiz(MCQ)

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

A)

AM

B)

AVERAGE

C)

AVERAGEIF

D)

AVERAGEIFS

Correct Answer : 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])

Recently Updated in Google Sheets Questions

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

A)

AVERAGEIFS

B)

AVERAGE

C)

AVERAGEIF

D)

None of the above

Correct Answer : 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, ...)

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

A)

AM

B)

AVERAGE

C)

AVERAGEIF

D)

AVERAGEIFS

Correct Answer : 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])

Which function is used to find the average (arithmetic mean)?

A)

AM

B)

AVERAGE

C)

AVERAGEIF

D)

AVERAGEIFS

Correct Answer : AVERAGE

Explanation : The AVERAGE() function is used to calculate the average (arithmetic mean).

Syntax :

=AVERAGE(value1, [value2, ...])

New Technologies MCQ's

Machine Learning

Artificial Intelligence

Ethical Hacking

Microsoft Azure

Cloud Computing

Quantum Computing

Neural Networks

Virtual Reality

Augmented Reality

Advertisement