7.7k views
1 vote
What is the correct formula to calculate an average between cells B3 and B6?

a) =AVERAGE(B3:B6)
b) =SUM(B3:B6)/4
c) =B3+B6/2
d) =AVERAGE(B3,B6)

User Mariuxi
by
8.1k points

1 Answer

6 votes

Final answer:

The correct formula to calculate an average between cells B3 and B6 is =AVERAGE(B3:B6).

Step-by-step explanation:

The correct formula to calculate an average between cells B3 and B6 is =AVERAGE(B3:B6).

This formula takes the average of all the values within the range of cells B3 to B6.

Using this formula, you will get the average value of the numbers in those cells.

User Lollo
by
9.0k points
Welcome to QAmmunity.org, where you can ask questions and receive answers from other members of our community.

9.4m questions

12.2m answers

Categories