D Use the data in the SALES worksheet to create a PIVOT TABLE The table must show the amount of sales and the number of units for each representative, for each year (just the year no month, no day), for each invitation type Name the resulting worksheet PIVOT TABLE SALE Order Date Region Representative Invitation type Units (100) Unit Cost Total 01 06 20 East Jones Birthday 95 1 99 18,905 01 23 20 Central Kivell Business 50 3 49 17,450 02 09 20 Central Jardine Birthday 36 4 99 17,964 02 26 20 Central Gill Wedding 27 1 99 5,373 03 15 20 West Sorvino Birthday 56 2 99 16,744 04 01 20 East Jones Business 60 4 99 29,940 04 18 20 Central Andrews Birthday 75 1 99 14,925 05 05 20 Central Jardine Birthday 90 4 99 44,910 05 22 20 West Thompson Birthday 32 1 99 6,368 06 08 20 East Jones Business 60 0 85 5,100 06 25 20 Central Morgan Birthday 90 4 99 44,910 07 12 20 East Howard Business 29 1 99 5,771 07 29 20 East Parent Business 81 1 14 9,234 08 15 20 East Jones Birthday 35 2 27 7,945 09 01 20 Central Smith Wedding 2 2 5 500 09 18 20 East Jones Graduation 16 1 57 2,512 10 05 20 Central Morgan Business 28 3 14 8,792 10 22 20 East Jones Wedding 64 1 35 8,640 11 08 20 East Parent Wedding 15 0 97 1,455 11 25 20 Central Kivell Graduation 96 2 32 22,272 12 12 20 Central Smith Birthday 67 1 29 8,643 12 29 20 East Parent Graduation 74 3 17 23,458 01 15 21 Central Gill Business 46 8 99 41,354 02 01 21 Central Smith Business 87 15 130,500 02 18 21 East Jones Business 4 4 99 1,996 03 07 21 West Sorvino Business 7 19 99 13,993 03 24 21 Central Jardine Graduation 50 4 99 24,950 04 10 21 Central Andrews Birthday 66 1 99 13,134 04 27 21 East Howard Wedding 96 4 99 47,904 05 14 21 Central Gill Birthday 53 1 29 6,837 05 31 21 Central Gill Business 80 1 04 8,320 06 17 21 Central Kivell Wedding 5 1 5 750 07 04 21 East Jones Graduation 62 1 87 11,594 07 21 21 Central Morgan Graduation 55 2 49 13,695 08 07 21 Central Kivell Graduation 42 2 16 9,072 08 24 21 West Sorvino Wedding 3 2 48 744 09 10 21 Central Gill Birthday 7 1 29 903 09 27 21 West Sorvino Wedding 76 1 99 15,124 10 14 21 West Thompson Business 57 1 72 9,804 10 31 21 Central Andrews Birthday 14 1 29 1,806 11 17 21 Central Jardine Business 11 0 58 638 12 04 21 Central Jardine Business 94 1 99 18,706 12 21 21 Central Andrews Business 28 1 21 3,388

The Answer is in the image, click to view ...

Question: D. Use the data in the SALES worksheet to create a PIVOT TABLE. The table must show the amount of sales and the number of

D. Use the data in the SALES worksheet to create a PIVOT TABLE. The table must show the amount of sales and the number of units for each representative, for each year (just the year-no month, no day), for each invitation type. Name the resulting worksheet PIVOT TABLE.

SALE-

"Order Date"	Region	Representative	"Invitation type"	"Units (100)"	"Unit Cost"	Total
01/06/20	East	Jones	Birthday	95	1.99	18,905
01/23/20	Central	Kivell	Business	50	3.49	17,450
02/09/20	Central	Jardine	Birthday	36	4.99	17,964
02/26/20	Central	Gill	Wedding	27	1.99	5,373
03/15/20	West	Sorvino	Birthday	56	2.99	16,744
04/01/20	East	Jones	Business	60	4.99	29,940
04/18/20	Central	Andrews	Birthday	75	1.99	14,925
05/05/20	Central	Jardine	Birthday	90	4.99	44,910
05/22/20	West	Thompson	Birthday	32	1.99	6,368
06/08/20	East	Jones	Business	60	0.85	5,100
06/25/20	Central	Morgan	Birthday	90	4.99	44,910
07/12/20	East	Howard	Business	29	1.99	5,771
07/29/20	East	Parent	Business	81	1.14	9,234
08/15/20	East	Jones	Birthday	35	2.27	7,945
09/01/20	Central	Smith	Wedding	2	2.5	500
09/18/20	East	Jones	Graduation	16	1.57	2,512
10/05/20	Central	Morgan	Business	28	3.14	8,792
10/22/20	East	Jones	Wedding	64	1.35	8,640
11/08/20	East	Parent	Wedding	15	0.97	1,455
11/25/20	Central	Kivell	Graduation	96	2.32	22,272
12/12/20	Central	Smith	Birthday	67	1.29	8,643
12/29/20	East	Parent	Graduation	74	3.17	23,458
01/15/21	Central	Gill	Business	46	8.99	41,354
02/01/21	Central	Smith	Business	87	15	130,500
02/18/21	East	Jones	Business	4	4.99	1,996
03/07/21	West	Sorvino	Business	7	19.99	13,993
03/24/21	Central	Jardine	Graduation	50	4.99	24,950
04/10/21	Central	Andrews	Birthday	66	1.99	13,134
04/27/21	East	Howard	Wedding	96	4.99	47,904
05/14/21	Central	Gill	Birthday	53	1.29	6,837
05/31/21	Central	Gill	Business	80	1.04	8,320
06/17/21	Central	Kivell	Wedding	5	1.5	750
07/04/21	East	Jones	Graduation	62	1.87	11,594
07/21/21	Central	Morgan	Graduation	55	2.49	13,695
08/07/21	Central	Kivell	Graduation	42	2.16	9,072
08/24/21	West	Sorvino	Wedding	3	2.48	744
09/10/21	Central	Gill	Birthday	7	1.29	903
09/27/21	West	Sorvino	Wedding	76	1.99	15,124
10/14/21	West	Thompson	Business	57	1.72	9,804
10/31/21	Central	Andrews	Birthday	14	1.29	1,806
11/17/21	Central	Jardine	Business	11	0.58	638
12/04/21	Central	Jardine	Business	94	1.99	18,706
12/21/21	Central	Andrews	Business	28	1.21	3,388

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 General Management Questions!

" NYP ," New York Paper Co., is using its financial results for August 2019 (Table 1) as a base for projecting the company's budget for the remaining four months of the year (September-December)....

Directions For this assignment, complete the following steps in your Labor Hours workbook: On the Data tab, do the following: A . Add a column titled Status. B . Use the information from the last...

Instructions Reformat and provide appropriate calculations in the Income Statement Formatting tab to format the provided information in the following format (Areas for formulas [e.g., Gross Margin,...

how to complete this on excel Excel The Megamart corporation has collected data on Barbecue (BBQ) sales from March 2009 to April 2011 Your boss has asked you to compile the data to make it useful Use...

Aleeta Hecciatt, manager of the Red Bluff Pro Shop, would like to develop a marketing strategy for increasing pro shop patronage. She has requested data about the pro shop sales over the past several...

could someone please explain the process? e. a. 8. Go to the Customers worksheet. Ravi wants to create Pivot Tables that include customer, contract, and invoice data. Ravi wants to list and total...

please answer instructions 1-9 for a like! please and thank you! Y019_Excel_Ch06_Prepare_PartB_Sales_Analysis Project Description: Aleeta Herriott manager of the Red Blut Pro Shop, would like to...

18 In the Profit Analysis worksheet: Expenses costs include maintenance, cleaning, and administrative expenses associated for a car rental. The Expenses for one rental transaction will be determined...

Please explain how to do the steps below as in what ill put into the box to compute the correct output its requesting In the Profit Analysis worksheet: Expenses costs include maintenance, cleaning,...

You will complete a financial planning model that is derived from a set of assumptions and link together statements of projected cash, income and balance sheets that articulate. An Excel template,...

Robin owns Expert Salon Trend (EST), a hair salon products distribution company. After working for his father, a barber and beauty salon products distributor, he started his own business selling Paul...

Suppose you can trade a stock (S), and three-month European calls on the stock struck at 250, 300, and 350. The stock pays no dividends, is trading at $312.50, and has a volatility of 64%....

Apple has lost some brand value over the past year despite outstanding revenues. Group of answer choices True False

If a U.S. multinational firm borrows euros for one year at 8% interest, and during the year the euro appreciates by 7% relative to the dollar, the approximate before-tax cost of this debt in dollar...