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. C D E G 5 6 Employee Last Name First Name Gender Department 7 03467 Lorenz Alvaro M Small Appliances 808467 Brooks Arnold M Small Appliances Total Sales $6,377.46 $6,534.35 Ron Baker Head lookup Ron Baker Ron Baker Ron Baker OK Sales OK Sales Head Nested IF Sales lookup Sales Nested OK Sales OK Sales 901340 Snyder Brett M Small Appliances $ 11,447.40 Ron Baker Ron Baker Above Average Sales Above Average Sales 10 04070 Underwood David M 11 64483 Munsell Eddie M Small Appliances $3,420.97 Ron Baker Small Appliances $ 6,330.19 Ron Baker OK Sales OK Sales Ron Baker Ron Baker OK Sales OK Sales 12 25447 Hewitt Erica F Small Appliances $ 8,209.89 Ron Baker Ron Baker Average Sales Average Sales 13 00654 Brolick Ernest M Large Appliances $ 20,107.54 David Burk David Burk Excellent Sales Excellent Sales 14 00210 Radden Eugene M 15 03489 Headly Frank M Large Appliances $22,267.74 David Burk Large Appliances $ 21,300.33 David Burk Excellent Sales Excellent Sales David Burk David Burk Excellent Sales Excellent Sales 16 65780 Riley Hector M Large Appliances $ 22,733.23 David Burk David Burk Excellent Sales Excellent Sales 17 14498 Norris Jack M Large Appliances $ 24,294.10 David Burk David Burk Excellent Sales Excellent Sales 18 09531 Dawson James M Large Appliances $ 24,281.34 David Burk David Burk Excellent Sales Excellent Sales 19 07864 Gossick Jeff M Large Appliances $ 24,502.07 David Burk David Burk Excellent Sales Excellent Sales 20 35448 Hancock Joanni F Large Appliances $22,226.69 David Burk David Burk Excellent Sales Excellent Sales 21 02346 Foster Joe M Audio 5 1,748.53 Paul Keith Paul Keith Low Sales Low Sales 22 06548) Faux John M Computers $ 2,296.79 Timothy Stephens 23 32485 Timothy Stephens Low Sales Low Sales Kune Juan M Audio 24 00967 Verley Judy F Audio $ $ 1,423.42 Paul Keith 951.19 Paul Keith Paul Keith Low Sales Low Sales Paul Keth Low Sales Low Sales 25 66789 Lamore Kathi F Audio $ 1,025.14 Paul Keith Paul Keith Low Sales 20 25799 Low Sales Porter Om F Audio $ 1,239.27 Paul Keth Paul Keith 27 00505 Faust Low Sales Linda Low Sales " Audio $ 1,893.67 Paul Keith 28 0654 Paul Keth Burk Louise F Computers 29 05487 Fox Ayrin M Computers 30 00325 Mills Marco M Computers 31 32087 Maria Computers 32 03587 Cook Melissa ' Small Appliances 33 17456 Matthews Miguel M 34 02347 Goldstein Mitch M Computers Computers > Employee Sales Department Head Sales Low Sales Average Sales Average Sales 5 9.484.44 Timothy Stephens Timothy Stephens Average Sales $ 7,871.69 Timothy Stephens Timothy Stephens Average Sales $ 12,354.00 Timothy Stephens Timothy Stephens Above Average Sales Above Average Sales $ 11,069.56 Timothy Stephens Timothy Stephens Above Average Sales Above Average Sales 5 813156 Ron Baker Ron Baker $ 7,055.69 Timothy Stephens Timothy Stephens Average Sales Average Sales 1916.41 Timothy Stephens Timothy Stechens Low Sales Data Table Low Sales Average Sales Average Sales Low Sales G H Average Sales Average Sales Low Sales Average Sales $ 7,871.69 Timothy Stephens Timothy Stephens Average Sales $ 12,354.00 Timothy Stephens Timothy Stephens Above Average Sales Above Average Sales Computers $ 11,069.56 Timothy Stephens Timothy Stephens Above Average Sales Above Average Sales Average Sales Small Appliances S 8,131.56 Ron Baker Ron Baker $ 7,055.69 Timothy Stephens Timothy Stephens Average Sales $ 1,916.41 Timothy Stephens Timothy Stephens Low Sales 5 14,317.26 Timothy Stephens Timothy Stephens Above Average Sales Above Average Sales 5 1,921 24 Paul Keth Paul Keith $ 11,403.55 Stephanie Givens Stephanie Givens $ 8,041,70 Stephanie Givens Stephanie Givens $ 4,728.39 Stephanie Givens Stephanie Givens Low Sales Above Average Sales Average Sales Low Sales Above Average Sales Average Sales OK Sales OK Sales Low Sales Low Sales Low Sales OK Sales $ 1,662.00 Paul Keth 5 1,74886 Paul Keith Small Appliances 5 6,136.23 Ron Baker Paul Keith Paul Keith Ron Baker $ 9,510.22 Stephanie Givens Stephanie Givens Average Sales $ 3.172.59 Stephanie Givens Stephanie Givens OK Sales 59,498.65 Stephanie Owens Stephanie Givens Average Sales $9.350 10511 Low Sales OK Sales Average Sales OK Sales Average Sales C D 29 05487 Fox Lynn M Computers 30 00325 Mills Marco M Computers 31 32087 Salcito Maria F 32 03587 Cook Melissa F 33 32486 Matthews Miguel M Computers 34 02347 Goldstein Mitch M Computers 35 06455 Gonzales Patrick M Computers 36 63508 Scott Paul M Audio 38 37 87851 06879 39 01279 Edwards Richard M Eberly Roberta F Electronics Electronics Harris Ronald M Electronics 40 45676 McMains Steven M Audio 41 00657 Stanton Susan F Audio 42 00104 Skelton Theresa 43 03483 Prutt Vince 44 03589 Owen Wame 45 36445 Patel Tony 523 M Electronics Electronics M Electronics 40 47 Gender 48 M Gender F 49 50 51 Mae Sa 52 53 54 Female Sales