In cell F13 of the Schedule worksheet, enter a formula that will calculate the total number of employees scheduled to work Sunday for all schedules A-G. Begin by multiplying the number of employees for schedule A, in cell D5, by the value representing whether or not employees are working that day in cell F5. Be sure to make the reference to cell D5 an absolute cell reference so that, when finished, the formula can be copied across the row. So far the result of the formula is 0 because schedule A has people scheduled off on Sunday. Next, add to the product, the number of employees scheduled to work Sunday for schedule B. Continue with the formula by adding a similar calculation for schedules C-G, making an absolute cell reference for each cell in column D.

In cell F13 of the Schedule worksheet, you would enter the following formula:

=(D5F5)+(D6F6)+(D7F7)+(D8F8)+(D9F9)+(D10F10)+(D11F11)+(D12F12)

Here's the step-by-step breakdown:

1. Start by multiplying the number of employees for schedule A, in cell D5, by the value representing whether or not employees are working that day in cell F5. This is done by typing "(D5*F5)".

2. Make the reference to cell D5 an absolute cell reference by adding a dollar sign before the column letter and row number, like this: "($D$5F5)". However, since the question asks for the formula to be copied across the row, we only need to lock the column reference, so it should be "(D$5F5)".

3. Next, add to the product, the number of employees scheduled to work Sunday for schedule B. This is done by typing "+(D6*F6)".

4. Continue with the formula by adding a similar calculation for schedules C-G. This is done by typing "+(D7F7)+(D8F8)+(D9F9)+(D10F10)+(D11F11)+(D12F12)".

5. Make an absolute cell reference for each cell in column D by adding a dollar sign before the column letter, like this: "(D$5*F5)+(D$6F6)+(D$7*F7)+(D$8F8)+(D$9*F9)+(D$10F10)+(D$11*F11)+(D$12F12)".

6. Press Enter to complete the formula. The cell F13 will now show the total number of employees scheduled to work Sunday for all schedules A-G.