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 61 $274.50 $16,744.50 Hint: add multiple rows... 44 Central Gill Pencil 48 $0.79 $37.92 Place your answer below Place your PivotTable below in cell L44 45 West Sorvino Pen 69 $1.49 $102.81 46 West Thompson Binder 75 $19.49 $1,461.75 Who sold the least in the West 47 Central Andrews Pencil 73 $0.79 $57.67 Region? 48 Central Jardine Binder 29 $4.49 $130.21 Place your answer below 49 Central Jardine Binder 9 $19.49 $175.41 50 Central Andrews Binder 16 $4.49 $71.84 51 East Jones Penci 95 $1.99 $189.05 52 Central Kivell Binder 50 $19.99 $999.50 53 Central Jardine Penci 36 $4.99 $179.64 54 Central Gill Pen 27 $19.99 $539.73 55 West Sorvino Penci 56 $2.99 $167.44 56 East Jones Binder 60 $4.99 $299.40 57 Central Andrews Pencil 75 $1.99 $149.25 58 Central Jardine Penci 90 $4.99 $449.10 59 West Thompson Penci 32 $1.99 $63.68 60 East Jones Binde 60 $8.99 $539.40 61 Central Morgan Penci 90 $4.99 $449.10 62 East Howard Binder 29 $1.99 $57.71 63 East Parent Binder 81 $19.99 $1,619.19 64 East Jones Penci 35 $4.99 $174.65 65 Central Smith Desk 2 $125.00 $250.00 66 East ones Pen Set 16 $15.99 $255.84 67 Central Morgan Binder 28 $8.99 $251.72 68 East Jones Pen 64 $8.99 $575.36 69 East Parent Pen 15 $19.99 $299.85 70 Central Kivel Pen Set 96 $4.99 $479.04 71 Central Smith Pencil 67 $1.29 $86.43 4) Which item had the most units sold? 72 East Parent Pen Set 74 $15.99 $1,183.26 Place your answer below Place your PivotTable below in cell L72 73 Central Gill Binder 46 $8.99 $413.54 74 Central Smith Binder 87 $15.00 $1,305.00 How many desks were sold? 75 East Jones Binder 4 $4.99 $19.96 Place your answer below 76 West Sorvino Binder 7 $19.99 $139.93 77 Central Jardine Pen Set 50 $4.99 $249.50 78 Central Andrews Pencil 66 $1.99 $131.34 79 East Howard Pen 96 $4.99 $479.04 80 Central Gill Pencil 53 $1.29 1$68.37 81 Central Gill Binder 80 $8.99 $719.20 82 Central Kivell Desk 5 $125.00 $625.00 83 East Jones Pen Set 62 $4.99 $309.38 In......East Jones Pen Set 62 $4.99 $309.38 Central Morgan Pen Set 55 $12.49 $686.95 Central Kivell Pen Set 42 $23.95 $1,005.90 West Sorvino Desk 3 $275.00 $825.00 Central Gill Pencil $1.29 $9.03 West Sorvino Pen 76 $1.99 $151.24 West Thompson Binder 57 $19.99 $1,139.43 Central Andrews Pencil 14 $1.29 $18.06 Central Jardine Binder 11 $4.99 $54.89 5) What is the average unit cost of a desk? Central Jardine Binder 94 $19.99 $1,879.06 Place your answer below Place your PivotTable below in cell L9 Central Andrews Binder 28 $4.99 $139.72 Which item has the lowest average unit cost? Place your answer belowFor your assignment, you must answer each of the following questions 1) Which Region had the largest total sales? using a PivotTable. Add five pivot tables using the data found below and place each pivot table in the dotted cell next to the answer box. You will Place your answer below Place your PivotTable below in cell L4 be graded on both the PivotTable and your answer to the question. Region Sales Rep Item Units Unit Cost Total East Howard Penci 100 $1.49 $149.00 Central Jones Binder 76 $19.49 $1,481.24 10 West Jardine Pencil 25 $4.49 $112.25 11 Central Gill Pen 30 $19.49 $584.70 12 East Sorvino Pencil 123 $2.49 $306.27 13 East Jones Binder 69 $4.49 $309.81 14 Central Andrews Pencil 59 $1.49 $87.91 15 Central Jardine Pencil 16 $4.49 $71.84 16 Central Thompson Pencil 58 $1.49 $86.42 17 East Jones Binder 37 $8.49 $314.13 18 Central Morgan Pencil 76 $4.49 $341.24 19 East Howard Binder 74 $1.49 $110.26 20 West Morgan Binder 65 $19.49 $1,266.85 21 East Jones Pencil 15 $4.49 $67.35 22 East Parent Desk 58 $124.50 $7,221.00 2) Which Sales Rep had the largest Total Sales? 23 East Jones Pen Set 45 $15.49 $697.05 Place your answer below Place your PivotTable below in cell L24 24 Central Morgan Pencil 65 $8.49 $551.85 25 East Jones Pen 63 $8.49 $534.87 How much did they sell? 26 East Parent Pen 17 $19.49 $331.33 Place your answer below 27 Central Kivell Pen Set 78 $4.49 $350.22 28 Central Smith Pencil 3 $0.79 $2.37 29 Central Parent Pen Set 65 $15.49 $1,006.85 30 Central Gill Binder 57 $8.49 $483.93 31 Central Smith Binder 35 $14.50 $507.50 32 East Jones Binder 44 $4.49 $197.56 33 West Gill Binder 70 $19.49 $1,364.30 34 Central Jardine Pen Set 60 $4.49 $269.40 35 Central Andrews Pencil 12 $1.49 $17.88 36 East Howard Pen 28 $4.49 $125.72 37 Central Gill Pencil 70 $0.79 $55.30 38 Central Gill Binder 33 $8.49 $280.17 39 Central Kivell Desk 61 $124.50 $7,594.50 40 East Jones Pen Set 75 $4.49 $336.75 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 61 $274.50 $16,744.50 Hint: add multiple rows