Download and open the Attachment.

Save the file using a meaningful file name. $(2$ points$)$

The Summary worksheet is where you will type in your answers from the analysis. Enter your name in B$2.$

Using data from the starting data file, please create ONE PivotTable that can be used to answer the questions for EACH analysis.

There should be THREE PivotTables overall, i$.$e$.,$ one for each analysis listed above.

For Analysis $2,$ Discount, please also create a PivotChart $($based on the PivotTable$)$ to visually compare the discount information.

For Analysis $3,$ Product Performance, the following Key Performance Indicators $($KPIs$)$ should be included in this PivotTable:

$(1)$ Product along with the total Cost of Goods Sold $($COGS$),$

$(2)$ Total units sold for each product, and

$(3)$ Average of Sale Price.

Add Slicers or Filters that can be used to show the information specifically for each Country and Segment.

Sort data in the PivotTable to help with your analyses.

Each PivotTable should...

contain all required information $(5$ points$)$

be well structured in order to easily locate information and provide accurate and complete answer$($s$)$ to the question. $(5$ points$)$

use clear and meaningful title, headings and labels $(2$ points$)$

utilize appropriate number format $(2$ points$)$

be placed on its own worksheet with an appropriate worksheet $($i$.$e$.,$ tab$)$ name. $(2$ points$)$

The PivotChart $($for Analysis $2)$ should be on the same worksheet as the PivotTable. Make sure to use an appropriate chart type with complete and meaningful chart elements $($e$.$g$.,$ chart title, data labels, legend keys, etc.$)$ and use clear and appropriate titles and labels without being too cluttered. $(5$ points$)$

Complete the Summary worksheet

The Summary worksheet has been programmed to give you some feedback as your enter the numbers. You won't be able to select of make changes to certain parts of the worksheet.

Sort the data in the PivotTable to help with your analyses, especially for Analysis $3.$