Question

Which function that gets the average of a range of cell?

Answer 1

Answer:

AVERAGEIF

Explanation:

•The Microsoft Excel AVERAGEIF function returns the average (arithmetic mean) of all numbers in a range of cells, based on a given criteria.

• The AVERAGEIF function is a built-in function in Excel that is categorized as a Statistical Function.

• It can be used as a worksheet function (WS) in Excel.

I hope it helps.

Thank you.

Answer 2

ANSWER:

=AVERAGE(B2:B11), this formula gives the output of the average of the numbers present the cell range B2:B11

EXPLANATION:

=AVERAGE()

This function returns the arithmetic mean of the arguments passed to it.

Consider, the range of cells B2:B11 contains numbers, then the formula =AVERAGE(B2:B11) gives the average of these numbers.

=AVERAGE(B2:B11), this formula gives the output of the average of the numbers present in the B column and starts from the cell B2 and ends at B11.

=AVERAGE(C3:J3), this formula give the output of the average of the numbers present in the 3rd row and starts from the cell C3 and ends at J3.

=AVERAGE(), this function returns the arithmetic mean of the arguments passed to it.

#SPJ2