[ad_1]
1Download and open the file named EXP19_Ch04_Cap_TechSupport.xlsx. Grader has automatically added your last name to the beginning of the filename.02Freeze Panes so the first row containing column headings (Row 5) on the SupportCalls worksheet will remain static when scrolling. Ensure that Rows 1-4 are visible.53Convert the data to a table, name the table SupportCalls, and apply the Gold, Table Style Medium 12.134Remove duplicate records.65Add a new column to the table named Duration.46Create a formula using unqualified structured references to calculate the days required to resolve the incident (Date Resolved – Date Created).87Add a total row to display the Average days required to resolve an issue.68Sort the table by Agent Name in alphabetical order, add a second level to sort by Description, and create a custom sort order as follows: Will not power on, Virus, Printing Issues, Software Update, Forgotten Password. Add a third level to sort by Duration smallest to largest.
[ad_2]
