Question: Resize column A to a width of 4 . 0 0 . 6 . Format the data in row 4 as follows to show that

Resize column A to a width of 4.00.
6. Format the data in row 4 as follows to show that it contains column headings:
Change "Description" to use Service Description as the complete column heading.
30
b. Apply the Accent 6 cell style to the range B4:H4.
c. Use AutoFit to resize column D to its best fit.
7. Carla wants to include the actual dollar amount of the services performed in column E. Enter this information as follows: E
D5**J2 a. In cell E5, enter a formula without using a function that multiplies the actual hours (cell D5) by the billing rate (cell J2) 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 E6:E13 with the formula in cell E5 to include the charges for the other services.
c. Format the range E6:E13 using the Comma number format and no decimal places to match the formatting in column F.
8. Carla needs to show how much of the estimate remains after the services performed. Provide this information as follows:
a. In cell G5, enter a formula without using a function that subtracts the actual dollars billed (cell E5) from the estimated amount (cell F5) to determine the remaining amount of the estimate for general administrative services.
b. Use the Fill Handle to fill the range G6:G13 with the formula in cell G5 to include the remaining amount for the other services.
 Resize column A to a width of 4.00. 6. Format the

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!