Question

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)

Answer 1

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.