Stephanie would like to know the average number of regular hours worked by her employees. In cell B11, create a formula using the AVERAGE function to find the average number of regular hours her employees work in a week (B7:B10).

Enter the following formula in B11

=AVERAGE(B7:B10)

Explanation:

Given

Cells: B7 to B10

Required

Determine the average

Cells B7 to B10 is represented as: B7:B10

To calculate the average of these cells in Excel, follow the below steps.

So, we have:

=AVERAGE(B7:B10)

answer///quick access toolbar;