Question: 4. Use the data in the sheet titled Raw data to calculate the profit for each product category and product sub category (ability to drill

$4. Use the data in the sheet titled \"Raw data\"$

4. Use the data in the sheet titled \"Raw data\" to calculate the profit for each product category and product sub category (ability to drill down). a. Create a new worksheet titled \"Q4 Profit by Category\" and insert a new pivot table for the data in the sheet \"Raw Data\". Move the worksheet to the 4th position. List the total profit for product categories and subcategories in this table c. Format the numbers to reflect the \"$\" symbol before the figures and 2 decimal places. d. Change the column headings to be meaningful

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer

Step: 1 Unlock blur-text-image

Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock

Step: 3 Unlock

Students Have Also Explored These Related Mathematics Questions!

Assignment: Excel (75 points) Read the brief case below. Using the Excel spreadsheet provided, complete the questions. Downtown Office Supply Downtown Office supply is a small family owned store in a...

Downtown Office Supply Downtown Office supply is a small family owned store in a small suburb. In order to maintain and grow the business the owners want to do some analysis to see how their sales...

Please solve question 4 (a-h) Thank you!! B E A 1 Office Supply Revenue Analysis 2 3 Revenue Amount $ 74,605.93 Assumptions (based on last year): Sales Discount Profit Margin $ 713,932.37 0.05 4...

Read the brief case below. Using the Excel spreadsheet provided, complete the questions. Downtown Office Supply Downtown Office supply is a small family owned store in a small suburb. In order to...

Use the data in the sheet titled "Raw data" to calculate the profit for each product category and product sub category ( ability to drill down ) . ( 1 6 points: 2 points each ) a . Create a new...

4. Use the data in the sheet titled "Raw data" to calculate the prot for each product category and product sub category (ability to drill down). a. Create a new worksheet titled \"Q4 Prot by...

Assignment: Excel Pivot Table ( 1 5 0 points) Read the brief case below. Using the Excel spreadsheet provided, complete the questions. Atlas Bikes Atlas Bikes has been selling their bikes since 1975...

Assignment: Excel Pivot Table (150 points) Read the brief case below. Using the Excel spreadsheet provided, complete the questions. Atlas Bikes Atlas Bikes has been selling their bikes since 1975 in...

Let Aut (G) & Inn (G) denote the autmorphism of G and inner automorphism of G respectively. Then which of the following is correct? If G is abelian Aut G is abelian If G is non abelian then G can be...

Government spending is $140 billion, and it collects 20% of all income in taxes. The government would have a balanced budget if total income was $____ billion.

Which of the following statements is true regarding impression management ( iM ) techniques? Ingratiation works well in interviews. Ingratiation is negatively related to performance ratings. Those...

7 Questions on Confidence Levels and Intervals/Margin of Error The Price Foundation sponsored and conducted a survey on support for leglaixing durgst in the Unit States. Fifty percent (sample...