Question

Saeko has a yarn shop and wants to expand the colors in her yarn lines. She sends you the raw data in the "Pivot Table Data" tab.This data consists of the number of yards and meters of the color names, and the color types that each name belongs to, sold during her busiest weekend last year.

1. Use the "Pivot Table Data" tab to create a pivot table that shows Saeko the number of yards and meters that were sold in the various yarn types during the busiest weekend of her shop last year.

Using the pivot table that you just created, determine which of the color types sold the least amount of meters using =MIN()

Using the pivot table that you just created, determine which of the color types sold the largest amount of meters using =MAX()

If Saeko wants to expand the colors in both the best selling and the worst selling color type, which two color types should she buy?

Please show excel steps

Pivot Table Data

Customer	Color Name	Color Type	Yards	Meters
1	Coriander	White	219	200.3
2	Lynx	Brown	243	222.2
3	Daffodil	Yellow	439	401.4
4	Periwinkle	Purple	181	165.5
5	Opal	Blue	260	237.7
6	Toffee	Brown	184	168.2
7	Ruby	Red	415	379.5
8	Ash	Blue	407	372.2
9	Ash	Blue	236	215.8
10	Ash	Blue	185	169.2
11	Whirlpool	Blue	219	200.3
12	Whirlpool	Blue	303	277.1
13	Verde	Green	220	201.2
14	Regal	Purple	246	224.9
15	Lynx	Brown	289	264.3
16	Toffee	Brown	297	271.6
17	Chocolate	Brown	249	227.7
18	Mist	White	176	160.9
19	Whirlpool	Blue	100	91.4
20	Alfalfa	Green	403	368.5
21	Ruby	Red	361	330.1
22	Verde	Green	373	341.1
23	Sky	White	303	277.1
24	Chocolate	Brown	396	362.1
25	Whirlpool	Blue	321	293.5
26	Black	Black	324	296.3
27	Mist	White	160	146.3
28	Alfalfa	Green	187	171.0
29	Jade	Green	102	93.3
30	Opal	Blue	157	143.6
31	Cream	White	193	176.5
32	Chocolate	Brown	104	95.1
33	Ruby	Red	303	277.1
34	Mist	White	438	400.5
35	Regal	Purple	276	252.4
36	Jade	Green	335	306.3
37	Sky	White	284	259.7
38	Periwinkle	Purple	261	238.7
39	Coriander	White	445	406.9
40	Black	Black	357	326.4
41	Ash	Blue	261	238.7
42	Chocolate	Brown	242	221.3
43	Periwinkle	Purple	321	293.5
44	Black	Black	155	141.7
45	Blush	Red	146	133.5
46	Lynx	Brown	312	285.3
47	Mist	White	324	296.3
48	Coriander	White	249	227.7
49	Cream	White	356	325.5
50	Verde	Green	427	390.4
51	Chocolate	Brown	139	127.1
52	Daffodil	Yellow	382	349.3
53	Chocolate	Brown	337	308.2
54	Daffodil	Yellow	201	183.8
55	Regal	Purple	226	206.7
56	Sapphire	Blue	211	192.9
57	Coriander	White	224	204.8
58	Black	Black	398	363.9
59	Lynx	Brown	325	297.2
60	Lynx	Brown	330	301.8
61	Periwinkle	Purple	419	383.1
62	Chocolate	Brown	344	314.6
63	Coriander	White	153	139.9
64	Verde	Green	328	299.9
65	Lynx	Brown	110	100.6
66	Alfalfa	Green	433	395.9
67	Cream	White	190	173.7
68	Daffodil	Yellow	176	160.9
69	Periwinkle	Purple	320	292.6
70	Cream	White	210	192.0
71	Toffee	Brown	230	210.3
72	Opal	Blue	261	238.7
73	Cream	White	421	385.0
74	Cream	White	143	130.8
75	Coriander	White	199	182.0
76	Mist	White	413	377.6
77	Verde	Green	142	129.8
78	Toffee	Brown	183	167.3
79	Blush	Red	199	182.0
80	Opal	Blue	199	182.0
81	Daffodil	Yellow	375	342.9
82	Mist	White	195	178.3
83	Alfalfa	Green	280	256.0
84	Jade	Green	274	250.5
85	Ruby	Red	133	121.6
86	Verde	Green	137	125.3
87	Cream	White	242	221.3
88	Lynx	Brown	344	314.6
89	Chocolate	Brown	293	267.9
90	Regal	Purple	124	113.4
91	Sky	White	214	195.7
92	Regal	Purple	377	344.7
93	Opal	Blue	173	158.2
94	Lynx	Brown	411	375.8
95	Regal	Purple	151	138.1
96	Ash	Blue	367	335.6
97	Periwinkle	Purple	411	375.8
98	Black	Black	338	309.1
99	Black	Black	183	167.3
100	Blush	Red	427	390.4
101	Regal	Purple	433	395.9
102	Sapphire	Blue	328	299.9
103	Whirlpool	Blue	172	157.3
104	Chocolate	Brown	102	93.3
105	Whirlpool	Blue	258	235.9
106	Sapphire	Blue	450	411.5
107	Chocolate	Brown	407	372.2
108	Toffee	Brown	240	219.5
109	Sapphire	Blue	305	278.9
110	Whirlpool	Blue	100	91.4
111	Black	Black	283	258.8
112	Regal	Purple	156	142.6
113	Opal	Blue	134	122.5
114	Blush	Red	301	275.2
115	Coriander	White	430	393.2
116	Whirlpool	Blue	215	196.6
117	Ash	Blue	353	322.8
118	Blush	Red	316	289.0
119	Black	Black	370	338.3
120	Ruby	Red	441	403.3
121	Mist	White	134	122.5
122	Chocolate	Brown	296	270.7
123	Opal	Blue	182	166.4
124	Toffee	Brown	395	361.2
125	Ash	Brown	339	310.0

Answer 1

i am providing you the data in and how to use it step by step to find out all your answers

by clicking on any cell value of sheet 1 you can go into the "insert" and select pivot table .your data converted in to the pivot table on the new sheet.

ans.1: the pivot table shows you the total number of sales with reference to each type of color and yards and meters. on the sheet no 4 of the pivot table

Ans 2: sheet5 provides you which color type has the minimum sale and which color type has the maximum sale .

ans 3: two worst selling colors are 1) Ash 2) Jade

Two best selling color are 1) chocolate 2) Black

	Values
Row Labels	Sum of Customer	Sum of Yards	Sum of Meters
Black	595	2408	2201.8
Black	595	2408	2201.8
Blue	1671	6157	5630.1
Ash	281	1809	1654.3
Opal	516	1366	1249.1
Sapphire	373	1294	1183.2
Whirlpool	501	1688	1543.5
Brown	1660	7141	6530.1
Ash	125	339	310
Chocolate	703	2909	2660.2
Lynx	429	2364	2161.8
Toffee	403	1529	1398.1
Green	658	3641	3329.2
Alfalfa	197	1303	1191.4
Jade	149	711	650.1
Verde	312	1627	1487.7
Purple	906	3902	3567.9
Periwinkle	312	1913	1749.2
Regal	594	1989	1818.7
Red	722	3042	2781.7
Blush	456	1389	1270.1
Ruby	266	1653	1511.6
White	1405	6315	5774.5
Coriander	398	1919	1754.8
Cream	451	1755	1604.8
Mist	405	1840	1682.4
Sky	151	801	732.5
Yellow	258	1573	1438.3
Daffodil	258	1573	1438.3
Grand Total	7875	34179	31253.6

next table

color type	yards	meter
	Values
Row Labels	Sum of Yards	Sum of Meters
Black	2408	2201.8
Blue	6157	5630.1
Brown	7141	6530.1
Green	3641	3329.2
Purple	3902	3567.9
Red	3042	2781.7
White	6315	5774.5
Yellow	1573	1438.3
Grand Total	34179	31253.6
	min	min
Yellow	1573	1438.3
	max	max
Brown	7141	6530.1