solve

6, Insert a line chart to show the total sale amount for each order by order date. a.|_] Create the line chart using just the data from the Order Date and Total Sale columns. Be sure to include the header row when selecting the data for the chart. b._] There was an ordering glitch on September 7 that caused a spike in sales. Apply a filter to the chart to hide orders from that date. Notice the effect on the chart. c.LI if necessary, move the chart so it does not cover the table data. 7._] Add aslicer to the table so you can filter by shoe name. Use the slicer to display data for the Sperry shoe only. Notice the effect on the chart. . Create a PivotTable from the data in the Sales worksheet. Use the Sum of Price Per Pair by Region recommended PivotTable. aL] Modify the PivotTable so the Price Per Pair data are averaged, not totaled. b.|_] Add the Shoe field to the PivotTable. It should appear in the Rows section below the Region field. A ) Format all the values in the PivotTable using the Accounting Number Format. 9. Create a clustered column PivotChart based on the PivotTable data. Use the first recommended column chart type. a. L_] Hide the chart title and legend. b. |] Add standard error bars to the chart. cL if necessary, move the PivotChart on the worksheet so it does not cover the PivetChart data. 10.|_] Go to the 5y Region worksheet and add Column Sparklines in F3:F7 for data in columns B3:E7