Question

We need to calculate AVERAGE of 4 cells B3,B4,B5,B6. Mark up correct formulas.

= SUM (B3:B6)/4
=(B3+B4+B5+B6)/4
=AVG(B3:B6)
=AVERAGE(B3,B9)
=AVERAGE(B3:B6)

Answer 1

To calculate the average of four cells B3, B4, B5, and B6, use the formula =AVERAGE(B3:B6).

Step-by-step explanation:

To calculate the average of four cells B3, B4, B5, and B6, you can use the formula =AVERAGE(B3:B6). This formula adds up the values in the specified range and divides by the number of cells in that range.