1. Starting in Cell N1, run an advanced data filter that will filter out the Employee # and Total Sales for the employees found in the Computer Department. Create your criteria Range starting in cell G

2. In cell F46, create a formula to calculate the Total Sales. (Hint: Sum)

3. In cell F47, create a formula to give the largest Sales Figure in the database. (Hint: Max)

Gender M First Name Alvaro Arnold Brett David Eddie Erica Ernest Eugene Frank Hector Jack James M Jeff A AL B 1 Employee Last Name 203467 Lorenz B 08467 Brooks 4 01340 Snyder 5 04070 Underwood 5 64483 Munsell 7 25447 Hewitt 3 00654 Brolick 00210 Radden 0 03489 Headly 1 65780 Riley 2 34498 Norris 3 09531 Dawson 407864 Gossick 5 35448 Hancock 6 02346 Foster 7 06548 Faux 8 32489 Kunz 9 00987 Verley O 66789 Lamore 1 25799 Porter -2 00505 Faust 3 06548 Burk 4 05487 Fox 5 00325 Mills 6 32087 Salcito 27 03587 Cook 8 32486 Matthews -9 02347 Goldstein O 06455 Gonzalez 1 63508 Scott -2 87851 Edwards Department Total Sales Small Applianc $ 6,377.46 Small Applianc $ 6,534.35 Small Applianc $ 11,447.40 Small Applianc $ 3,420.97 Small Applianc $ 6,330.19 Small Applianc $ 8,209.89 Large Applianc $ 20,107.54 Large Applianc $ 22.267.74 Large Applianc $ 21,300.33 Large Applianc $ 22,733.23 Large Applianc $ 24,294.10 Large Applianc $ 24,281.34 Large Applianc $ 24,502.07 Large Applianc $ 22,226.69 Audio $ 1,748.53 Computers $ 2,296.79 Audio 1,423.42 Audio 951.19 Audio 1,025.14 Audio 1,239.27 Audio 1,893.67 Computers $ 9,484.44 Computers $ 7,871.69 Computers $ 12,354.00 Computers 11,069.56 Small Applianc $ 8,131.56 Computers $ 7,055.69 Computers 1,916.41 Computers $ 14,317.26 Audio $ 1,921.24 Electronics 11,403.55 Joann Joe John Juan Judy Kathi Kim Linda Louise Lynn Marco Maria Melissa Miguel Mitch Patrick Paul Richard TITI TITTI 3 3 3 M