5 3 convert the data to a table name the table

This preview shows page 1 - 2 out of 2 pages.

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).107Add 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 levelto sort by Description, and create a custom sort order as follows: Won't power on, Virus, Printing Issues, Software Update, Forgotten Password. Add a third level to sort by Duration smallest to largest. (Mac users, to create the custom list, from the Excel menu, click Preferences. In the dialog box, click Custom Lists.)129Filter the table to only display closed incidents as indicated in the status column.1010Use Quick Analysis to apply the default Data Bars conditional formatting (Solid Blue Fill) to the Duration column (range I6:I85). Mac users, on the Home tab, click Conditional Formatting, point to Data Bars, and under Solid Fill, click Blue Data Bar.12Created On: 10/03/20191Exp19_Excel_Ch04_Cap - Tech Support 1.8
Grader - InstructionsExcel 2019 ProjectStepInstructionsPoints Possible11Create a new conditional format that appliesRed fill andbold font to incident (range A6:A85) that required 30or more days to resolve.1212Change page breaks so page 2 begins with the Computer ID column (column E).213Set the print scale to 85%.414Add a custom footer with your name on the left side, the sheet name code in the center, and the file name code on the right side.415Save and close the workbook. Submit the workbook as directed.0Total Points100Created On: 10/03/20192Exp19_Excel_Ch04_Cap - Tech Support 1.8

  • Left Quote Icon

    Student Picture

  • Left Quote Icon

    Student Picture

  • Left Quote Icon

    Student Picture