please tell me how to complete step 2 via excel
Exp19_Excel_Ch04_Cap_Tech_Support Project Description: You have been hired as a student assistant in the IT department of your University. As part of your responsibilities, you have been asked to enhance the Excel Workbook used to analyze the departments performance. The workbook contains records of all support issues resolved over the past year. You will convert the data to a table, format the table, sort and filter the table, insert calculations to evaluate key performance Indicators, and propare the worksheet for printing Steps to Perform: Points Possible Step Instructions 0 1 Download and open the file named EXP10 Ch04 Cap Tech Support.xlsx. Grader hos automatically added your last name to the beginning of the filename Freeze Panes so the first row containing column Headings (Row 5) on the SupredGalla worksheet will remain static when scrollina. Ensure that Rows 1.4 are visible 5 2 Ad hand Tabiatuta 13 HE JX Technical Support Calls B D E F G H Technical Support Calls 30 days Agent Name Cox Rousaux Rousaux Rousaux Vong Leggett Vong Rousaux Vong 2 3 Threshold 4 5 Incident Number 6 939-76160 7 712-90501 8 354-52747 9 354-52747 10 859-45748 11 610-12016 12 459-84377 13 218-35195 14 140-57449 15 399.98477 16 657-68422 17 840-29369 18 285-88931 19 254-39938 20 733-99609 21 207-19047 22 608-25364 23 967-11630 24 398-79106 25 619-44822 26 752-21845 27 131-31453 28 553-87138 Date created Last Name 1/1/21 Norris 1/1/21 Harvey 1/7/21 Neal 1/7/21 Neal 1/11/21 Lee 1/13/21 Glover 1/13/21 Barnett 1/13/21 Ross 1/14/21 Pearson 1/15/21 King 1/16/21 Washington 1/17/21 Hopkins 1/26/21 Bell 2/4/21 Stone 2/4/21 Alexander 2/4/21 Cook 2/7/21 Baldwin 2/9/21 Mendez 2/10/21 Hardy 2/10/21 Silva 2/11/21 Hanson 2/13/21 Medina 2/1621 Brown Vong Hays Leggett Hays Broadnax Vong Broadnax Leggett Vong Vong Cox Leggett Vong Hays Computer ID 3141 5995 9380 9380 5070 5891 1251 6735 6235 7426 6405 3708 1756 2971 9454 1850 4317 6724 4549 8950 7444 5469 7227 Description Forgotten Password Forgotten Password Software Update Software Update Virus Forgotten Password Printing Issues Virus will not power on Printing issues Software Update Software Update Printing issues will not power on Virus Virus Software Update Forgotten Password Printing issues Software Update Virus Printing Issues Status Open Open Hold Hold Closed Hold Hold Closed Hold Closed Closed Open Hold Closed Open Closed Open Hold Closed Closed Open Closed Date Resolved 2/6/21 1/19/21 1/24/21 1/24/21 1/18/21 1/18/21 2/6/21 1/27/21 2/2/21 1/26/21 2/9/21 2/13/21 2/25/21 2/20/21 2/17/21 2/12/21 3/6/21 2/28/21 2/23/21 2/12/21 2/27/21 2/18/21
