Add a formula in column P to calculate the yearly revenue. Provide an appropriate header and adjust the column width.

Create a validation rule, input message, and error alert for locations in the Revenue worksheet. The location must be $1,2,3,4,$ or $5.$

Filter the data to show only Location $1.$ Print page $1.$

Make the Revenue Subtotal worksheet active. Calculate subtotals for each month and calculate yearly revenue at each change in name. Adjust column widths where needed and then display the second outline level. Print page $1.$

Create a copy of the Revenue Subtotal worksheet and rename the copy PivotTable Data. On the PivotTable Data worksheet, remove the subtotaling. Create a PivotTable report on a new page to summarize the revenue received by each doctor $($Name$)$ for January, February, and March. Change the sheet name to Pivot Table.

Add a PivotChart below the PivotTable using a column style. Add an appropriate title to the PivotChart.

In Column E of the PivotTable worksheet, create an appropriate Sparkline. Show the high point.

Add a header to the worksheet; it should include your name at the left and the sheet name at the right.

Adjust the worksheet so that it prints on one page and print the worksheet.

Save EL$2-$U$1-$SA$2-$LabRevenue.xIsx