Question

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).

Answer 1

Enter the following formula in B11

=AVERAGE(B7:B10)

Step-by-step 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.

• Start with =
• Type the name of the function: AVERAGE(
• Enter the cell range; B7:B10
• Close the bracket; )

So, we have:

=AVERAGE(B7:B10)