Assignment Instructions 12 8 Format the range A13 G19 as a table with headers and then apply Table Style Medium 5. (NOTE Depending on the version of Excel installed on your system the style name may display as Dark Green, Table Style Medium 5). Filter the table on the Sport column to display only the Skiing types Display a Total Row in the table, and then sum the Quantity in Stock for Skiing items Type the result in cell B11. Remove the total row from the table and then clear the Sport filter. Lion elv 13 6 be Add Gradient Fill Orange Data Bars to the range A14 A19. Add conditional formatting to the range G14 G19 so that the cells with text that contain the word Order are formatted with Bold and Italic. Sort the table by Item #from Smallest to Largest 14 Display the Inventory Summary sheet. In cell B4 enter a formula that references cell B4 in the Seattle Inventory sheet so that the Seattle Total items in Stock displays in cell B4 In cell B5, enter a formula that references cell B5 in the Seattle Inventory sheet so that the Seattle Average Price displays in cell B5. In cells B6, B7, and B8, enter similar formulas to reference the Median Price, Lowest Price, and Highest price in the Seattle Inventory sheet. Close A13 Quantity in Stock H 1 D E 1 C Seattle Facility: Inventory Status of Apparel As of December 31, 2016 2 3 4 Total Items in Stock 271 5 Average Price $ 24.77 6 Median Price $17.45 7 Lowest Price $ 2.99 8 Highest Price $ 69.52 9 10 Sk Products 11 Ski Quantity in Stock 12 13 Quantity in Stock Item Item Name 14 32 115689 Deluxe Biking Shorts 78 114568 Vented Explorer 16 28 456897 Wicked Heavy Socks $8 465899 Gripper Gloves 18 57 46568B Airliow Hat 19 18 165332 Mini Crew Socks 20 21 22 Net Salies by State Net Sales Seattle Inventory Retail Price Categor 69.52 Pants 34.78 Hats 9.35 Socks and Gloves 25.55 Socks and Gloves 2.99 Hats 6.45 Socks and Gloves Sport Siking Hiking Skiing Skiing Hiking Fitness Scock Level ORDER OK ORDER OK OK ORDER Denver triventory Inventory Summary Sales les - O Type here to search Assignment Instructions 12 8 Format the range A13 G19 as a table with headers and then apply Table Style Medium 5. (NOTE Depending on the version of Excel installed on your system the style name may display as Dark Green, Table Style Medium 5). Filter the table on the Sport column to display only the Skiing types Display a Total Row in the table, and then sum the Quantity in Stock for Skiing items Type the result in cell B11. Remove the total row from the table and then clear the Sport filter. Lion elv 13 6 be Add Gradient Fill Orange Data Bars to the range A14 A19. Add conditional formatting to the range G14 G19 so that the cells with text that contain the word Order are formatted with Bold and Italic. Sort the table by Item #from Smallest to Largest 14 Display the Inventory Summary sheet. In cell B4 enter a formula that references cell B4 in the Seattle Inventory sheet so that the Seattle Total items in Stock displays in cell B4 In cell B5, enter a formula that references cell B5 in the Seattle Inventory sheet so that the Seattle Average Price displays in cell B5. In cells B6, B7, and B8, enter similar formulas to reference the Median Price, Lowest Price, and Highest price in the Seattle Inventory sheet. Close A13 Quantity in Stock H 1 D E 1 C Seattle Facility: Inventory Status of Apparel As of December 31, 2016 2 3 4 Total Items in Stock 271 5 Average Price $ 24.77 6 Median Price $17.45 7 Lowest Price $ 2.99 8 Highest Price $ 69.52 9 10 Sk Products 11 Ski Quantity in Stock 12 13 Quantity in Stock Item Item Name 14 32 115689 Deluxe Biking Shorts 78 114568 Vented Explorer 16 28 456897 Wicked Heavy Socks $8 465899 Gripper Gloves 18 57 46568B Airliow Hat 19 18 165332 Mini Crew Socks 20 21 22 Net Salies by State Net Sales Seattle Inventory Retail Price Categor 69.52 Pants 34.78 Hats 9.35 Socks and Gloves 25.55 Socks and Gloves 2.99 Hats 6.45 Socks and Gloves Sport Siking Hiking Skiing Skiing Hiking Fitness Scock Level ORDER OK ORDER OK OK ORDER Denver triventory Inventory Summary Sales les - O Type here to search