$8$ Sort 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.

Mac users, to create the custom list, from the Excel menu, click Preferences. In the dialog box, click Custom Lists.

$9$ Filter the table to only display closed incidents as indicated in the status column.

$10$ Use Quick Analysis to apply the default Data Bars conditional formatting $($Solid Blue Fill$)$ to the Duration column $($range I$6$:I$85).$ Mac users, on the Home tab, click Conditional Formatting, point to Data Bars, and under Solid Fill, click Blue Data Bar.

$11$ Create a new conditional format that applies Red fill and bold font to incident $($range A$6$:A$85)$ that required $30$ or more days to resolve. Be sure to use relative cell references in the conditional format formula.

$12$ Change page breaks so page $2$ begins with the Computer ID column $($column E$).$