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)

a macro is a tool that allows you to automate tasks and add functionality to your forms, reports, and controls. for example, if you add a command button to a form, you associate the button's onclick event to a macro, and the macro contains the commands that you want the button to perform each time it is clicked.