$4.$ Go to the June Sales worksheet. Ladonna occasionally wants to focus on the billing data for the first full week of June. Set up a custom view by hiding rows $1250.$ Select cell G$1$ and then create a custom view using Week$1$ as the name. Display the June Sales worksheet using the custom view Weeks$1-4,$ which Ladonna already created, to redisplay all of the data.

$5.$ The June Sales worksheet has the same structure as the July Sales worksheet. Ladonna wants to apply the same formatting to both worksheets. Group the June Sales and July Sales worksheets. Fill the merged cell B$2$ with the Green, Accent $3$ fill color. Ungroup the worksheets.

$6.$ On the June Sales worksheet, freeze the rows so that rows $13$ always appear at the top of the worksheets when scrolling.

$7.$ For the June billings, Ladonna wants to display subtotals for each region. Sort the June Billings data in ascending order by Region. Add subtotals to the Billed column at each change in the Region. Use the Sum function and display the summary below the data.

$8.$ Ladonna wants to display the subtotals directly to the right of the subtotal heading. Hide column E$,$ which does not contain information Ladonna needs to display with the subtotals.