In column F, Liang wants to include the actual dollar amount of the work completed. Enter this information as follows:
a. In cell F5, enter a formula without using a function that multiplies the completed hours (cell E5) by the hourly rate (cell M2) to determine the dollar amount charged for blueprint drafting. Include an absolute reference to cell M2 in the formula.
b. Use the Fill Handle to fill the range F6:F14 with the formula in cell F5 to include the
charges for the other work.
c. Format the range F6:F14 using the Comma Style format and no decimal places to match the formatting in column G.
a. In cell F5, enter the formula: =$E5*$M$2
b. Select cell F5 and drag the fill handle down to fill the range F6:F14 with the formula.
c. Select the range F6:F14, right-click, and choose Format Cells. In the Format Cells dialog box, select the Number tab, choose "Comma Style" from the Category list, set the Decimal places to 0, and click OK. The range F6:F14 will now be formatted with the Comma Style and no decimal places.