The ________ function can be used to perform a multiconditional average of data.
A)AVERAGE
B)AVERAGEIF
C)AVERAGEIFS
D)MU

Name: The ________ function can be used to perform a multiconditional average of data. A)AVERAGE B)AVERAGEIF C)AVERAGEIFS D)MU
Brand: Quizplus
Rating: 4.9 (32 reviews)

Question

Quizplus · Accepted Answer

AVERAGEIFS is the best choice as it allows the user to perform a multiconditional average of data by specifying multiple criteria. AVERAGEIF only allows for one criterion to be specified. MU is not a valid function in Excel.

The ________ Function Can Be Used to Perform a Multiconditional