I need help for me Excel assignment, if you could pls respond with picture steps, that would be preferred, I am very confused 1.2 Create a PivotTable to calculate the total sales for each product. Create a PivotTable on the SumOfProducts worksheet. Show the totals of all the kinds of products sold at Burger Hut. 1.3 Create a PivotTable to calculate summary statistics on Classic Burger sales. Create a PivotTable on the ClassicBurgerStats worksheet. Show the SUM, AVERAGE, MIN, and MAX Classic Burgers sold. 1.4 Create a PivotTable to examine if coupons affect Classic Burger sales. Create a PivotTable on the ClassicBurgerByCoupon worksheet to answer the question, "Did the coupons affect the sales of Classic Burgers?" Show the AVERAGE, MIN, and MAX Classic Burgers sold. Add the Coupon dimension to the PivotTable. Make a PivotChart for the PivotTable data. 1.5 Create a PivotTable to examine which product sales are seasonal. Create a PivotTable on the ProductSalesByDate worksheet to answer the question, "Which of the products have sales that are seasonal?" Show total product sales by date for each product. Expand year to quarter and quarter to month to show sales by year, quarter, and month. Remove the display of the Year Subtotals from the PivotTable. Create a Line PivotChart from the PivotTable report to see the change in values over time. Click on the collapse entire field button and then the expand button to see how the PivotChart changes. +/- buttons in the bottom right corner of the chart. Sort the table by years from the newest to the oldest. Add conditional formatting (data bars) to the Jalapeno column. 1.6 Create a PivotTable that adds a field to calculate the ratio of Avocado to Classic burger sales. Create a PivotTable on the CalculatedField1 worksheet. Show the sum of all products in the PivotTable. Create a column PivotChart of the PivotTable to show a comparison of the product sales. Insert a calculated field named "PercentAvocadoToClassic" (without the quotes) with the formula =Avocado/Classic. Change the number format of the calculated field to % with one decimal place. 1.7 Create a PivotTable to calculate the total of shakes, total of fries, and total of burgers (Avocado, BBQCheddar, Jalapeno, and Classic). Create a PivotTable on the CalculatedField2 worksheet. Show the total of shakes, total of fries, and total of burgers (Classic, Avocado, BBQCheddar, and Jalapeno ). Hint: use a calculated field, named "Burgers" (without the quotes) to create the total of Burgers. 1.8 Create a PivotTable to examine sales between dates. Create a PivotTable on the PerDiffFrom worksheet showing the total of Burgers sold. Place months as the row field and years as the column field. Change that metric to show the % difference from the previous date. Make a PivotChart for the PivotTable that shows the change in sales over time.