Need help working through this excel assignment. Both the instructions and assignment are attached.

 

 

Color Number
100
101
102
103
104
105
106
107
108
109
113
114
116
117
118
119
320
323
324
325
326
327
328
329
330
331
332
333
334
335
337
338
339
340 Color
White
Black
Cinnabar
Rose
Apricot
Cobalt Blue
Yellow
Turquoise
Periwinkle Blue
Sea Mist Green
Lilac
Persimmon
Sapphire
Chartreuse
Pearl Gray
Juniper
Sunflower
Plum
Shamrock
Tangerine
Scarlet
Peacock
Heather
Evergreen
Ivory
Chocolate
Lemongrass
Marigold
Paprika
Flamingo
Lapis
Poppy
Slate
Sage Introduced
1986
1986
2000
1986
1986
1986
1987
1988
1989
1991
1993
1995
1996
1997
1999
2000
2001
2002
2002
2003
2004
2005
2006
2007
2008
2008
2009
2008
2010
2012
2013
2014
2015
2015 Retired
2014
2010
2005
1998
2002
2006
2005
1995
2008
1997
1999
2001
2001 2014
2008
2010
2012
2012
2013 Color Number Item Number
104
830
104
448
104
495
104
484
104
821
104
453
104
497
104
471
104
492
104
465
101
448
101
494
101
821
101
484
101
830
101
486
101
478
101
467
101
587
101
497
101
492
101
439
101
451
101
465
101
453
101
446
117
830
117
448
117
495
117
821
117
484
117
489
117
467
117
486
117
471
117
497
117
478
117
451
117
492
117
453
117
465
117
446
331
967
331
830 Student Name Item
5 Piece Place Setting
Carafe
Covered Casserole
Pitcher Large Disc
Sugar/Cream Tray Set
Mug
Salt and Pepper Set
Bowl Large 1 qt
Individual Creamer
Luncheon Plate
Carafe
Covered Coffee Server
Sugar/Cream Tray Set
Pitcher Large Disc
5 Piece Place Setting
Sauceboat
AD Cup and Saucer
Chop Plate
Individual Casserole
Salt and Pepper Set
Individual Creamer
Spoon Rest
Rim Soup
Luncheon Plate
Mug
Tumbler
5 Piece Place Setting
Carafe
Covered Casserole
Sugar/Cream Tray Set
Pitcher Large Disc
Pyramid Candleholders
Chop Plate
Sauceboat
Bowl Large 1 qt
Salt and Pepper Set
AD Cup and Saucer
Rim Soup
Individual Creamer
Mug
Luncheon Plate
Tumbler
Baking Bowl 3 Piece Set
5 Piece Place Setting Replacement
Value
69.95
64.95
64.95
42.99
38.00
24.99
21.99
19.99
15.99
7.99
41.99
39.99
34.99
32.99
28.99
25.99
21.28
19.99
15.99
15.99
14.99
12.99
10.99
9.99
8.49
6.99
79.99
75.95
64.95
59.99
50.00
42.99
41.99
35.95
30.99
29.99
25.99
24.99
23.99
19.95
15.00
11.99
150.00
34.99 Source
Keith’s Antique Store
Replacements, Ltd.
Replacements, Ltd.
Ebay Auction
Ebay Auction
Ebay Auction
Replacements, Ltd.
Ebay Auction
Replacements, Ltd.
Downtown Antique Store
Replacements, Ltd.
Replacements, Ltd.
The Homer Laughlin China Co.
The Homer Laughlin China Co.
The Homer Laughlin China Co.
The Homer Laughlin China Co.
Ebay Auction
The Homer Laughlin China Co.
The Homer Laughlin China Co.
The Homer Laughlin China Co.
The Homer Laughlin China Co.
The Homer Laughlin China Co.
The Homer Laughlin China Co.
The Homer Laughlin China Co.
The Homer Laughlin China Co.
The Homer Laughlin China Co.
Ebay Auction
Keith’s Antique Store
Replacements, Ltd.
Replacements, Ltd.
Ebay Auction
Ebay Auction
Replacements, Ltd.
Ebay Auction
Replacements, Ltd.
Replacements, Ltd.
Replacements, Ltd.
Ebay Auction
Replacements, Ltd.
Ebay Auction
Ebay Auction
Replacements, Ltd.
Keith’s Antique Store
Ebay Auction Collectionqattachments_0482b253254fa1707bc2887ad9230edca4ca17ec.xlsx 331
331
331
331
331
331
331
331
331
331
331
331
102
102
102
102
102
102
102
102
102
102
105
105
105
105
105
105
105
105
105
105
105
329
329
329
329
329
329
329
329
329
329
329
329
329 Student Name 821
484
471
467
497
587
723
465
451
451
576
453
571
830
484
467
497
465
439
570
453
446
494
821
484
830
467
471
497
439
465
576
453
967
968
821
448
572
830
447
484
486
471
497
587
439 Sugar/Cream Tray Set
Pitcher Large Disc
Bowl Large 1 qt
Chop Plate
Salt and Pepper Set
Individual Casserole
Gusto Bowl
Luncheon Plate
Rim Soup
Rim Soup
Chowder Bowl
Mug
Canister Small
5 Piece Place Setting
Pitcher Large Disc
Chop Plate
Salt and Pepper Set
Luncheon Plate
Spoon Rest
Java Mug
Mug
Tumbler
Covered Coffee Server
Sugar/Cream Tray Set
Pitcher Large Disc
5 Piece Place Setting
Chop Plate
Bowl Large 1 qt
Salt and Pepper Set
Spoon Rest
Luncheon Plate
Chowder Bowl
Mug
Baking Bowl 3 Piece Set
Extra Large Oval Platter
Sugar/Cream Tray Set
Carafe
Canister Medium
5 Piece Place Setting
Utensil Crock
Pitcher Large Disc
Sauceboat
Bowl Large 1 qt
Salt and Pepper Set
Individual Casserole
Spoon Rest 34.99
30.00
17.99
17.99
17.00
15.00
12.00
12.00
11.00
10.99
8.99
8.49
49.99
35.99
34.99
25.00
20.00
12.50
11.99
9.99
8.49
6.99
65.00
34.99
32.99
28.99
19.99
17.99
15.99
12.99
9.99
8.99
8.49
129.95
69.99
45.99
44.99
43.99
39.99
36.99
34.99
26.99
21.99
19.99
15.99
12.99 The Homer Laughlin China Co.
Keith’s Antique Store
The Homer Laughlin China Co.
Replacements, Ltd.
Downtown Antique Store
Downtown Antique Store
Downtown Antique Store
Downtown Antique Store
Downtown Antique Store
The Homer Laughlin China Co.
Ebay Auction
The Homer Laughlin China Co.
Downtown Antique Store
Downtown Antique Store
Keith’s Antique Store
Downtown Antique Store
Downtown Antique Store
Downtown Antique Store
The Homer Laughlin China Co.
Replacements, Ltd.
The Homer Laughlin China Co.
The Homer Laughlin China Co.
Keith’s Antique Store
The Homer Laughlin China Co.
The Homer Laughlin China Co.
The Homer Laughlin China Co.
The Homer Laughlin China Co.
The Homer Laughlin China Co.
The Homer Laughlin China Co.
The Homer Laughlin China Co.
The Homer Laughlin China Co.
The Homer Laughlin China Co.
The Homer Laughlin China Co.
Replacements, Ltd.
Downtown Antique Store
Replacements, Ltd.
Ebay Auction
Replacements, Ltd.
Ebay Auction
The Homer Laughlin China Co.
Keith’s Antique Store
Ebay Auction
Replacements, Ltd.
Downtown Antique Store
The Homer Laughlin China Co.
Downtown Antique Store Collectionqattachments_0482b253254fa1707bc2887ad9230edca4ca17ec.xlsx 329
329
329
329
335
335
335
335
335
328
328
328
328
328
328
328
328
330
330
330
330
330
330
330
330
330
330
330
330
330
330
330
119
119
119
119
119
119
119
119
332
332
332
332
332
332 Student Name 570
465
453
446
572
484
830
723
570
573
830
484
497
587
465
451
453
967
968
448
447
821
484
830
471
587
497
492
723
465
453
446
830
471
484
465
478
453
497
446
573
484
830
471
587
497 Java Mug
Luncheon Plate
Mug
Tumbler
Canister Medium
Pitcher Large Disc
5 Piece Place Setting
Gusto Bowl
Java Mug
Canister Large
5 Piece Place Setting
Pitcher Large Disc
Salt and Pepper Set
Individual Casserole
Luncheon Plate
Rim Soup
Mug
Baking Bowl 3 Piece Set
Extra Large Oval Platter
Carafe
Utensil Crock
Sugar/Cream Tray Set
Pitcher Large Disc
5 Piece Place Setting
Bowl Large 1 qt
Individual Casserole
Salt and Pepper Set
Individual Creamer
Gusto Bowl
Luncheon Plate
Mug
Tumbler
5 Piece Place Setting
Bowl Large 1 qt
Pitcher Large Disc
Luncheon Plate
AD Cup and Saucer
Mug
Salt and Pepper Set
Tumbler
Canister Large
Pitcher Large Disc
5 Piece Place Setting
Bowl Large 1 qt
Individual Casserole
Salt and Pepper Set 11.99
9.99
9.50
7.99
45.99
32.99
28.99
9.99
8.49
49.99
29.99
19.99
19.99
15.00
12.99
12.50
8.49
139.99
69.99
50.00
36.99
34.99
32.99
28.99
17.99
15.99
15.99
14.99
9.99
9.99
8.49
6.99
39.99
31.99
27.00
24.99
23.99
12.00
12.00
11.99
51.99
32.99
28.99
17.99
15.99
15.99 Replacements, Ltd.
Downtown Antique Store
Downtown Antique Store
Downtown Antique Store
The Homer Laughlin China Co.
The Homer Laughlin China Co.
The Homer Laughlin China Co.
The Homer Laughlin China Co.
The Homer Laughlin China Co.
Replacements, Ltd.
Downtown Antique Store
Replacements, Ltd.
Downtown Antique Store
Downtown Antique Store
Ebay Auction
Keith’s Antique Store
Ebay Auction
The Homer Laughlin China Co.
The Homer Laughlin China Co.
Keith’s Antique Store
The Homer Laughlin China Co.
The Homer Laughlin China Co.
The Homer Laughlin China Co.
The Homer Laughlin China Co.
The Homer Laughlin China Co.
The Homer Laughlin China Co.
The Homer Laughlin China Co.
The Homer Laughlin China Co.
The Homer Laughlin China Co.
The Homer Laughlin China Co.
The Homer Laughlin China Co.
The Homer Laughlin China Co.
Ebay Auction
Replacements, Ltd.
Ebay Auction
Ebay Auction
Downtown Antique Store
Ebay Auction
Ebay Auction
Replacements, Ltd.
The Homer Laughlin China Co.
The Homer Laughlin China Co.
The Homer Laughlin China Co.
The Homer Laughlin China Co.
The Homer Laughlin China Co.
The Homer Laughlin China Co. Collectionqattachments_0482b253254fa1707bc2887ad9230edca4ca17ec.xlsx 332
332
332
113
113
113
113
113
113
113
113
113
113
113
113
113
113
333
333
333
333
333
333
333
333
333
333
333
333
333
333
333
334
334
334
334
334
334
334
334
327
327
327
327
327
327 Student Name 723
465
453
494
495
821
830
484
467
497
486
498
451
471
492
453
446
1407
489
967
968
495
484
571
447
830
439
451
465
453
570
446
489
573
572
447
830
467
465
446
967
495
572
821
484
830 Gusto Bowl
Luncheon Plate
Mug
Covered Coffee Server
Covered Casserole
Sugar/Cream Tray Set
5 Piece Place Setting
Pitcher Large Disc
Chop Plate
Salt and Pepper Set
Sauceboat
Individual Covered Sugar
Rim Soup
Bowl Large 1 qt
Individual Creamer
Mug
Tumbler
Soup Tureen
Pyramid Candleholders
Baking Bowl 3 Piece Set
Extra Large Oval Platter
Covered Casserole
Pitcher Large Disc
Canister Small
Utensil Crock
5 Piece Place Setting
Spoon Rest
Rim Soup
Luncheon Plate
Mug
Java Mug
Tumbler
Pyramid Candleholders
Canister Large
Canister Medium
Utensil Crock
5 Piece Place Setting
Chop Plate
Luncheon Plate
Tumbler
Baking Bowl 3 Piece Set
Covered Casserole
Canister Medium
Sugar/Cream Tray Set
Pitcher Large Disc
5 Piece Place Setting 9.99
9.99
8.49
249.99
249.00
189.95
159.95
129.95
114.95
94.95
89.95
79.95
79.95
74.95
49.99
47.99
33.99
350.00
249.99
195.00
74.99
65.00
40.00
39.99
36.99
29.77
12.99
11.99
9.99
9.50
8.49
6.99
150.00
51.99
45.99
36.99
28.99
19.99
9.99
6.99
139.99
49.99
45.99
34.99
32.99
28.99 The Homer Laughlin China Co.
The Homer Laughlin China Co.
The Homer Laughlin China Co.
Ebay Auction
Ebay Auction
Replacements, Ltd.
Ebay Auction
Replacements, Ltd.
Replacements, Ltd.
Replacements, Ltd.
Ebay Auction
Keith’s Antique Store
Replacements, Ltd.
Replacements, Ltd.
Keith’s Antique Store
Replacements, Ltd.
Replacements, Ltd.
Keith’s Antique Store
Ebay Auction
Ebay Auction
Downtown Antique Store
Keith’s Antique Store
Downtown Antique Store
Replacements, Ltd.
The Homer Laughlin China Co.
Ebay Auction
The Homer Laughlin China Co.
Replacements, Ltd.
The Homer Laughlin China Co.
Downtown Antique Store
The Homer Laughlin China Co.
The Homer Laughlin China Co.
Keith’s Antique Store
The Homer Laughlin China Co.
The Homer Laughlin China Co.
The Homer Laughlin China Co.
The Homer Laughlin China Co.
The Homer Laughlin China Co.
The Homer Laughlin China Co.
The Homer Laughlin China Co.
The Homer Laughlin China Co.
The Homer Laughlin China Co.
The Homer Laughlin China Co.
The Homer Laughlin China Co.
The Homer Laughlin China Co.
The Homer Laughlin China Co. Collectionqattachments_0482b253254fa1707bc2887ad9230edca4ca17ec.xlsx 327
327
327
327
327
327
327
327
118
118
118
118
118
118
118
118
118
118
118
118
108
108
108
108
108
108
108
108
108
114
114
114
114
114
114
114
114
114
114
114
114
323
323
323
323
323 Student Name 498
587
497
451
723
465
453
446
830
489
448
495
497
821
467
484
486
446
453
492
830
498
484
478
821
451
467
497
453
494
821
447
830
478
467
497
439
570
465
446
453
484
830
467
498
497 Individual Covered Sugar
Individual Casserole
Salt and Pepper Set
Rim Soup
Gusto Bowl
Luncheon Plate
Mug
Tumbler
5 Piece Place Setting
Pyramid Candleholders
Carafe
Covered Casserole
Salt and Pepper Set
Sugar/Cream Tray Set
Chop Plate
Pitcher Large Disc
Sauceboat
Tumbler
Mug
Individual Creamer
5 Piece Place Setting
Individual Covered Sugar
Pitcher Large Disc
AD Cup and Saucer
Sugar/Cream Tray Set
Rim Soup
Chop Plate
Salt and Pepper Set
Mug
Covered Coffee Server
Sugar/Cream Tray Set
Utensil Crock
5 Piece Place Setting
AD Cup and Saucer
Chop Plate
Salt and Pepper Set
Spoon Rest
Java Mug
Luncheon Plate
Tumbler
Mug
Pitcher Large Disc
5 Piece Place Setting
Chop Plate
Individual Covered Sugar
Salt and Pepper Set 18.99
15.99
15.99
10.99
9.99
9.99
8.49
6.99
73.95
69.96
65.00
59.99
50.00
41.99
27.00
26.99
25.99
15.99
12.99
10.99
64.95
59.95
28.99
26.99
22.99
22.95
19.99
12.99
8.95
65.00
39.99
35.99
33.99
17.99
17.99
15.00
12.99
9.99
9.99
9.99
8.99
32.99
28.99
19.99
18.99
15.99 The Homer Laughlin China Co.
The Homer Laughlin China Co.
The Homer Laughlin China Co.
The Homer Laughlin China Co.
The Homer Laughlin China Co.
The Homer Laughlin China Co.
The Homer Laughlin China Co.
The Homer Laughlin China Co.
Keith’s Antique Store
Ebay Auction
Keith’s Antique Store
Ebay Auction
Keith’s Antique Store
Replacements, Ltd.
Keith’s Antique Store
Ebay Auction
Keith’s Antique Store
Replacements, Ltd.
Ebay Auction
Downtown Antique Store
Downtown Antique Store
Keith’s Antique Store
Ebay Auction
Downtown Antique Store
Ebay Auction
Ebay Auction
Replacements, Ltd.
Ebay Auction
Ebay Auction
Keith’s Antique Store
Keith’s Antique Store
Replacements, Ltd.
Ebay Auction
Downtown Antique Store
Replacements, Ltd.
Ebay Auction
Downtown Antique Store
Replacements, Ltd.
Replacements, Ltd.
Ebay Auction
Downtown Antique Store
The Homer Laughlin China Co.
The Homer Laughlin China Co.
The Homer Laughlin China Co.
The Homer Laughlin China Co.
The Homer Laughlin China Co. Collectionqattachments_0482b253254fa1707bc2887ad9230edca4ca17ec.xlsx 323
323
323
323
323
323
323
103
103
103
103
103
103
103
103
103
103
103
103
103
103
103
116
116
116
116
116
326
326
326
326
326
326
326
326
326
326
326
326
326
326
326
326
326
109
109 Student Name 492
451
465
576
570
453
446
494
495
489
486
830
821
484
478
471
497
467
451
465
453
446
830
448
484
471
446
967
495
571
448
447
821
484
830
486
587
497
439
451
465
570
453
446
494
830 Individual Creamer
Rim Soup
Luncheon Plate
Chowder Bowl
Java Mug
Mug
Tumbler
Covered Coffee Server
Covered Casserole
Pyramid Candleholders
Sauceboat
5 Piece Place Setting
Sugar/Cream Tray Set
Pitcher Large Disc
AD Cup and Saucer
Bowl Large 1 qt
Salt and Pepper Set
Chop Plate
Rim Soup
Luncheon Plate
Mug
Tumbler
5 Piece Place Setting
Carafe
Pitcher Large Disc
Bowl Large 1 qt
Tumbler
Baking Bowl 3 Piece Set
Covered Casserole
Canister Small
Carafe
Utensil Crock
Sugar/Cream Tray Set
Pitcher Large Disc
5 Piece Place Setting
Sauceboat
Individual Casserole
Salt and Pepper Set
Spoon Rest
Rim Soup
Luncheon Plate
Java Mug
Mug
Tumbler
Covered Coffee Server
5 Piece Place Setting 14.99
10.99
9.99
8.99
8.49
8.49
6.99
75.00
65.00
59.99
39.99
35.00
29.99
24.99
19.99
19.99
18.00
16.95
12.50
10.00
9.99
8.99
209.95
99.95
94.95
55.99
20.00
139.99
49.99
42.99
39.99
36.99
34.99
32.99
28.99
25.99
15.99
15.99
12.99
10.99
9.99
8.49
8.49
6.99
109.95
49.99 The Homer Laughlin China Co.
The Homer Laughlin China Co.
The Homer Laughlin China Co.
The Homer Laughlin China Co.
The Homer Laughlin China Co.
The Homer Laughlin China Co.
The Homer Laughlin China Co.
Keith’s Antique Store
Downtown Antique Store
Downtown Antique Store
Ebay Auction
Ebay Auction
Ebay Auction
Ebay Auction
Ebay Auction
Downtown Antique Store
Ebay Auction
Ebay Auction
Ebay Auction
Ebay Auction
Downtown Antique Store
Ebay Auction
Keith’s Antique Store
Downtown Antique Store
Keith’s Antique Store
Keith’s Antique Store
Keith’s Antique Store
The Homer Laughlin China Co.
The Homer Laughlin China Co.
The Homer Laughlin China Co.
The Homer Laughlin China Co.
The Homer Laughlin China Co.
The Homer Laughlin China Co.
The Homer Laughlin China Co.
The Homer Laughlin China Co.
The Homer Laughlin China Co.
The Homer Laughlin China Co.
The Homer Laughlin China Co.
The Homer Laughlin China Co.
The Homer Laughlin China Co.
The Homer Laughlin China Co.
The Homer Laughlin China Co.
The Homer Laughlin China Co.
The Homer Laughlin China Co.
Replacements, Ltd.
Ebay Auction Collectionqattachments_0482b253254fa1707bc2887ad9230edca4ca17ec.xlsx 109
109
109
109
109
109
324
324
324
324
324
324
324
324
324
324
324
324
320
320
320
320
320
320
320
320
320
320
320
320
320
320
320
325
325
325
325
325
325
325
325
325
325
325
325
325 Student Name 484
497
465
446
439
453
448
484
830
471
497
439
451
723
465
576
453
446
967
821
484
830
498
471
587
497
451
723
465
576
570
453
446
489
967
968
573
821
484
830
587
497
451
723
465
453 Pitcher Large Disc
Salt and Pepper Set
Luncheon Plate
Tumbler
Spoon Rest
Mug
Carafe
Pitcher Large Disc
5 Piece Place Setting
Bowl Large 1 qt
Salt and Pepper Set
Spoon Rest
Rim Soup
Gusto Bowl
Luncheon Plate
Chowder Bowl
Mug
Tumbler
Baking Bowl 3 Piece Set
Sugar/Cream Tray Set
Pitcher Large Disc
5 Piece Place Setting
Individual Covered Sugar
Bowl Large 1 qt
Individual Casserole
Salt and Pepper Set
Rim Soup
Gusto Bowl
Luncheon Plate
Chowder Bowl
Java Mug
Mug
Tumbler
Pyramid Candleholders
Baking Bowl 3 Piece Set
Extra Large Oval Platter
Canister Large
Sugar/Cream Tray Set
Pitcher Large Disc
5 Piece Place Setting
Individual Casserole
Salt and Pepper Set
Rim Soup
Gusto Bowl
Luncheon Plate
Mug 36.99
22.99
18.99
15.99
10.00
9.99
39.99
32.99
28.99
17.99
15.99
12.99
10.99
9.99
9.99
8.99
8.49
6.99
139.99
34.99
32.99
28.99
18.99
17.99
15.99
15.99
10.99
10.00
9.99
8.99
8.49
8.49
6.99
149.99
139.99
69.99
51.99
34.99
32.99
28.99
15.99
15.99
10.99
9.99
9.99
8.49 Ebay Auction
Ebay Auction
Ebay Auction
Ebay Auction
Downtown Antique Store
Ebay Auction
The Homer Laughlin China Co.
The Homer Laughlin China Co.
The Homer Laughlin China Co.
The Homer Laughlin China Co.
The Homer Laughlin China Co.
The Homer Laughlin China Co.
The Homer Laughlin China Co.
The Homer Laughlin China Co.
The Homer Laughlin China Co.
The Homer Laughlin China Co.
The Homer Laughlin China Co.
The Homer Laughlin China Co.
The Homer Laughlin China Co.
The Homer Laughlin China Co.
The Homer Laughlin China Co.
The Homer Laughlin China Co.
The Homer Laughlin China Co.
The Homer Laughlin China Co.
The Homer Laughlin China Co.
The Homer Laughlin China Co.
The Homer Laughlin China Co.
Downtown Antique Store
The Homer Laughlin China Co.
The Homer Laughlin China Co.
The Homer Laughlin China Co.
The Homer Laughlin China Co.
The Homer Laughlin China Co.
Ebay Auction
The Homer Laughlin China Co.
The Homer Laughlin China Co.
The Homer Laughlin China Co.
The Homer Laughlin China Co.
The Homer Laughlin China Co.
The Homer Laughlin China Co.
The Homer Laughlin China Co.
The Homer Laughlin China Co.
The Homer Laughlin China Co.
The Homer Laughlin China Co.
The Homer Laughlin China Co.
The Homer Laughlin China Co. Collectionqattachments_0482b253254fa1707bc2887ad9230edca4ca17ec.xlsx 325
107
107
107
107
107
107
107
107
107
107
107
107
107
107
107
100
100
100
100
100
100
100
100
100
100
100
100
100
106
106
106
106
106
106
106 Student Name 446
494
495
821
484
830
486
478
467
497
492
439
465
576
453
446
967
495
447
821
484
830
471
587
497
439
465
576
453
830
484
821
497
492
453
446 Tumbler
Covered Coffee Server
Covered Casserole
Sugar/Cream Tray Set
Pitcher Large Disc
5 Piece Place Setting
Sauceboat
AD Cup and Saucer
Chop Plate
Salt and Pepper Set
Individual Creamer
Spoon Rest
Luncheon Plate
Chowder Bowl
Mug
Tumbler
Baking Bowl 3 Piece Set
Covered Casserole
Utensil Crock
Sugar/Cream Tray Set
Pitcher Large Disc
5 Piece Place Setting
Bowl Large 1 qt
Individual Casserole
Salt and Pepper Set
Spoon Rest
Luncheon Plate
Chowder Bowl
Mug
5 Piece Place Setting
Pitcher Large Disc
Sugar/Cream Tray Set
Salt and Pepper Set
Individual Creamer
Mug
Tumbler 6.99
55.00
49.99
34.99
32.99
28.99
25.99
19.99
19.99
15.99
14.99
12.99
9.99
8.99
8.49
6.99
139.99
49.99
36.99
34.99
32.99
28.99
17.99
15.99
15.99
12.99
9.99
8.99
8.49
33.99
29.99
26.99
19.95
16.99
9.99
6.99 The Homer Laughlin China Co.
Downtown Antique Store
The Homer Laughlin China Co.
The Homer Laughlin China Co.
The Homer Laughlin China Co.
The Homer Laughlin China Co.
The Homer Laughlin China Co.
Ebay Auction
The Homer Laughlin China Co.
The Homer Laughlin China Co.
The Homer Laughlin China Co.
The Homer Laughlin China Co.
The Homer Laughlin China Co.
The Homer Laughlin China Co.
The Homer Laughlin China Co.
The Homer Laughlin China Co.
The Homer Laughlin China Co.
The Homer Laughlin China Co.
The Homer Laughlin China Co.
The Homer Laughlin China Co.
The Homer Laughlin China Co.
The Homer Laughlin China Co.
The Homer Laughlin China Co.
The Homer Laughlin China Co.
The Homer Laughlin China Co.
The Homer Laughlin China Co.
The Homer Laughlin China Co.
The Homer Laughlin China Co.
The Homer Laughlin China Co.
Ebay Auction
Replacements, Ltd.
Ebay Auction
Ebay Auction
Ebay Auction
Ebay Auction
Replacements, Ltd. Collectionqattachments_0482b253254fa1707bc2887ad9230edca4ca17ec.xlsx

Office 2016 – myitlab:grader – Instructions Excel Project EX16_XL_CH05_GRADER_ML2_HW - Fiesta Collection 1.0
Project Description:
<Project Description>
Instructions:
For the purpose of grading the project you are required to perform the following tasks:
Step 1 2 Points
Possible Instructions
Open exploring_e05_grader_h3_Fiesta.xlsx and save it as
exploring_e05_grader_h3_Fiesta_LastFirst.xlsx. 0.000 Create a relationship between the Items table using the Color Number field and the Colors table using
the Color Number field. Create a blank PivotTable from within the Items table on the Collection
worksheet to analyze multiple tables. Add the data to the data model. Place the PivotTable on a new
worksheet and name the worksheet Retired Colors. Name the PivotTable Retired. 10.000 3 Display the names of both tables in the PivotTable Fields task pane. Display the Color field as rows and
the sum of the Replacement Value field as values. 12.000 4 Add a filter to display aggregates for retired colors only using the Retired field. Note that current colors
do not have a retirement date, so you must filter out the blanks. 12.000 5 Apply the Pivot Style Medium 7. Note, depending on the version of Office used, the style name may be
Light Green, Pivot Style Medium 7. 5.000 6 In the Retired Colors sheet, format the values with Accounting Number Format with two decimal places. 4.000 7 In cell B3, create a custom heading named Replacement Value. Change Row Labels in cell A3 to
Retired Colors. 4.000 8 9 10 11 Add a second Replacement Value field below the current field in the Values area. Select the option to
display the values as percentages of the grand total. Type the custom name Percent of Total. 10.000 Add a slicer for the Color field. Select these colors to display: Apricot, Chartreuse, Lilac, Marigold,
Pearl Gray, and Sapphire. 12.000 Apply the Slicer Style Light 6 style. Note, depending on the version of Office used, the style name may
be Light Green, Slicer Style Light 6. Display three columns within the slicer window. Change the button
width to 1.5 inches. Move the slicer so that the top-left corner starts in cell E2. 10.000 Create a clustered column PivotChart and place it on a new chart sheet named Retired
PivotChart. Updated: 12/12/2016 1 6.000 Current_Instruction.docx Office 2016 – myitlab:grader – Instructions Excel Project Points
Possible Step Instructions 12 Change the chart title to Replacement Value of Retired Items. Change the Lilac data point fill color to
Purple. Change the value axis font size to 11 and apply Black, Text 1 font color. 6.000 13 Change the category axis font size to 11 and apply Black, Text 1 font color. Hide the field buttons on the
PivotChart. 5.000 14 On all sheets, create a footer with your name on the left side, the sheet name code in the center, and the
file name code on the right side. 4.000 15 Ensure the worksheets are in the following order: Color List, Retired PivotChart, Retired Colors,
Collection. Save and close the workbook, and submit the file as directed. 0.000 Total Points Updated: 12/12/2016 2 100.000 Current_Instruction.docx

• 1493703089-Dobre_exploring_e05_grader_h3_Fiesta.xlsx
• 1493703089-EX16XLCH05GRADERML2HW_-_Fiesta_Collection_10_Instructions.docx

ComputerScienceExpert

(11)

Status NEW Posted 02 May 2017 05:05 AM My Price 11.00

-----------

Attachments

file 1493703093-Solutions file 2.docx preview (51 words )

H-----------ell-----------o S-----------ir/-----------Mad-----------am ----------- Th-----------ank----------- yo-----------u f-----------or -----------you-----------r i-----------nte-----------res-----------t a-----------nd -----------buy-----------ing----------- my----------- po-----------ste-----------d s-----------olu-----------tio-----------n. -----------Ple-----------ase----------- pi-----------ng -----------me -----------on -----------cha-----------t I----------- am----------- on-----------lin-----------e o-----------r i-----------nbo-----------x m-----------e a----------- me-----------ssa-----------ge -----------I w-----------ill----------- be----------- qu-----------ick-----------ly -----------onl-----------ine----------- an-----------d g-----------ive----------- yo-----------u e-----------xac-----------t f-----------ile----------- an-----------d t-----------he -----------sam-----------e f-----------ile----------- is----------- al-----------so -----------sen-----------t t-----------o y-----------our----------- em-----------ail----------- th-----------at -----------is -----------reg-----------ist-----------ere-----------d o-----------n -----------THI-----------S W-----------EBS-----------ITE-----------. ----------- Th-----------ank----------- yo-----------u -----------

Not Rated(0)

• Buy Answer