Format the data in cell A$4$ as follows to display all of the text:

a$.$ Merge the cells in the range A$4$:A$13.$

b$.$ Rotate the text up in the merged cell so that the text reads from bottom to top.

c$.$ Middle$-$align and center the text.

d$.$ Remove the border from the merged cell.

e$.$ Resize column A to a width of $4\mathrm{.}00.$

Format the data in row $4$ as follows to show that it contains column headings:

a$.$ Change "Description" to use Service Description as the complete column

heading.

b$.$ Apply the Accent $6$ cell style to the range B$4$:H$4.$

c$.$ Use AutoFit to resize column $D$ to its best fit.

Carla wants to include the actual dollar amount of the services performed in column E$.$

Enter this information as follows:

a$.$ In cell E$5,$ enter a formula without using a function that multiplies the actual hours

$($cell D$5)$ by the billing rate $($cell J$2)$ to determine the actual dollar amount

charged for general administrative services. Include an absolute reference to cell

$J2$ in the formula.

b$.$ Use the Fill Handle to fill the range E$6$:E$13$ with the formula in cell E$5$ to include

the charges for the other services.

c$.$ Format the range E$6$:E$13$ using the Comma number format and no decimal places

to match the formatting in column $F.$

Carla needs to show how much of the estimate remains after the services performed.

Provide this information as follows:

a$.$ In cell G$5,$ enter a formula without using a function that subtracts the actual

dollars billed $($cell E$5)$ from the estimated amount $($cell F$5)$ to determine the

remaining amount of the estimate for general administrative services.

b$.$ Use the Fill Handle to fill the range G$6$:G$13$ with the formula in cell G$5$ to include

the remaining amount for the other services.

c$.$ Format the range G$6$:G$13$ using the Comma number format and no decimal places

to match the formatting in column $F.$