Use the data in columns H-L, and complete the table below: 1) Determine the total number...

 

Transcribed Image Text:

Use the data in columns H-L, and complete the table below: 1) Determine the total number of units and dollar volume sold for each product. (2.5 Points) 2) Determine the total revenue earned before December 10, 2015. (2.5 Points) 3) How many units were sold by people other than Richard? (2.5 Points) 4) How many units of makeup were sold between January 15, 2015, and February 15, 2017? (2.5 Points) DO NOT HARDCODE THE VALUES IN THE FORMULAS - USE CELL REFERENCE 10 Points Total Problem 1 Product lip gloss foundation lipstick eye liner mascara Problems 2 through 4 Revenue before 12/10/2015 Units not sold by Richard Units sold between 1/15/2015 and 2/15/2017 Including the amounts on those dates Units Do not modify Yellow Highlighted Area Dollar Volume $ 82,982.72 55,648 55648 0 0 0 0 0 0 0 0 0 Trans Number Name 1 Abbey 2 Danielle 3 Barbara 4 Danielle 5 Richard 6 Collette 7 Cristina 8 Collette 9 Barbara 10 Abbey 11 Barbara 12 Barbara 13 Emilee 14 Danielle 15 Richard 16 Emilee Product 3/15/2015 lip gloss 2/21/2015 foundation 2/8/2016 lipstick 5/4/2017 lip gloss 5/31/2015 lip gloss 11/9/2016 eye liner 3/4/2015 eye liner 11/29/2017 lip gloss 6/17/2017 eye liner 7/20/2017 lip gloss 11/12/2015 mascara 11/1/2015 lip gloss 8/13/2016 lip gloss 12/15/2015 eye liner 9/2/2017 foundation 3/26/2015 mascara Date Dollars $137.20 $ 152.01 $ 28.72 $167.08 $ 130.60 $ 175.99 $ 25.80 $ 217.84 $ 226.64 $ 73.50 $ 130.84 $ 71.03 $ 149.59 $ 56.47 $ (21.99) $137.39 Units 45 50 9 55 43 58 8 72 75 24 43 23 49 18 -8 45 Use the data in columns H-L, and complete the table below: 1) Determine the total number of units and dollar volume sold for each product. (2.5 Points) 2) Determine the total revenue earned before December 10, 2015. (2.5 Points) 3) How many units were sold by people other than Richard? (2.5 Points) 4) How many units of makeup were sold between January 15, 2015, and February 15, 2017? (2.5 Points) DO NOT HARDCODE THE VALUES IN THE FORMULAS - USE CELL REFERENCE 10 Points Total Problem 1 Product lip gloss foundation lipstick eye liner mascara Problems 2 through 4 Revenue before 12/10/2015 Units not sold by Richard Units sold between 1/15/2015 and 2/15/2017 Including the amounts on those dates Units Do not modify Yellow Highlighted Area Dollar Volume $ 82,982.72 55,648 55648 0 0 0 0 0 0 0 0 0 Trans Number Name 1 Abbey 2 Danielle 3 Barbara 4 Danielle 5 Richard 6 Collette 7 Cristina 8 Collette 9 Barbara 10 Abbey 11 Barbara 12 Barbara 13 Emilee 14 Danielle 15 Richard 16 Emilee Product 3/15/2015 lip gloss 2/21/2015 foundation 2/8/2016 lipstick 5/4/2017 lip gloss 5/31/2015 lip gloss 11/9/2016 eye liner 3/4/2015 eye liner 11/29/2017 lip gloss 6/17/2017 eye liner 7/20/2017 lip gloss 11/12/2015 mascara 11/1/2015 lip gloss 8/13/2016 lip gloss 12/15/2015 eye liner 9/2/2017 foundation 3/26/2015 mascara Date Dollars $137.20 $ 152.01 $ 28.72 $167.08 $ 130.60 $ 175.99 $ 25.80 $ 217.84 $ 226.64 $ 73.50 $ 130.84 $ 71.03 $ 149.59 $ 56.47 $ (21.99) $137.39 Units 45 50 9 55 43 58 8 72 75 24 43 23 49 18 -8 45

Answer rating: 100% (QA)

1 Total number of units and dollar volume sold for each p... View the full answer