Answered step by step
Verified Expert Solution
Question
1 Approved Answer
PLEASE SHOW ALL FORMULAS USING EXCEL. FOR EXAMPLE =SUMIF(G12:G47, J K L M N 19 Nancy B23 fx B D E F G H Use
PLEASE SHOW ALL FORMULAS USING EXCEL. FOR EXAMPLE =SUMIF(G12:G47,"
J K L M N 19 Nancy B23 fx B D E F G H 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. (5 Points) 2) Determine the total revenue earned before December 10, 2016. (5 Points) 3) How many units were sold by people other than Nancy? (5 Points) 4) How many units of makeup were sold between January 15, 2015, and February 15, 2016? (5 Points) b 7 20 Points Total 8 9 10 Problem 1 11 Product Units Dollar Volume Trans Number Name 12 lip gloss 0 1 Abbey 13 foundation 0 2 Danielle 14 lipstick 0 3 Barbara 15 eye liner 0 4 Danielle 16 mascara 0 5 Richard 17 6 Collette 18 7 Cristina 19 8 Collette 20 Barbara 21 10 Abbey 22 Problems 2 through 6 11 Barbara 23 Revenue before 12/10/2016 0 12 Barbara 24 Units not sold by Nancy 0 13 Emilee 25 Units sold between 1/15/2015 and 2/15/2016 0 14 Danielle 26 Including the amounts on those dates 0 15 Richard 27 16 Emilee 28 17 Collette 29 18 Nancy Jo Nancy 30 20 Richard 32 21 Richard 33 22 Abbey 34 23 Collette 35 24 Danielle 36 25 Nancy 37 26 Emilee 38 39 28 Cristina para Date Product Units 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 4/12/2017 mascara 8/13/2016 lip gloss 10/10/2015 eye liner 11/9/2016 lip gloss 5/15/2017 mascara 9/7/2015 eye liner 1/14/2017 mascara 4/14/2016 foundation 10/21/2015 mascara 11/18/2017 lip gloss 3/26/2015 lipstick 9/4/2016 foundation Dollars 45 S 137.20 50 S 152.01 9 S 28.72 55 S 167.08 43 $ 130.60 58 $ 175.99 8 $ 25.80 72 $ 217.84 75 $ 226.64 24 $ 73.50 43 S 130.84 23 $ 71.03 49 S 149.59 18 $ 56.47 -8 $ (21.99) 45 S 137.39 66 $ 199.65 88 S 265.19 78 $ 236.15 57 S 173.12 12 s 38.08 28 S 86.51 25 S 77.31 29 S 88.22 4 5 (9.94) 24 S 74.62 38 $ 115.99 77 S 233.05 27 Nancy
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started