14. Create a one variable Data Table from what you just copied and pasted giving the total sales for each department, and the Largest Sale from each department. Start your Criteria range in cell A1. 15. On the Data table Sheet. Create a 2 variable data table starting in Cell A20 giving the Average Sales for each department by Gender. Start your Criteria Range in cell A15. 16. On the Employee Sales sheet, in Cell A52, create a formula to calculate the Average sales by Males. Use the criteria range in cells A47:A48. 17. On the Employee Sales sheet, in cell C52, create a formula to calculate the Total sales by Females. Use the criteria range in Cells C47:C48. B 0 D E 6 Employee # 7 03467 8 08467 Last Name First Name Gender Department Total Sales Head lookup Lorenz Alvaro M Brooks Arnold M 9 01340 Snyder Brett M 10 04070 Underwood David M 11 64483 Munsell Eddie M 12 25447 Hewitt Erica F 13 00654 Brolick Ernest M 14 00210 Radden Eugene M 15 03489 Headly Frank M 16 65780 Riley Hector M Small Appliances $ 6,377.46 Ron Baker Small Appliances $ 6,534.35 Ron Baker Small Appliances $ 11,447.40 Ron Baker Small Appliances $ 3,420.97 Ron Baker Small Appliances $ 6,330.19 Ron Baker Small Appliances $ 8,209.89 Ron Baker Large Appliances $ 20,107.54 Large Appliances $ 22,267.74 Large Appliances $ 21,300.33 David Burk Large Appliances $ 22,733.23 David Burk David Burk David Burk 17 34498 Norris Jack M Large Appliances $ 24,294.10 David Burk 18 09531 Dawson James M Large Appliances $ 24,281.34 David Burk 19 07864 Gossick Jeff M Large Appliances $ 24,502.07 David Burk 20 35448 Hancock Joann F Large Appliances $ 22,226.69 David Burk 21 02346 Foster Joe M Audio $ 1,748.53 Paul Keith 22 06548 Faux John. M Computers $ 2,296.79 Timothy Stephens 23 32489 Kunz Juan M Audio $ 1,423.42 Paul Keith 24 00987 Verley Judy F Audio $ 951.19 Paul Keith 25 66789 Lamore Kathi F Audio $ 26 25799 1,025.14 Paul Keith Porter Kim F Audio 27 00505 $ 1,239.27 Faust Paul Keith Linda F Audio 28 06542 $ 1,893.67 Louice Paul Keith Computers Employee Sales 9484 44 Department Head Timothy Stephens Sales 27 00505 Faust Linda F Audio $ 1,893.67 Paul Keith 28 06548 Burk Louise F Computers $ 9,484.44 Timothy Stephens 29 05487 Fox Lynn M Computers $ 30 00325 Mills Marco M Computers 31 32087 Salcito Maria F Computers 32 03587 Cook Melissa F Small Appliances 33 32486 Matthews Miguel M Computers 34 02347 Goldstein Mitch M Computers 35 06455 Gonzalez Patrick M Computers 36 63508 Scott Paul M Audio 37 87851 Edwards Richard M Electronics 38 06879 Eberly Roberta F Electronics 7,871.69 Timothy Stephens $ 12,354.00 Timothy Stephens $ 11,069.56 Timothy Stephens $ 8,131.56 Ron Baker $ 7,055.69 Timothy Stephens $ 1,916.41 Timothy Stephens $ 14,317.26 Timothy Stephens $ 1,921.24 Paul Keith $ 11,403.55 Stephanie Givens $ 8,041.70 Stephanie Givens 39 01279 Harris Ronald M Electronics $ 4,728.39 Stephanie Givens 40 45676 McMains Steven M Audio $ 1,662.00 Paul Keith 41 00657 Stanton Susan F Audio $ 1,748.86 Paul Keith 42 00104 Skelton Theresa F Small Appliances $ 6,136.23 Ron Baker 43 03483 Pruitt Vince M Electronics 9,510.22 Stephanie Givens. 44 03589 Owens Wayne 45 36445 Patel Tony M Electronics $ 3,172.59 Stephanie Givens M Electronics $ 46 9,498.65 Stephanie Givens 1 2 A B E 3 4 5 Small Appliances 6 Large Appliances 7 Audio 8 Computers 9 Electronics 10 11 12 13 14 15 16 17 18 19 20 21 22 22 22 C