Step by step 1-13

Pivot Tables and Chart Instructions: NanPpon = 10. 11. 12: 13. Open the file Excelproducts. pivot. Change the range to a table. Name the table Datarange. Insert a pivot table on a new worksheet. Build the table to reflect the countries, their discount bands by sales price. Filter the table to reflect Canada and Mexico only. Create a pivot chart to reflect this data. a. Selecta line chart b. Selecta 3D line c. Position the Chart from D3 on. Name the sheet DisBand. Use the table Datarange to insert a second pivot table on a new worksheet. Name the worksheet Units. Build the pivot table to reflect the product and number of units sold and the sales price. Change the title of : Lables to Product1 Units sold (place a space after) Sales price (place a space after) aoc Center all headings e. Change the table style to pink pivot style medium 20 Save the workbook as range.lastname.epivot then upload it to the VLE