Question

Cell A5 of Sheet 2 has a formula to calculate the average of cells B3 from Sheet 1. What will be the formula?

. =Average ($Sheet 1.B3: B6)
=Average (Sheet1.B3: B6)
=Average (B3:B6)​

Answer 1

Answer:

=Average ($Sheet 1.B3: B6)

Answer 2

Answer:

=Average(Sheets!B3:B6)

Explanation:

check question all choices are wrong

happy to help you

bye