PLEASE SHOW ALL FORMULAS USING EXCEL TO SOLVE THIS PROBLEM

F H J L M N P Q R s T U 1 2 3 4 5 6 A B D 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, 2018? (5 Points) 20 Points Total 7 Units Dollar Volume 0 0 0 0 0 0 0 0 0 8 9 10 Problem 1 11 Product 12 lip gloss 13 foundation 14 lipstik 15 eyeliner 16 mascara 17 18 19 20 21 22 Problems 2 through 6 23 Revenue before 12/10/2016 24 Units not sold by Nancy 25 Units sold between 1/15/2015 and 2/15/2016 26 Including the amounts on these dates 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 Trans Numbe Name Date Product Units 1 Abbey 3/15/2015 lip gloss 2 Daniele 2/21/2015 foundatio 3 Barbara 218/2016 lipstick 4 Daniele 5/4/2017 lip gloss 5 Richard 5/31/2015 lip gloss 6 Collette 11/9/2016 eye liner 7 Cristina 314/2015 eye liner 8 Collette 1923/2017 lip gloss 9 Barbara 6/17/2017 eye liner 10 Abbey 7120/2017 lip gloss 11 Barbara 11/12/2015 mascara 12 Barbara 191/2015 lip gloss 13 Emilee 8/13/2016 lip gloss 14 Daniele 12/15/2015 eye liner 15 Richard 9/2/2017 foundatio 16 Emile 3126/2015 mascara 17 Collette 4/12/2017 mascara 18 Nancy 8/13/2016 lip gloss 19 Nancy 10/10/2015 eye liner 20 Richard 11/9/2016 lip gloss 21 Richard 5/15/2017 mascara 22 Abbey 9/7/2015 eye liner 23 Collette 1/14/2017 mascara 24 Daniele 4/14/2016 foundatio 25 Nancy 10/21/2015 mascara 26 Emilee 11/18/2017 lip gloss 27 Nancy 3126/2015 lipstick 28 Cristina 9/4/2016 foundatio 29 Abbey 10/5/2017 foundatio 30 Daniele 10/29/2016 foundatio 31 Richard 8/24/2016 lip gloss 32 Cristina 3/10/2017 lip gloss 33 Cici 5/31/2015 mascara 34 Richard 8/22/2017 mascara 35 Nancy 12/10/2017 foundatio 36 Abbey 8/27/2015 lip gloss 37 Richard 6/19/2016 eye liner 38 Emilee 2/19/2016 foundatio 39 Cici 2/5/2017 foundatio 40 Daniele 6/6/2017 foundatio 41 Emilee 1/19/2015 eye liner 42 Emilee 3123/2016 mascara 43 Abbey 3/15/2015 foundatio 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 $ (2199) 45 $ 137.39 66 $199.65 88 $ 265.19 78 $ 236.15 57 $ 173.12 12 # 38.08 28 $ 86.51 25 $ 77.31 29 # 88.22 -4 $ 19.94) 24 $ 74.62 38 $ 115.99 77 $233.05 77 $233.36 60 182.25 6 $ 20.48 53 $16146 41 $ 125.27 19 $ 59.15 39 $ 119.30 2 $ 8.26 34 103.44 59 $179.01 -9 $ (24.63) 38 $ 115.58 25 $ 76.56 19 $ 59.38 86 $259.86 F H J L M N P Q R s T U 1 2 3 4 5 6 A B D 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, 2018? (5 Points) 20 Points Total 7 Units Dollar Volume 0 0 0 0 0 0 0 0 0 8 9 10 Problem 1 11 Product 12 lip gloss 13 foundation 14 lipstik 15 eyeliner 16 mascara 17 18 19 20 21 22 Problems 2 through 6 23 Revenue before 12/10/2016 24 Units not sold by Nancy 25 Units sold between 1/15/2015 and 2/15/2016 26 Including the amounts on these dates 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 Trans Numbe Name Date Product Units 1 Abbey 3/15/2015 lip gloss 2 Daniele 2/21/2015 foundatio 3 Barbara 218/2016 lipstick 4 Daniele 5/4/2017 lip gloss 5 Richard 5/31/2015 lip gloss 6 Collette 11/9/2016 eye liner 7 Cristina 314/2015 eye liner 8 Collette 1923/2017 lip gloss 9 Barbara 6/17/2017 eye liner 10 Abbey 7120/2017 lip gloss 11 Barbara 11/12/2015 mascara 12 Barbara 191/2015 lip gloss 13 Emilee 8/13/2016 lip gloss 14 Daniele 12/15/2015 eye liner 15 Richard 9/2/2017 foundatio 16 Emile 3126/2015 mascara 17 Collette 4/12/2017 mascara 18 Nancy 8/13/2016 lip gloss 19 Nancy 10/10/2015 eye liner 20 Richard 11/9/2016 lip gloss 21 Richard 5/15/2017 mascara 22 Abbey 9/7/2015 eye liner 23 Collette 1/14/2017 mascara 24 Daniele 4/14/2016 foundatio 25 Nancy 10/21/2015 mascara 26 Emilee 11/18/2017 lip gloss 27 Nancy 3126/2015 lipstick 28 Cristina 9/4/2016 foundatio 29 Abbey 10/5/2017 foundatio 30 Daniele 10/29/2016 foundatio 31 Richard 8/24/2016 lip gloss 32 Cristina 3/10/2017 lip gloss 33 Cici 5/31/2015 mascara 34 Richard 8/22/2017 mascara 35 Nancy 12/10/2017 foundatio 36 Abbey 8/27/2015 lip gloss 37 Richard 6/19/2016 eye liner 38 Emilee 2/19/2016 foundatio 39 Cici 2/5/2017 foundatio 40 Daniele 6/6/2017 foundatio 41 Emilee 1/19/2015 eye liner 42 Emilee 3123/2016 mascara 43 Abbey 3/15/2015 foundatio 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 $ (2199) 45 $ 137.39 66 $199.65 88 $ 265.19 78 $ 236.15 57 $ 173.12 12 # 38.08 28 $ 86.51 25 $ 77.31 29 # 88.22 -4 $ 19.94) 24 $ 74.62 38 $ 115.99 77 $233.05 77 $233.36 60 182.25 6 $ 20.48 53 $16146 41 $ 125.27 19 $ 59.15 39 $ 119.30 2 $ 8.26 34 103.44 59 $179.01 -9 $ (24.63) 38 $ 115.58 25 $ 76.56 19 $ 59.38 86 $259.86