Mitchell Dupree is an associate consultant at the Villanova Technology Group, a consulting firm that specializes in information technology. Mitchell uses an Excel workbook to track statistics on client billing and is formatting the workbook to make it easier to read and use.

Change the theme of the workbook to Office to use the standard theme for Villanova Techn$$logy$.$

Switch to the Billing Summary worksheet. Merge and center the range $A1$:$I1$ to begin formatting the contents as the worksheet title.

Apply the Title cell style to the range A$1$:I$1.$

Merge and center the range A$2$:I$2$ to clarify the range contains the worksheet subtitle.

Format the date information to separate it from the rest of the workbook. For the range A$3$:B$4,$ change the background color to Gold, Accent $4,$ Lighter $80\%(8$th column, $2$nd row in the Theme Colors palette$).$

Format the range $A3$:$B4$ as bold.

Format the range $B3$:$B4$ to use a date with a two$-$digit month, a two$-$digit day, and a two$-$digit year $($e$.$g$.,10/04/21).$

The range $B6$:$I11$ serves as a table showing billing details such as service and hours billed. Format the column headings in the range $B6$:$17$ as italic.

Center the contents of each cell in the range B$6$:I$11.$

For the range $B6$:$I6,$ change the background color to Gold, Accent $4,$ Lighter $60\%(8$th column, $3$rd row in the Theme Colors palette$).$

For the ranges $C7$:$E7$ and $G7$:$I7,$ change the background color to Gold, Accent $4,$ Lighter $40\%(8$th column, $4$th row in the Theme Colors palette$).$

Merge the range $B6$:$B7,$ and then middle align the contents of the merged cell.

$$