Question: Rep 1. Create pivot table summarizes total sales revenue by regions and year/quarter. Andrews Andrews Andrews Andrews Andrews Gill Gill Units 43 28 75 66

Rep 1. Create pivot table summarizes total sales revenue by regions

Rep 1. Create pivot table summarizes total sales revenue by regions and year/quarter. Andrews Andrews Andrews Andrews Andrews Gill Gill Units 43 28 75 66 14 46 80 27 27 53 7 11 94 2. Create pivot atble to find out average unit cost per iterm for each quarter. G 3. Create pivot bar chart to display the total sales by each rep, rank from the the highest to the lowest. 36 4.99 Region Central Central Central Central Central Central Central Central Central Central Central Central Central Central Central Central Central Central Central Central Central Central Central Central Central Central East East East East East East East East East East East East East West West West West West West West West West Wast Gill Jardine Jardine Jardine Jardine Jardine Kivel Kivel Kivel Kivell Morgan Morgan Morgan Smith Smith Smith Howard Howard Jones Jones Jones Jones Jones Jones Jones Jones Parent Parent Parent Sorvino Sorvino Sorvino Sorvino Thompson Thompson Thompson James James James Item Binder Binder Pencil Pencil Pencil Binder Binder Pen Pen Pencil Pencil Binder Binder Pen Set Pencil Pencil Binder Desk Pen Set Pen Set Binder Pen Set Pencil Binder Desk Pencil Binder Pen Binder Binder Binder Pen Pen Set Pen Set Pencil Pencil Binder Pen Pen Set Binder Desk Pen Pencil Pen Binder Pencil Pencil Pen Set Binder |||5%95]%B: 96 42 28 55 90 87 2 67 29 96 60 60 4 64 16 62 95 35 81 15 74 7 3 76 56 48 57 32 45 24 36 UnitCost Total 4.99 214.57 4.99 139.72 1.99 149.25 1.99 131.34 1.29 18.06 8.99 413.54 8.99 719.2 19.99 539.73 19.99 539.73 1.29 68.37 1.29 9.03 4.99 54.89 19.99 1,879.06 4.99 249.5 4.99 179.64 449.1 19.99 999.5 125 625 4.99 479.04 23.95 1,005.90 8.99 251.72 12.49 686.95 4.99 449.1 15 1,305.00 125 250 1.29 86.43 1.99 57.71 4.99 479.04 4.99 299.4 8.99 539.4 4.99 19.96 8.99 575.36 15.99 255.84 4.99 309.38 1.99 189.05 4.99 174.65 19.99 1,619.19 19.99 299.85 15.99 1,183.26 19.99 139.93 825 1.99 151.24 2.99 167.44 5.99 287.52 19.99 1,139.43 1.99 63.68 1.99 89.55 25.99 623.76 12.99 467 4 Year 2016 2016 2016 2016 2016 2016 2016 2016 2016 2016 2016 2016 2016 2016 2016 2016 2016 2016 2016 2016 2016 2016 2016 2016 2016 2016 2016 2016 2016 2016 2016 2016 2016 2016 2016 2016 2016 2016 2016 2016 2016 2016 2016 2016 2016 2016 2016 2016 2016 Quarter 1 2 1 2 3 1 2 1 2 1 2 1 2 1 2 3 1 1 1 3 1 1 1 2 2 2 1 1 1 2 3 2 1 2 1 3 1 1 2 1 2 1 2 2 1 2 1 1 275 Rep 1. Create pivot table summarizes total sales revenue by regions and year/quarter. Andrews Andrews Andrews Andrews Andrews Gill Gill Units 43 28 75 66 14 46 80 27 27 53 7 11 94 2. Create pivot atble to find out average unit cost per iterm for each quarter. G 3. Create pivot bar chart to display the total sales by each rep, rank from the the highest to the lowest. 36 4.99 Region Central Central Central Central Central Central Central Central Central Central Central Central Central Central Central Central Central Central Central Central Central Central Central Central Central Central East East East East East East East East East East East East East West West West West West West West West West Wast Gill Jardine Jardine Jardine Jardine Jardine Kivel Kivel Kivel Kivell Morgan Morgan Morgan Smith Smith Smith Howard Howard Jones Jones Jones Jones Jones Jones Jones Jones Parent Parent Parent Sorvino Sorvino Sorvino Sorvino Thompson Thompson Thompson James James James Item Binder Binder Pencil Pencil Pencil Binder Binder Pen Pen Pencil Pencil Binder Binder Pen Set Pencil Pencil Binder Desk Pen Set Pen Set Binder Pen Set Pencil Binder Desk Pencil Binder Pen Binder Binder Binder Pen Pen Set Pen Set Pencil Pencil Binder Pen Pen Set Binder Desk Pen Pencil Pen Binder Pencil Pencil Pen Set Binder |||5%95]%B: 96 42 28 55 90 87 2 67 29 96 60 60 4 64 16 62 95 35 81 15 74 7 3 76 56 48 57 32 45 24 36 UnitCost Total 4.99 214.57 4.99 139.72 1.99 149.25 1.99 131.34 1.29 18.06 8.99 413.54 8.99 719.2 19.99 539.73 19.99 539.73 1.29 68.37 1.29 9.03 4.99 54.89 19.99 1,879.06 4.99 249.5 4.99 179.64 449.1 19.99 999.5 125 625 4.99 479.04 23.95 1,005.90 8.99 251.72 12.49 686.95 4.99 449.1 15 1,305.00 125 250 1.29 86.43 1.99 57.71 4.99 479.04 4.99 299.4 8.99 539.4 4.99 19.96 8.99 575.36 15.99 255.84 4.99 309.38 1.99 189.05 4.99 174.65 19.99 1,619.19 19.99 299.85 15.99 1,183.26 19.99 139.93 825 1.99 151.24 2.99 167.44 5.99 287.52 19.99 1,139.43 1.99 63.68 1.99 89.55 25.99 623.76 12.99 467 4 Year 2016 2016 2016 2016 2016 2016 2016 2016 2016 2016 2016 2016 2016 2016 2016 2016 2016 2016 2016 2016 2016 2016 2016 2016 2016 2016 2016 2016 2016 2016 2016 2016 2016 2016 2016 2016 2016 2016 2016 2016 2016 2016 2016 2016 2016 2016 2016 2016 2016 Quarter 1 2 1 2 3 1 2 1 2 1 2 1 2 1 2 3 1 1 1 3 1 1 1 2 2 2 1 1 1 2 3 2 1 2 1 3 1 1 2 1 2 1 2 2 1 2 1 1 275

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 Finance Questions!

Suppose that you plan to contribute to your retirement fund once you start working full time. When you plan to withdraw, there is some penalty if you withdraw before age of 60. Use information in the...

Using the data below use excel to create the following steps, 1.Using Excel, create tables of the dimensions. 2. Using Excel, consolidate the dimensions into a fact table. 3. Use your fact table to...

B E F G H K M D 41 Central Morgan Pen Set 57 $11.99 $683.43 42 Central Andrews Pen Set 31 $23.45 $726.95 3) Which Sales Rep from the Central Region has the largest total sales? 43 West Andrews Desk...

from the data provided, create a pivot table. once created what stands out? what does not appear to be right? for example if sales are better in a certain region. From the Data create a pivot table...

NOTE: please just help me with what can be done and I can resubmit the rest into another question. Up to here is what I will like help on if possible the rest is just for more info and can resubmit...

Can someone help me with these problems? File Home Insert Draw Page Layout Formulas Data Review View Developer Help Power Pivot Share X Arial 12 AI ab General $ %) Conditional Formatting Format as...

please Answer everything do give all the calculation be clear and precise do the chart please if you dont see or understand something tell me ps this is the same excel i just took some pictures where...

I need help with my part 1 and part 2.can you finished ,thank u FINA 415-15S PART 2 (VBA) # Worksheet Name 1 A 2 B Description Programing user defined function (30 marks) Subroutine to generate after...

I need help with part,can you help me finish it?thank u FINA 415-15S Exam PART 1 Excel # 1 2 3 4 5 6 Worksheet Name Solver Look Up Function Matrix Pivot table Data Table Offset Function Description...

Give examples of types of business rules that are not reflected in a Presentation Layer ER diagram.

Creating a binomial distribution table using R Write an R code for creating a binomial table for the following n and p. 1. n = 1,...,10 2. p = 0.05, 0.1, 0.2, 0.3, 0.4, 0.5, 0.6,0.7, 0.8, 0.9, 0.95...

For a company and October 31st 20 24 indicated a balance of 9,870 the statement received from the bank indicated that he balance of 10,200 on October 31st 2024 .comparing bank statement the...

8:37 * N. 80% i ... OBJECTIVES: Create relationships Create a Pivot Table from Related Tables Create a PivotChart Modify the PivotChart The major section in this chapter :ontinuation is: Data...

8. Do you agree or disagree? Explain your reasoning. There need be no trade-off between equality and efficiency. An efficient economy that yields an income distribution that many regard as unfair may...

2. Assume that Al, Beth, Carol, David, and Ed receive incomes of $500, $250, $125, $75, and $50, respectively. Construct and interpret a Lorenz curve for this five-person economy. What percentage of...

11. What are the essential differences between social insurance and public assistance programs? Why is Medicare a social insurance program, whereas Medicaid is a public assistance program? Why is the...