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

Answer 1

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

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

Ans: 1: the above table shows you the adata