need to solve this please and write all steps in answer with all detials please!!!!!

of companics in Niew Caste County. Delavare. You previoundy creatole sharts ta defait aucumar? data by service type, cusanmer, and dugb perea. You copied the ethatis as pictares to roplakx the actoal chants so changes you make to the dataset wilf not alder ifse charte. Thicn you sortes the formating to highalight transactions that took more than nine days tockise and thoplaced tara hars. for the arncant billesd to pive a quick stsenal for irancaction amoanty. Fen alty you fitrred a eopy of. Pivotchat to andhae apent perforemaince in fesolsing dicater tocevery muppoit calls a. Open co5r NCCTS and sime it as e05r I NCCTS Last First. b. Loe the range A 4:k39 on the March Howrsworksect and usetbe Phothtiart consmand in the c. Name the worksheet Disaster ftecovery Analysis. d. Plice the Call Type and Customer iD ficlds in Fonss. e. Place the Hours Lopfed. Days Open, and Amourat Balled Iichs ans Values f. Set the Hours Logged and Days Open fields to Sumasarine by Average. Apety Number format with 2 decimal places. g. Assign the rame Samamary Table to the Mivot Table. h. Apply Light Blac. Pivot Style Meditum 20 to the Privor Table. t. Insert in slicer based on Call Type. Pace the top-left cormer of the slicer in cell F3. Set an 3.5"height and 2.5 width for the sticer. Select the Desaster Reconery alice to filter the Piuot Table 1. Heposition the top-left corner of the PivotChart in cell A0. Ic. Change the chart type to Pie: I. Apply Style 3 chart style. m. Apply Accounting Number Fotmat to the Amount Rilied data. n. Diaglay the March Hours workshect and create GHTP P WODATA functions by completiag these stepse: - Cell K1: Display the average Disaster Reconcry huurs usinge the Avirrige of Hours Logged on row 4 in the Pivat Table. * Cell h2; Display the total Disaster Recovery armount billed using the Sum of Amount Buticd on row 4 in the Pivotiabie. o. Insert a footer with your name on mhe lef side, the shoet name in the center, and the file name code on the right side. P. Sive and close the workbook, Howed on your instructor's directions subunit e05rlNCCIS lastFirst. March Hours March Filtered Summary Statiscs: Summary Charts Ready Rx ccersbility invertigate