Create a Pivot table that tabulates the number of employees by department & gender. Name the worksheet for this "Employees by DeptGender". HINT: What data element do you need to COUNT in order to generate this pivot table? It would obviously have to be a data element whose value was different (unique, like a database table key) for every row in the table in order to insure an appropriate tabulation of employees by department). After you have created this pivot table, name the worksheet "Employees by DeptGender".

ID First Name Last Name Department Title 2956 Michael Goldstein Engineering Engineer 4123 Steve Ballmer Engineering Engineer 3117 Frederich Bednarczyk Engineering Engineer 2122 Yuan Chang Engineering Engineer 2451 Francine Detweiler Engineering Engineer 2896 Samuel Gates Engineering Engineer 2768 Phyllis Leonard Engineering Engineer 1119 Sharad Manispour Engineering Manager 2344 Nemesha Mehta Engineering Engineer 3210 Carmen Ortega-Molina Engineering Engineer 2002 Edgar Rothrock Engineering Engineer 3015 Patti Stonesifer Engineering Engineer 2678 Koshi Yamamoto Engineering Engineer 2733 John Zumkowski Engineering Staff 3314 Svetlana Kartashev Human Resources Staff 4006 Alice Rovik Human Resources Manager 2042 Hillary Cushner Management Staff 1851 Melinda English Management Manager 1355 Barbara Grabowski Management Manager 1173 Roberta Kurzweil Management Manager 1441 James Van Horn Management Manager 1042 Maria Andretti Marketing CSR 1032 Hillary Flintsteel Marketing Staff 1009 Kevin Grundies Marketing CSR 1614 Artie Lambros Marketing CSR 2105 Luca Pacioli Marketing Staff 1016 Oscar Gomez Marketing CSR 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 Hire Date Birth Date 4/11/97 3/7/63 5/1/02 4/14/70 5/14/99 5/27/70 9/5/95 3/4/64 10/10/95 4/29/70 1/28/97 4/10/74 12/13/96 7/2/70 10/13/90 2/4/69 10/1/95 2/12/65 9/16/99 3/28/52 2/8/94 3/21/70 7/6/98 3/10/66 11/16/95 1/24/63 4/18/96 12/12/72 11/5/01 5/3/82 12/1/01 1/26/55 8/26/94 5/6/61 10/1/93 2/14/56 10/13/92 4/10/65 6/16/92 12/22/58 12/18/92 2/3/58 3/21/90 8/20/70 3/21/90 8/22/58 12/24/89 3/4/61 5/16/93 7/13/70 8/26/95 5/6/50 2/16/90 4/29/67 Gender Clearance M TS M N M S M TS F S M S F TS M S F S F M S F S F M TS F N M S F TS F TS F S M S F N N M M N M M N