File Home Page AA == Inse General $ $ - % % calorie BIUD Font Wrap Text Merge & Center - Alignment D Conditional Format as Cell Formatting Table Styles 100 Paste Clipboard 9 A .09 Number Styles - CDEFG ALB EMPLOYEES Employee Pivot Table 7 9 5 Employe Name Department Gender Salary Bonus 6 1 Tammy Accounting F $40,000 $4,000 2 Adriane Purchasing F $52,000 $2,500 B 3 Logan Marketing M $80,000 $3,200 4 Star Payroll F $37,000 $1,000 10 5 Jeremy Accounting M $92,000 $4,400 11 6 Matthew Purchasing M $44,000 $1,000 12 7. Joshua Marketing M $75,000 $1,000 13 8 Emily Finance F $41,000 $1,000 14 9 Shannon Accounting F $68,000 $5,200 15 10 Cody Marketing M $30,000 $1,000 16 17 1) Create a pivot table showing salaries by gender. Save in Worksheet "Salaries by gender." 182) Create a pivot table showing total salaries by gender and department. "Save in Worksheet "Sal/Gender/Dept." 19 3) Create a pivot table showing employee name and bonus by gender for the Accounting departmennt. Save in Worksheet Acct Bonus." Data Intro to Pivot Tables Data Pivot Table Diagram Sheet1 EMPLOYEE MIKE'S MUSIC Lookup Tables V V(2)