7 Inserta newrow 15. In cell A15, type MarmotMountainPants . In cell B15, type 11200. In 4 cell C15, type 11695. In cell D15, type 12315. In cell E15, type 13275. Displaythe Name Managerandthenedit the Pant_Costnameto includerow 15. Selectthe Hat_Costsand edit the nameto Headwear_Costs. (Macusers click Define Nameandmadeeditsusingthe Define Namedialog box) 8 Click cell B19. On the Formulastab, in the FormulaAuditing group click Error Checking and 2 thenselectUpdateFormulato IncludeCells Usethe fill handleto copythe correctedformula from cell B19 acrossthroughcell E19. 9 On the QuarterlyApparelCostsworksheetin cell B25, inserta SUM function to sumthe 8 Coat_Costnamedrange usingthe namein the formula Createsimilar formulasin the range B26:B28, beingsureto usethe rangenamein eachformula In B29, calculatea total, and thenapplythe apply Currency andTotalcell style. Apply the Currency[0] style to cell B25 andapplythe Comma[0] style to the rangeB26:B28. Savetheworkbook 10 On the QuarterlyApparelCostsworksheetrecorda Macro usingthe name Report_Title and 4 the Shortcutkey CTRL+ o. (Macusers useOption+Command ]). Storethe Macroin the workbook andasthe Description type Reporheading . Click cell Al, type FrontRange ActionSports andthenpressCTRL+ENTER Mergeandcenterthe text acrossthe range Al:E1, andthenapply the Title cell style. In cell A2, type AppareCosts , andthenpress CTRL+ENTER MergeandCenterthe text acrossthe rangeA2:E2, andthenapplythe Heading1 cell style. Click cell A1, andthenstoprecordingthe macro Deletethe textin A1:A2, andthentestthe macro