Shelly Cashman Excel $2019|$ Modules $1-3$: SAM Critical Thinking Capstone Project $1$c

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

cut Starting with the actual dollar amount for General administrative services, enter a formula without using a function that multiplies the actual hours by the billing rate to determine the actual dollar amount charged for general administrative services. Be sure that the formula always references the billing rate. Copy the formula down to fill the remaining amounts, and then match the number formats to the Estimated $ column.

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

Starting with General administrative services, enter a formula without using a function that subtracts the actual dollars billed from the estimated amount to determine the remaining amount of the estimate. Copy the formula down to fill the remaining amounts, and then match the number formats to the Estimated $ column.

$9.$ Carla also wants to show the remaining amount as a percentage of the actual amount. Starting with General administrative services, enter a formula without using a function that divides the remaining dollar amount by the estimated dollar amount. Copy the formula down to fill the remaining percentages. Copy the formula $($but not the formatting$)$ to the total row as well.