B D E F G J K L 1 Practice 4 2 Analyze products shipped from warehouse to store and amount sold at each store. 3 Product, warehouse, amount shipped, shipping cost, store name, amount sold at store, and sales price are given. 4 5 questions 5 6 #1: Create an Excel Table; sort by store then by amount sold (greatest first); filter for all beverages; filter for amount sold > average 7 #2: What is the minimum amound sold in this filtered table? Min Amount Sold Above Average 00 9 $4,45 10 Product WarehouseAmount ShippedShipping Cost Store 11 water bottles FameCity 209 $2,01 BreakPoint 12 gummy candy Smallville 274 $5,13 BreakPoint 13 chips FameCity 275 $3,07 BreakPoint 14 coke bottles Sodaburg 211 $4,80 BreakPoint 15 juice bottles Smallville 175 $5,01 BreakPoint 16 chocolate bars FameCity 118 $4,40 BreakPoint 17 peanuts CornerTown 162 $3,54 BreakPoint 18 peanuts Smallville 258 BuyStop 19 chips CornerTown 193 $6,89 BuyStop 20 gummy candy FameCity 238 $5,08 BuyStop 21 chocolate barscornerTown 157 $6,60 BuyStop 22 coke bottles Smallville 150 $3,29 BuyStop 23 juice bottles FameCity 196 $3,91 BuyStop 24 water bottles Sodaburg 104 $2,91 BuyStop 25 water bottles Smallville 299 $2,49 Midway 26 chips Smallville 292 $6,83 Midway 27 peanuts FameCity 169 $2,70 Midway 28 chocolate bars Smallville 112 $4,98 Midway 29 gummy candy CornerTown 127 $2,89 Midway 30 juice bottles Sodaburg 69 $6,92 Midway 31 coke bottles FameCity 59 $2,30 Midway 32 Amount SoldSales PriceRemaining Inventor Holding Cost 207 $4,20 2 $0,56 202 $9,04 72 $0,41 164 $6,87 111 $0,83 159 $9,45 52 $2,77 143 $9,43 32 $4,54 93 $8,40 25 $5,85 73 $12,88 89 $2,40 168 $10,57 90 $3,02 166 $11,42 27 $2,60 164 $11,70 74 $4,79 142 $10,77 15 $1,56 136 $6,25 14 $1,76 98 $11,50 98 $2,54 77 $4,23 27 $0,49 292 $4,66 7 $1,91 262 $10,64 20 $3,17 95 $8,54 74 $1,56 89 $7,78 23 $1,21 67 $9,80 60 $2,49 55 $10,71 14 $3,43 38 $7,50 21 $0,65 33 34 35 36 37 38 39 40 #3: Create a pivot table comparing amount shipped from each warehouse (rows1) of each product (rows2) to each store (cols1) 41 show subtotals at bottom of group; change value setting to show max of amount shipped 42 #4: Create new field "TotalShip Cost" = amount shipped * shipping cost; remove amount shipped field from pivot table 43 #5: Create clustered column pivot chart; add slicers for warehouse and store; filter to show CornerTown, Smallville, BuyStop, and Midway only