. On the Employee Data sheet, add conditional formatting to highlight the highest 5 salaries and the lowest 5 salaries. Show only the records and total number of medical staff in the ICU and Cardiology Departments who have worked here 10 years or more. Sort the list by Job Title in order of seniority (Registered Nurse, Physical Therapist, Surgical Tech and Paramedic) and then by Year Hired in ascending (smallest to largest) order. Review the results and summarize your findings on the Documentation sheet. How many employees were on the final list? Did any of the employees have the highest and lowest salaries? Do not delete any records or columns from the list as this is your original source data for all questions.

Hints: Your results should be displayed on the Employee Data sheet. Turn the data into a table. Set two Conditional Formatting using Top/Bottom Rules one for top 5 and another for bottom 5. Use sort and filters on the existing data. Use a total row to show the count of the records displayed that meet the criteria. Use custom sort for the Job Title.

LastName	FirstName	Department	Job Title	YearHired	Region	Salary	Participates in Retirement Plan
Mack	Kevin	ICU	Surgical Tech	2002	North	43,750	Yes
Johnson	Sue	Cardiology	Surgical Tech	2010	North	43,945	Yes
Lee	Kell	Cardiology	Surgical Tech	2009	West	45,250	Yes
Bordeau	Katherine	ICU	Surgical Tech	2010	South	46,561	Yes
Young	Jeff	ICU	Surgical Tech	2013	East	47,763	Yes
Ball	Susan	ICU	Registered Nurse	2010	East	54,229	No
Hill	Trevor	ICU	Registered Nurse	2004	North	56,840	No
Scheib	Earl	ICU	Registered Nurse	2010	West	61,639	Yes
Garabizien	Wendy	ICU	Registered Nurse	2002	North	62,750	No
Blackwell	Dean	Cardiology	Registered Nurse	2009	North	64,047	Yes
McKaye	Mary	ICU	Registered Nurse	2002	South	64,750	No
Neumann	Kenneth	Cardiology	Registered Nurse	2009	South	66,631	Yes
Palermo	Tom	ICU	Registered Nurse	2020	East	67,840	Yes
Rais	Mary	Cardiology	Registered Nurse	2001	West	69,750	Yes
Weeks	Jodie	Cardiology	Registered Nurse	2015	East	74,302	Yes
McKaye	Susan	ICU	Registered Nurse	2012	West	88,229	Yes
Jacobson	Andrew	ICU	Physical Therapist	2012	South	68,531	Yes
Gao	Xiaoming	ICU	Physical Therapist	2019	West	70,079	No
Jacobson	Carole	ICU	Physical Therapist	2010	South	70,531	Yes
Smith	William	ICU	Physical Therapist	2006	North	72,079	No
Nelsen	John	Cardiology	Physical Therapist	1985	West	79,589	Yes
Rothenberger	James	ICU	Physical Therapist	1998	South	86,031	Yes
Nelsen	Beth	Cardiology	Physical Therapist	1985	North	86,589	No
Chin	Ellen	Cardiology	Physical Therapist	2013	East	98,417	No
Smythe	Janice	ICU	Paramedic	2020	North	41,137	No
Comensoli	Bill	Cardiology	Paramedic	2017	North	43,875	Yes
Garafano	Karen	Cardiology	Paramedic	2021	East	47,250	Yes
Comensoli	Angela	Cardiology	Paramedic	2016	West	48,462	Yes
Mikkola	Claudia	Cardiology	Paramedic	2014	West	49,531	Yes
Halpern	Murray	Cardiology	Paramedic	2009	East	52,250	No
Lewis	Karl	ICU	Paramedic	2008	North	52,637	Yes
Fitzgerald	Edmond	ICU	Paramedic	2007	East	55,207	No