Answered step by step
Verified Expert Solution
Question
1 Approved Answer
Download and open the Attachment. Save the file using a meaningful file name. ( 2 points ) The Summary worksheet is where you will type
Download and open the Attachment.
Save the file using a meaningful file name. points
The Summary worksheet is where you will type in your answers from the analysis. Enter your name in B
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, ie one for each analysis listed above.
For Analysis Discount, please also create a PivotChart based on the PivotTable to visually compare the discount information.
For Analysis Product Performance, the following Key Performance Indicators KPIs should be included in this PivotTable:
Product along with the total Cost of Goods Sold COGS
Total units sold for each product, and
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 points
be well structured in order to easily locate information and provide accurate and complete answers to the question. points
use clear and meaningful title, headings and labels points
utilize appropriate number format points
be placed on its own worksheet with an appropriate worksheet ie tab name. points
The PivotChart for Analysis should be on the same worksheet as the PivotTable. Make sure to use an appropriate chart type with complete and meaningful chart elements eg chart title, data labels, legend keys, etc. and use clear and appropriate titles and labels without being too cluttered. 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
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started