Using the Sales Data worksheet, extract all of the foundation transactions in the first six months of 2005 for which Emilee or Jen was the salesperson and the average per-unit price was more than $3.20. Use advanced filtering and put the criteria range above the data on the worksheet (insert rows to do so). Use Quick Analysis to get the total dollars of sales and the count of transactions for the Sales Data worksheet. Trans Number Units Name 1 Betsy 2 Hallagan 3 Ashley 4 Hallagan 5 Zaret 6 Colleen 7 Cristina 8 Colleen 9 Ashley 10 Betsy 11 Ashley 12 Ashley 13 Emilee 14 Hallagan 15 Zaret 16 Emilee 17 Colleen 18 Jen 19 Jen 20 Zaret 21 Zaret 22 Betsy 23 Colleen 26 Emilee 27 Jen 28 Cristina 32 Cristina 33 Cici 34 Zaret 39 Cici 40 Hallagan 41 Emilee 42 Emilee Date Product 1.4.2004 lip gloss 10.3.2004 foundation 25.2.2005 lipstick 22.5.2006 lip gloss 17.6.2004 lip gloss 27.11.2005 eye liner 21.3.2004 eye liner 17.12.2006 lip gloss 5.7.2006 eye liner 7.8.2006 lip gloss 29.11.2004 mascara 18.11.2004 lip gloss 31.8.2005 lip gloss 1.1.2005 eye liner 20.9.2006 foundation 12.4.2004 mascara 30.4.2006 mascara 31.8.2005 lip gloss 27.10.2004 eye liner 27.11.2005 lip gloss 2.6.2006 mascara 24.9.2004 eyeliner 1.2.2006 mascara 6.12.2006 lip gloss 12.4.2004 lipstick 22.9.2005 foundation 28.3.2006 lip gloss 17.6.2004 mascara 9.9.2006 mascara 23.2.2006 foundation 24.6.2006 foundation 6.2.2004 eye liner 10.4.2005 mascara Dollars Location 45 $ 137,20 south 50 $ 152,01 midwest 9 $ 28,72 midwest 55 $ 167,08 west 43 $ 130,60 midwest 58 $ 175,99 midwest 8 $ 25,80 midwest 72 $ 217,84 midwest 75 $ 226,64 south 24 $ 73,50 east 43 $ 130,84 east 23 $ 71,03 west 49 $ 149,59 west 18 $ 56,47 south -8 $ (21,99) east 45 $ 137,39 east 66 $ 199,65 south 88 $ 265,19 midwest 78 $ 236,15 south 57 $ 173,12 midwest 12 $ 38,08 west 28 $ 86,51 midwest 25 $ 77,31 midwest 24 $ 74,62 west 38 $ 115,99 midwest 77 $ 233,05 midwest 53 $ 161,46 midwest 41 $ 125,27 west 19 $ 59,15 west -9 $ (24,63) west 38 $ 115,58 south 25 $ 76,56 south 19 $ 59,38 midwest