1: a) Make appropriate pivot chart and table by considering the following variables. Figure out:

Sales on Channel 12: 1 kg Blueberry Muesli in 02 N.

b) What is spark line? Answer briefly in the excel sheet. Make spark line using sales

price from the data above.

Kindly answer this question on Microsoft Excel and then take picture and then send it to me. Kindly do it faster.

I am giving the data below:

delivery_date material_code description unit_size location sales_price sales_quantity channel 7/8/2019 CC-F02 500g Blueberry Muesli 500 g 02S 3.76 750 14 7/9/2019 CC-F01 500g Nut Muesli 500 g 02N 2.99 949 14 7/10/2019 CC-F01 500g Nut Muesli 500 g 02N 2.99 750 14 7/23/2019 CC-F02 500g Blueberry Muesli 500 g 02S 3.32 3000 12 7/23/2019 CC-F01 500g Nut Muesli 500 g 02S 2.62 3000 12 7/23/2019 CC-F03 500g Strawberry Muesli 500 g 02S 3.41 3000 12 7/23/2019 CC-F03 500g Strawberry Muesli 500 g 02W 3.41 3000 12 8/2/2019 CC-F04 500g Raisin Muesli 500 g 02N 2.68 3000 14 8/6/2019 CC-F11 1kg Nut Muesli 1 kg 02W 4.61 2444 12 8/14/2019 CC-F12 1kg Blueberry Muesli 1 kg 02W 5.94 2192 12 8/16/2019 CC-F01 500g Nut Muesli 500 g 02W 2.52 4300 12 8/20/2019 CC-F03 500g Strawberry Muesli 500 g 02S 3.38 2250 12 8/21/2019 CC-F12 1kg Blueberry Muesli 1 kg 02N 5.94 1987 12 8/29/2019 CC-F14 1kg Raisin Muesli 1 kg 02W 4.06 3136 12 9/5/2019 CC-F06 500g Mixed Fruit Muesli 500 g 02N 2.72 4500 12 9/5/2019 CC-F06 500g Mixed Fruit Muesli 500 g 02S 2.93 3000 14 9/10/2019 CC-F11 1kg Nut Muesli 1 kg 02S 4.1 3000 12 9/13/2019 CC-F16 1kg Mixed Fruit Muesli 1 kg 02N 4.86 2515 12 9/18/2019 CC-F14 1kg Raisin Muesli 1 kg 02S 3.94 2250 12 9/27/2019 CC-F12 1kg Blueberry Muesli 1 kg 02N 5.86 2153 12 10/2/2019 CC-F06 500g Mixed Fruit Muesli 500 g 02S 2.67 3249 12 10/18/2019 CC-F13 1kg Strawberry Muesli 1 kg 02N 6.75 1612 12 10/28/2019 CC-F15 1kg Original Muesli 1 kg 02N 4.28 3268 12 10/31/2019 CC-F11 1kg Nut Muesli 1 kg 02W 5.11 750 12 11/1/2019 CC-F12 1kg Blueberry Muesli 1 kg 02N 6.74 2115 12 11/11/2019 CC-F01 500g Nut Muesli 500 g 02W 3.29 4500 14 11/15/2019 CC-F16 1kg Mixed Fruit Muesli 1 kg 02S 4.95 3750 10 11/21/2019 CC-F16 1kg Mixed Fruit Muesli 1 kg 02S 5.36 1500 12 11/21/2019 CC-F01 500g Nut Muesli 500 g 02N 3.14 3000 12 11/22/2019 CC-F14 1kg Raisin Muesli 1 kg 02W 4.11 3646 12 11/25/2019 CC-F03 500g Strawberry Muesli 500 g 02W 4.22 2583 12 11/29/2019 CC-F06 500g Mixed Fruit Muesli 500 g 02S 3.1 2250 12 12/2/2019 CC-F02 500g Blueberry Muesli 500 g 02S 3.99 3000 12 12/3/2019 CC-F11 1kg Nut Muesli 1 kg 02S 5.51 3750 12 12/6/2019 CC-F03 500g Strawberry Muesli 500 g 02N 4.38 3239 12 12/12/2019 CC-F01 500g Nut Muesli 500 g 02S 3.47 3565 14 12/24/2019 CC-F01 500g Nut Muesli 500 g 02S 3.29 6000 12 12/24/2019 CC-F05 500g Original Muesli 500 g 02S 2.88 4543 12 12/24/2019 CC-F16 1kg Mixed Fruit Muesli 1 kg 02W 5.82 2349 12 12/24/2019 CC-F02 500g Blueberry Muesli 500 g 02W 4.27 2250 12 12/27/2019 CC-F14 1kg Raisin Muesli 1 kg 02N 4.68 2526 12 1/9/2020 CC-F16 1kg Mixed Fruit Muesli 1 kg 02S 6.23 1964 12 1/21/2020 CC-F05 500g Original Muesli 500 g 02S 3.1 3806 12 1/23/2020 CC-F06 500g Mixed Fruit Muesli 500 g 02N 3.83 4000 14 1/24/2020 CC-F01 500g Nut Muesli 500 g 02S 3.71 4992 14 1/28/2020 CC-F16 1kg Mixed Fruit Muesli 1 kg 02N 6.27 3119 12 2/3/2020 CC-F14 1kg Raisin Muesli 1 kg 02S 5.83 2240 12 2/6/2020 CC-F02 500g Blueberry Muesli 500 g 02N 4.85 2865 12 2/10/2020 CC-F15 1kg Original Muesli 1 kg 02S 5.25 4034 10 2/13/2020 CC-F01 500g Nut Muesli 500 g 02W 3.52 3080 12 2/14/2020 CC-F03 500g Strawberry Muesli 500 g 02S 4.59 2000 12 2/14/2020 CC-F11 1kg Nut Muesli 1 kg 02S 6.07 3888 12 2/17/2020 CC-F01 500g Nut Muesli 500 g 02N 3.52 3766 12 2/17/2020 CC-F16 1kg Mixed Fruit Muesli 1 kg 02N 6.41 2358 12 2/19/2020 CC-F16 1kg Mixed Fruit Muesli 1 kg 02W 6.41 750 12 2/20/2020 CC-F02 500g Blueberry Muesli 500 g 02S 4.74 2000 12