(1.6) Create a PivotTable that adds a field to calculate the ratio of Avocado to Classic burger sales. a. Create a PivotTable on the CalculatedField1 worksheet. b. Show the sum of all products in the PivotTable. c. Create a column PivotChart of the PivotTable to show a comparison of the product sales. d. Insert a calculated field named "PercentAvocadoToClassic" (without the quotes) with the formula =Avocado/Classic. e. Change the number format of the calculated field to % with one decimal place. (1.7) Create a PivotTable to alculate the total of shakes, total of ries, and total of burgers (Avocado, BBQCheddar, Jalapeno, and (lassic). a. Create a PivotTable on the CalculatedField2 worksheet. b. Show the total of shakes, total of fries, and total of burgers (Classic, Avocado, BBQCheddar, and Jalapeno ). c. 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. a. Create a PivotTable on the PerDiffFrom worksheet showing the total of Burgers sold. b. Place months as the row field and years as the column field. c. Change that metric to show the % difference from the previous date. d. Make a PivotChart for the PivotTable that shows the change in sales over time. Drag fields between areas below: (1.6) Create a PivotTable that adds a field to calculate the ratio of Avocado to Classic burger sales. a. Create a PivotTable on the CalculatedField1 worksheet. b. Show the sum of all products in the PivotTable. c. Create a column PivotChart of the PivotTable to show a comparison of the product sales. d. Insert a calculated field named "PercentAvocadoToClassic" (without the quotes) with the formula =Avocado/Classic. e. Change the number format of the calculated field to % with one decimal place. (1.7) Create a PivotTable to alculate the total of shakes, total of ries, and total of burgers (Avocado, BBQCheddar, Jalapeno, and (lassic). a. Create a PivotTable on the CalculatedField2 worksheet. b. Show the total of shakes, total of fries, and total of burgers (Classic, Avocado, BBQCheddar, and Jalapeno ). c. 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. a. Create a PivotTable on the PerDiffFrom worksheet showing the total of Burgers sold. b. Place months as the row field and years as the column field. c. Change that metric to show the % difference from the previous date. d. Make a PivotChart for the PivotTable that shows the change in sales over time. Drag fields between areas below