Enzo Diprima is the operations manager for the Forno Pizza franchise in Providence, Rhode Island. He is developing an Excel workbook to send to franchise owners and managers to help them with payroll, budget, and staff scheduling. He asks for your help in correcting errors and solving problems with the data.

Go to the Staff worksheet, which lists employees fora typical Forno Pizza franchise and includes a sample paystub. Enzo asks you to correct the errors in the worksheet, Use any error$-$checking method to determine the source of the #NAME? error in cell F$13,$ which should calculate the average daily wage. Correct the error by editing the formula in cell F$13.$

In cell F$22,$ use the Trace Dependents arrows to identify cells that depend on cell F$22.$ Edit the formula to correct the #NAME? error in cell F$22$ and its dependent cell.

Use the Trace Precedents arrows to find the source of the #DIV$/0!$ error in cell F$25.$ Correct the formula in cell F$25,$ which should divide the net pay $($cell F$23)$ by the number $\mathrm{.}1$ of hours worked $($cell F$18).$ Remove the trace arrows.

Enzo wants to make sure that the hourly wages entered in the range E$4$:E$11$ are between $$10$ and $$20$ per hour.

Set a data validation rule for the range $E4$:$E11$ that allows only decimal number values from $10$ to $20.$ Add an Input Message using Hourly Wage as the Input Message title and the following text as the Input message:

Enter a n$$mber from $10$ to $20.$

Add an Error Alert using the Stop style, Invalid Wage as the Error Alert title, and the following text as the Error message:

Confirm the hourly wage.

Circle the invalid data in the worksheet. Type $20$ as the hourly wage in the cell containing invalid data.

Go to the Budget worksheet, which contains a typical weekly budget for a Forno Pizza franchise. Enzo has already created a scenario named Promotions that calculates the weekly profit when the restaurant runs a promotion to increase business. He wants to create another scenario that compares the weekly profit if the franchise raises prices.