Liang needs to show how much of the estimate remains after the completed work. Provide this information as follows:
a. In cell H5, enter a formula without using a function that subtracts the completed amount billed (cell F5) from the estimated amount (cell GS) to determine the
remaining amount of the estimate for blueprint drafting.
b. Use the Fill Handle to fill the range H6:H14 with the formula in cell H5 to include the remaining amount for the other work.
C. Format the range H6:H14 using the Comma Style format and no decimal places to match the formatting in column G.
a. In cell H5, enter the formula without using a function:
=GS5-F5
b. Use the Fill Handle to fill the range H6:H14 with the formula in cell H5.
c. Format the range H6:H14 using the Comma Style format and no decimal places.