contestada

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

Respuesta :

MrRoyal

Answer:

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.

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

So, we have:

=AVERAGE(B7:B10)

Otras preguntas