excl

SecurelT, Inc., is a small computer security contractor that provides computer security analysis, design, and software implementation for commercial clients. Almost all of Securell's work requires access to classified material or confidential company documents. Consequently, all of the security personnel have clearances of either Secret or Top Secret. Some have even higher clearances for work that involves so-called black box security work. Although most of the personnel information for Securelt resides in database systems, a basic employee worksheet is maintained for quick calculations and ad hoc report generation. Because Securell is a small company, it can take advantage of Excel's excellent list management capabilities to satisfy many of its personnel information management needs. You have been provided with a sample worksheet, Employee_Data.xlsx, to assist Securell with producing several worksheet summaries. Here is what is needed: 1. One worksheet that is sorted by last name and hire date. 2. One worksheet that uses a custom sort by department in this order: Marketing, Human Resources, Management, and Engineering. 3. One worksheet that uses a filter to display only those employees in the Engineering department with a clearance of Top Secret (TS). 4. One worksheet that uses a custom filter to display only those employees born between 1960 and 1969 (inclusive) 5. One worksheet that totals the salaries by department and the grand total of all department salaries. This worksheet should be sorted by department name first. - D E 2 Last Name Department Title 3 Goldstein Engineering Engineer 4 Ballmer Engineering Engineer 5 Bednarczyk Engineering Engineer 6 Chang Engineering Engineer 7 Detweiler Engineering Engineer 8 Gates Engineering Engineer 9 Leonard Engineering Engineer 10 Manispour Engineering Manager 11 Mehta Engineering Engineer 12 Ortega-Molina Engineering Engineer 13 Rothrock Engineering Engineer 14 Stonesifer Engineering Engineer 15 Yamamoto Engineering Engineer 16 Zumkowski Engineering Staff 17 Kartashev Human Resources Staff 18 Rovik Human Resources Manager 19 Cushner Management Staff 20 English Management Manager 21 Grabowski Management Manager 22 Kurzweil Management Manager 23 Van Horn Management Manager 24 Andretti Marketing CSR 25 Flintsteel Marketing Staff 26 Grundies Marketing CSR 27 Lambros Marketing CSR 28 Pacioli Marketing Staff 29 Gomez Marketing CSR F Salary 51,000 42,900 56,700 46,540 56,700 66,300 59,800 54,500 65,000 46,000 53,300 64,300 49,600 33,000 38,000 43,000 32,000 62,040 75,700 63,000 66,500 42,500 34,500 38,900 41,000 42,300 43,500 G H J Hire Date Birth Date Gender Clearance 4/11/97 3/7/63 M TS 5/1/02 4/14/70 M N 5/14/99 5/27/70 M S 9/5/95 3/4/64 M TS 10/10/95 4/29/70 F S 1/28/97 4/10/74 M S 12/13/96 7/2/70 F TS 10/13/90 2/4/69 M S 10/1/95 2/12/65 F S 9/16/99 3/28/52 F S 2/8/94 3/21/70 M S 7/6/98 3/10/66 F S 11/16/95 1/24/63 F S 4/18/96 12/12/72 M TS 11/5/01 5/3/82 F N 12/1/01 1/26/55 M S 8/26/94 5/6/61 F TS 10/1/93 2/14/56 F TS 10/13/92 4/10/65 F 6/16/92 12/22/58 F S 12/18/92 2/3/58 M S 3/21/90 8/20/70 F N 3/21/90 8/22/58 F N 12/24/89 3/4/61 M 5/16/93 7/13/70 M N 8/26/95 5/6/50 M S 2/16/90 4/29/67 M N an