In Excel, which formula is used to calculate the average of a range of cells that meet specific criteria?

Microsoft Word (38) Microsoft Excel (22) Microsoft PowerPoint (23) Microsoft Access (5) HTML (61) Comptuer Hardware (37) Operating System (25) TSC (50) Software Engineering (4) Computer Network (11)

Microsoft Excel

In Excel, which formula is used to calculate the average of a range of cells that meet specific criteria?

AVERAGE()
SUM()
COUNT()
AVERAGEIF()

281

Answer : D) AVERAGEIF()

The AVERAGEIF() function in Excel is used to calculate the average of a range of cells that meet specific criteria based on a given condition.

Join Discussion

Comment *

Please Login to Post a Comment

Sign in with Google

RELATED MCQS

Which feature in Excel allows you to highlight cells based on specified criteria?

Which application software enables you to arrange data in rows and columns?

Which Excel function can be used to find the largest value in a specified range while ignoring any text values?

In Excel, which formula is used to calculate the average of a range of cells that meet specific criteria?

What is the purpose of the "Transpose" option in Excel?

Which Excel function is used to count the number of cells that meet multiple criteria?

Which Excel function is used to combine text from multiple cells into one cell?