1)In the Filter Fun sheet:

a)Sort the data first by the Last Name field and then by the Hire Date field (both in ascending order).

b) Use the Filter feature to display only those Employees with more than 10 years of Service.

Add Job Life Pay Pay Annual Health Years of Emp ID Last Name Hire Date Birth Date Sex Location Status Ins Grade Type Salary Plan Service 2021-05-18 IN 15101 Smith 2011-08-28 1966-09-06 M Toronto FT Y 3 S $ 85,000 HMOF 10 W 15102 Overton 2007-05-24 1986-02-15 F Montreal FT N 2 S 40,000 HMOF 14 15103 Fetherston 2012-04-24 1968-09-24 M Calgary FT Y 2 S 37,244 HMOF 9 5 15104 Lebrun 2011-07-18 1959-08-09 F Toronto FT N 3 S 80,000 None 10 15105 Matthews 2012-08-21 1950-07-15 M Toronto FT Y 3 S $ 65,000 None 9 15106 Scott 2012-03-05 1958-05-02 M Calgary FT Y 3 S $ 125,000 PPOI 9 8 15107 Stolt 2010-03-01 1977-12-07 M Calgary FT N 3 S $ 95,000 HMOI 11 9 15108 Michell 2012-12-08 1961-12-04 M Toronto FT N 2 S $ 36,000 None 8 2 2 10 15109 Vankeuren 2008-08-11 1959-01-10 F Toronto PT 1 H $ 33,508 PPOF 13 11 15110 Mccorkle 2006-06-12 1942-01-30 F Vancouver FT N 1 H $ 21,840 None 15 12 15111 Nightingale 2009-05-04 1989-08-27 M Vancouver FT N 1 H $ 25,792 PPOF 12 13 15112 Croasdale 2012-12-18 1968-01-06 F Toronto FT N 1 H $ 32,011 PPOI 8 14 15113 Lampton 2008-05-04 1958-04-28 F Vancouver FT Y 1 H S 23,920 HMOF 13 15 15114 Palmer 2016-11-26 1971-10-04 F Toronto FT 1 H 32,011 None 4 16 2005-02-22 1960-01-04 F Vancouver FT 1 H $ 21,840 PPOI Activate Windows 15115 Martindale Y 16 Master List Filter Fun Smith Mitchell Overton Scott Walton Thompson Compensation + Go to settings to activate W