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 Data Bars conditional formatting to the Duration column (range I6:I85). Mac users, on the Home tab, click Conditional Formatting, and under Solid Fill, click Blue Data Bar.1211Create a new conditional format that appliesRed fill andbold font to 12Created On: 09/19/20191Exp19_Excel_Ch04_Cap - Tech Support 1.6
Grader - InstructionsExcel 2019 ProjectStepInstructionsPoints Possibleincident (range A6:A85) that required 30or more days to resolve.12Change page breaks so page 2 begins with the Computer ID column (column E).213Set the print scale to 85%.414Add a 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: 09/19/20192Exp19_Excel_Ch04_Cap - Tech Support 1.6

  • Left Quote Icon

    Student Picture

  • Left Quote Icon

    Student Picture

  • Left Quote Icon

    Student Picture