Use the file named Makeup2007.xlsx for questions 10–16.

Create a table that, when you enter a year in your worksheet, contains sales of each product by person during that year.

Transcribed Image Text:

G H 4 Trans Number Name 456789 10 11 12 13 14 15 16 17 18 19 222 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 Date J Product 4/1/2004 lip gloss 3/10/2004 foundatior 2/25/2005 lipstick 5/22/2006 lip gloss 6/17/2004 lip gloss 11/27/2005 eye liner 3/21/2004 eye liner 12/17/2006 lip gloss 7/5/2006 eye liner 8/7/2006 lip gloss 11/29/2004 mascara 11/18/2004 lip gloss 8/31/2005 lip gloss 1/1/2005 eye liner 9/20/2006 foundatior 4/12/2004 mascara 4/30/2006 mascara 8/31/2005 lip gloss K Units L Dollars 45 $137.20 50 $ 152.01 9 $ 28.72 55 $167.08 43 $ 130.60 58 $ 175.99 8 $ 25.80 72 $ 217.84 75 $ 226.64 24 $ 73.50 43 $ 130.84 23 $ 71.03 49 $ 149.59 18 $ 56.47 -8 $ (21.99) 45 $ 137.39 66 $199.65 88 $ 265.19