Which Excel function is used to find the average of a range of numbers while excluding zeros?

a) AVERAGEIF

b) AVERAGEA

c) AVERAGEIFS

d) AVERAGENONZERO

Show Answer

b) AVERAGEA

The AVERAGEA function in Excel calculates the average of a range of numbers, including zeros. If you want to find the average of a range of numbers while excluding zeros, you would typically use a combination of functions like AVERAGEIF or AVERAGEIFS to set a condition for excluding the zeros.