The data is out of 200 cells but I reduced it. Please include formulas and description of what is done.
B. Product (10 points). Go to the 'Products' worksheet to see the data 1. In how many countries are products sold? (1 point) 2. Some products have more than a single Sales Price. For the product Carretera, what is the lowest sales price? (1 point) 3. What is the difference between the highest and lowest sales price for the product Amarilla? (1 point) 4. What is the percentage increase (or decrease) in Sales from 2013 to 2014? (1 point) 90540 1 Segment Country Product Discount B Units Sold Manufactu Sale Price Gross Sales Discounts Sales : COGS Profit Month Number Month Nar Year 2 Governmer Canada Carretera None 1618.5 3 20 32370 0 32370 16185 16185 1 January 2014 3 Governmer Germany Carretera None 1321 3 20 26420 0 26420 13210 13210 1 January 2014 4 Midmarket France Carretera None 2178 3 15 32670 o 32670 21780 10890 6 June 2014 5 Midmarket Germany Carretera None 888 3 15 13320 0 13320 8880 4440 6 June 2014 6 Midmarket Mexico Carretera None 2470 3 15 37050 0 37050 24700 12350 6 June 2014 7 Governmer Germany Carretera None 1513 3 350 529550 0 529550 393380 136170 12 December 2014 8 Midmarket Germany Montana None 921 5 5 15 13815 0 13815 9210 4605 3 March 2014 9 Channel Pa Canada Montana None 2518 5 12 30216 0 30216 7554 22662 6 June 2014 10 Governmer France Montana None 1899 5 20 37980 0 37980 18990 18990 6 June 2014 11 Channel Pa Germany Montana None 1545 5 12 18540 0 18540 4635 13905 6 June 2014 12 Midmarket Mexico Montana None 2470 5 15 37050 0 37050 24700 12350 6 June 2014 13 Enterprise Canada Montana None 2665.5 5 125 333187.5 0333187.5 319860 13327.5 7 July 2014 14 Small Busir Mexico Montana None 958 5 300 287400 0 287400 239500 47900 8 August 2014 15 Governmer Germany Montana None 2146 5 7 15022 0 15022 10730 4292 9 September 2014 16 Enterprise Canada Montana None 345 5 5 125 43125 0 0 43125 41400 1725 10 October 2013 17 Midmarket United Stat Montana None 615 5 15 9225 0 9225 6150 3075 12 December 2014 18 Governmer Canada Paseo None 292 10 20 5840 0 5840 2920 2920 2 February 2014 19 Midmarket Mexico Paseo None 974 10 15 14610 0 14610 9740 4870 2 February 2014 20 Channel Pa Canada Paseo None 2518 10 12 30216 0 30216 7554 22662 6 June 2014 21 Governmer Germany Paseo None 1006 10 350 352100 0 352100 261560 6 June 2014 22 Channel Pa Germany Paseo None 367 10 12 4404 0 4404 1101 3303 7 July 2014 23 Governmer Mexico Paseo None 883 10 7 6181 0 6181 4415 1766 8 August 2014 24 Midmarket France Paseo None 549 10 15 8235 0 8235 5490 2745 9 September 2013 25 Small Busir Mexico Paseo None 788 10 300 236400 0 236400 197000 39400 9 September 2013 26 Midmarket Mexico Paseo None 2472 10 15 37080 0 37080 24720 12360 9 September 2014 27 Governmer United Stat Paseo None 1143 10 7 8001 0 8001 5715 2286 10 October 2014 28 Governmer Canada Paseo None 1725 10 350 603750 0 603750 448500 155250 11 November 2013 29 Channel Pa United Stat Paseo None 912 10 12 10944 0 10944 2736 8208 11 November 2013 30 Midmarket Canada Paseo None 2152 10 15 32280 0 32280 21520 10760 12 December 2013 31 Governmer Canada Paseo None 1817 10 20 36340 0 36340 18170 18170 12 December 2014 32 Governmer Germany Paseo None 1513 10 350 529550 0 529550 393380 136170 12 December 2014 33 Governmer Mexico Velo None 1493 120 7 10451 0 10451 7465 2986 1 January 2014 34 Enterprise France Velo None 1804 120 125 225500 0 225500 216480 9020 2 February 2014 35 Channel Pa Germany Velo None 2161 120 12 25932 o 25932 6483 19449 3 March 2014 36 Governmer Germany Velo None 1006 120 350 352100 0 0 352100 261560 90540 6 June 2014 37 Channel Pa Germany Velo None 1545 120 12 18540 0 18540 4635 13905 6 June 2014 38 Enterprise United Stat Velo None 2821 120 125 352625 0 352625 338520 14105 8 August 2014 39 Enterprise Canada Velo None 345 120 125 43125 0 43125 41400 1725 10 October 2013 40 Small Busir Canada VTT None 2001 250 300 600300 0 600300 500250 100050 2 February 2014 41 Channel Pa Germany VTT None 2838 250 12 34056 0 34056 8514 25542 4 April 2014 42 Midmarket France VTT None 2178 250 15 32670 0 32670 21780 10890 6 June 2014 B. Product (10 points). Go to the 'Products' worksheet to see the data 1. In how many countries are products sold? (1 point) 2. Some products have more than a single Sales Price. For the product Carretera, what is the lowest sales price? (1 point) 3. What is the difference between the highest and lowest sales price for the product Amarilla? (1 point) 4. What is the percentage increase (or decrease) in Sales from 2013 to 2014? (1 point) 90540 1 Segment Country Product Discount B Units Sold Manufactu Sale Price Gross Sales Discounts Sales : COGS Profit Month Number Month Nar Year 2 Governmer Canada Carretera None 1618.5 3 20 32370 0 32370 16185 16185 1 January 2014 3 Governmer Germany Carretera None 1321 3 20 26420 0 26420 13210 13210 1 January 2014 4 Midmarket France Carretera None 2178 3 15 32670 o 32670 21780 10890 6 June 2014 5 Midmarket Germany Carretera None 888 3 15 13320 0 13320 8880 4440 6 June 2014 6 Midmarket Mexico Carretera None 2470 3 15 37050 0 37050 24700 12350 6 June 2014 7 Governmer Germany Carretera None 1513 3 350 529550 0 529550 393380 136170 12 December 2014 8 Midmarket Germany Montana None 921 5 5 15 13815 0 13815 9210 4605 3 March 2014 9 Channel Pa Canada Montana None 2518 5 12 30216 0 30216 7554 22662 6 June 2014 10 Governmer France Montana None 1899 5 20 37980 0 37980 18990 18990 6 June 2014 11 Channel Pa Germany Montana None 1545 5 12 18540 0 18540 4635 13905 6 June 2014 12 Midmarket Mexico Montana None 2470 5 15 37050 0 37050 24700 12350 6 June 2014 13 Enterprise Canada Montana None 2665.5 5 125 333187.5 0333187.5 319860 13327.5 7 July 2014 14 Small Busir Mexico Montana None 958 5 300 287400 0 287400 239500 47900 8 August 2014 15 Governmer Germany Montana None 2146 5 7 15022 0 15022 10730 4292 9 September 2014 16 Enterprise Canada Montana None 345 5 5 125 43125 0 0 43125 41400 1725 10 October 2013 17 Midmarket United Stat Montana None 615 5 15 9225 0 9225 6150 3075 12 December 2014 18 Governmer Canada Paseo None 292 10 20 5840 0 5840 2920 2920 2 February 2014 19 Midmarket Mexico Paseo None 974 10 15 14610 0 14610 9740 4870 2 February 2014 20 Channel Pa Canada Paseo None 2518 10 12 30216 0 30216 7554 22662 6 June 2014 21 Governmer Germany Paseo None 1006 10 350 352100 0 352100 261560 6 June 2014 22 Channel Pa Germany Paseo None 367 10 12 4404 0 4404 1101 3303 7 July 2014 23 Governmer Mexico Paseo None 883 10 7 6181 0 6181 4415 1766 8 August 2014 24 Midmarket France Paseo None 549 10 15 8235 0 8235 5490 2745 9 September 2013 25 Small Busir Mexico Paseo None 788 10 300 236400 0 236400 197000 39400 9 September 2013 26 Midmarket Mexico Paseo None 2472 10 15 37080 0 37080 24720 12360 9 September 2014 27 Governmer United Stat Paseo None 1143 10 7 8001 0 8001 5715 2286 10 October 2014 28 Governmer Canada Paseo None 1725 10 350 603750 0 603750 448500 155250 11 November 2013 29 Channel Pa United Stat Paseo None 912 10 12 10944 0 10944 2736 8208 11 November 2013 30 Midmarket Canada Paseo None 2152 10 15 32280 0 32280 21520 10760 12 December 2013 31 Governmer Canada Paseo None 1817 10 20 36340 0 36340 18170 18170 12 December 2014 32 Governmer Germany Paseo None 1513 10 350 529550 0 529550 393380 136170 12 December 2014 33 Governmer Mexico Velo None 1493 120 7 10451 0 10451 7465 2986 1 January 2014 34 Enterprise France Velo None 1804 120 125 225500 0 225500 216480 9020 2 February 2014 35 Channel Pa Germany Velo None 2161 120 12 25932 o 25932 6483 19449 3 March 2014 36 Governmer Germany Velo None 1006 120 350 352100 0 0 352100 261560 90540 6 June 2014 37 Channel Pa Germany Velo None 1545 120 12 18540 0 18540 4635 13905 6 June 2014 38 Enterprise United Stat Velo None 2821 120 125 352625 0 352625 338520 14105 8 August 2014 39 Enterprise Canada Velo None 345 120 125 43125 0 43125 41400 1725 10 October 2013 40 Small Busir Canada VTT None 2001 250 300 600300 0 600300 500250 100050 2 February 2014 41 Channel Pa Germany VTT None 2838 250 12 34056 0 34056 8514 25542 4 April 2014 42 Midmarket France VTT None 2178 250 15 32670 0 32670 21780 10890 6 June 2014
