Question

the contents in cells are A1 through A6 are 6,3,4,7,9 and 7. What function would return the answer 6?​

Answer 1

The formula =AVERAGE(A1:A6) would return the average of those numbers which is '6'.

Step-by-step explanation:

• The content in cells is A1 through A6 are 6,3,4,7,9 and 7.

As the average of 6,3,4,7,9 and 7 is 6.

If the range A1:A6 contains numbers, the formula =AVERAGE(A1:A6) would return the average of those numbers.

Therefore, the formula =AVERAGE(A1:A6) would return the average of those numbers which is '6'.