ROJECT STEPS

Titus Allison is a loan officer with First Mittagong Community Bank. Titus is adding formatting to the workbook he uses to track interest rates to increase its usability. Change the theme of the workbook to Office.

$2.$ Switch to the Mortgage worksheet, then format the headings. Merge and center the range A$1$:D$1.$ Apply the FM Heading cell style to the merged cell.

$3.$ Merge and center the range A$2$:D$2.$ Apply the FM Subheading cell style to the merged cell.

$4.$ Format the effective date information. For the range A$48$B$4,$ apply the Note cell style. For cell A$4,$ apply italic to the text and align right. For cell B$4,$ change the date format to day$-$month$-$year $($e$.$g$.,21-$Nov$-21).($Hint: For International users, use the U$.$S$.$ based format d$-$mmm$-$y$.)$

$5.$ Format the mortgage rate table. For the headings in A$6$:D$6,$ center and bold the text, then change the font color to Blue$-$Gray, Text $2(4$th column, $1$st row of the Theme Colors palette$).$ Merge and center the range A$7$:A$9.$

$6.$ Copy the formatting of the merged cell in the range A$7$:A$9,$ then paste the formatting in the range A$10$:A$18$ to create three more merged cells.

$7.$ In the range $B7$:$B18,$ apply the Percentage number format with two decimal places, then copy this format to the range D$7$:D$18.$

$8.$ In the range $C7$:$C18,$ apply the Number number format, then increase the decimals to show three decimal places.

$9.$ Change the background color of the range A$7$:D$9$ to Green, Accent $6,$ Lighter $80\%(10$th column, $2$nd row of the Theme Colors palette$).$

$10.$ Copy the formatting of the range A$7$:D$9,$ then paste the formatting in the range A$13$:D$15.$

$11.$ In the range A$6$:D$18,$ add a border around all cells using the All Borders option.