Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Applying Excel - Data Visualization: Exercise (Part 2 of 2) On the Data Visualization Student tab in your Excel spreadsheet, update the price per unit

Applying Excel - Data Visualization: Exercise (Part 2 of 2) On the Data Visualization Student tab in your Excel spreadsheet, update the price per unit for all four products for Office Warehouse Inc. with the data below: Products Available Price per Unit Paper $ 21.00 per case Pens $ 9.00 per box Sticky Notes $ 9.50 per package Envelopes $ 4.50 per box Required: Create a Pivot Table and determine the following information while analyzing the data: 2. Which product has the highest? 3. 3. Which rep has the highest total sales for each region? (Enter your Total Sales to 2 decimal places.) 4. What is the total annual sales for each region? (Enter your Total Sales to 2 decimal places.) 5. Using the data from requirement 4, create a pie chart to determine the sales percentage for each region. 6. Now, using the Pivot Table, determine the monthly sales earned by each region. Use that data to create a 2D clustered column chart. Based on that column bar chart, identify the regions that had the highest and lowest monthly sales for the entire year

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Financial Accounting

Authors: V.K. Gopal

1st Edition

9788174467461

More Books

Students also viewed these Accounting questions

Question

Discuss about training and development in India?

Answered: 1 week ago

Question

Explain the various techniques of training and development.

Answered: 1 week ago

Question

Explain the various techniques of Management Development.

Answered: 1 week ago

Question

sharing of non-material benefits such as time and affection;

Answered: 1 week ago