Freeze the panes so the first row containing column headings $($Row $6)$ and first two columns $($Columns A:B$)$ on the InsuranceClaims worksheet will remain static when scrolling. $6$

Convert the data to a table, name the table InsuranceClaims, and then apply the Light Green, Table Style Light $21.12$

Remove duplicate records. $5$

Add a new column to the table named Duration. $4$

Create a formula using unqualified structured references to calculate the days required to resolve the incident $($Date Resolved $$ Date Created$)$ and apply General Number Format. $14$

Add a total row to display the Average days required to complete a claim. $7$

Sort the table by insurance agent in alphabetic order, add a second level to sort by description, and then create a custom sort order as follows: Natural Disaster, Flood, Fire, Theft, Accident. Add a third level to sort by duration smallest to largest. $8$

Filter the table to only display closed claims as indicated in the status column. $8$

Use Quick Analysis to apply Blue Data Bars conditional formatting to the column that contains duration. $($On a Mac use Conditional Formatting.$)6$

Create a conditional format that applies Red fill and White Background $1$ font color to the incidents $($column B$)$ that required $30$ or more days to resolve. $12$

Select Landscape orientation and set the print scale to $70\%.6$

Change page breaks so each agent$$s information prints on its own page. $7$

Set row $6$ to repeat on each page that is printed. $5$

Save and close EXP$22\_$Excel$\_$CH$04\_$Cumulative$\_$Insurance.xlsx$.$ Exit Excel. Submit the file as directed. $0$