which function returns the average of all the cells in a range that meet given criteria in MS Excel 2016 - IQ786

All-in-One Exam Prep Platform

which function returns the average of all the cells in a range that meet given criteria in MS Excel 2016

which function returns the average of all the cells in a range that meet given criteria in MS Excel 2016

AVERAGE

AVERAGEIF

AVERAGEALL

MEAN

Explanation

The AVERAGEIF function returns the average of cells in a range that meet the criteria you provide.

****

ND20-1-2023