excel

Makrup 10% 15% 15 pts Make F2 a drop down list that shows the different markups from column H. (10 pts) Write a formula that would calucalte the new price with the selected markup in column F. Number of items with zero inventory Product with the max inventory Number of items with more than 50 units on order Product ID: Product Name: Price (before markup): Value of Inventory ($): Value of Order($): 15 pts Show the number of products with zero inventory in HG. (15 pts) Display the name of the product with Max inventory in H7 15 pts) Display the number of items that have a an order of more than 50 units, in HS 15 pts Create a drop down list in H11 that shows all the Product IDs. (20 pts/The values in the yellow box (H13:H16) should get populated automatically when a new Product ID is selected (NOTE: Value of inventory and order is calculated based on price) 15 pts) if the item is out of stock then display a messge that says "ORDER NOW!" in H18 (20 pts] Dispaly a message similar to the following in H2O for any prodcut selected: B D D E F G H 1 K L L M N 0 Units In Stock 39 Units On Order 0 Makrup 10% 15% 15 pts Make F2 a drop down list that shows the different markups from column H. 17 40 70 0 (10 pts) Write a formula that would calucalte the new price with the selected markup in column F. 0 29 31 22 24 Number of items with zero inventory Product with the max inventory Number of items with more than 50 units on order 30 0 0 35 39 0 Product ID 29 0 42 0 0 0 Product Name: Price (before markup) Value of Inventory ($): Value of Order($): 15 pts Show the number of products with zero inventory in H6. (15 pts) Display the name of the product with Max inventory in H7 15 pts) Display the number of items that have a an order of more than 50 units, in HS 15 pts Create a drop down list in H11 that shows all the Product IDs (20 ptsThe values in the yellow box (H13:H16) should get populated automatically when a new Product ID is selected (NOTE: Value of inventory and order is calculated based on price) 15 pts if the item is out of stock then display a messge that says "ORDER NOW!" in H18 (20 pts) Dispaly a message similar to the following in H20 for any prodcut selected: 40 0 104 61 20 49 26 0 10 0 9 0 0 0 0 0 0 0 0 70 40 0 0 0 0 50 0 1 2 ID Product Name 31 Chai 4 2 Chang 5 5 3 Aniseed Syrup 6 9 Mishi Kobe Niku 710 kura 8 11 Queso Cabrales 9 13 konbu 10 14 Tofu 11 15 Genen Shouyu 12 16 Pavlova 13 17 Alice Mutton 14 18 Carnarvon Tigers 15 21 Sir Rodney's Scones 16 22 Gustaf's knckebrd 17 23 Tunnbrd 18 24 Guarana Fantastica 19 27 Schoggi Schokolade 20 28 Rssle Sauerkraut 21 29 Thringer Rostbratwurst 22 30 Nord-Ost Matjeshering 23 31 Gorgonzola Telino 24 32 Mascarpone Fabioli 25 33 Geitost 26 34 Sasquatch Ale 27 35 Steelerye Stout 28 36 Inlagd Sim 29 37 Gravad lax 30 38 Cte de Blaye 31 39 Chartreuse verte 32 40 Boston Crab Meat 33 41 Jack's New England Clam Chowder 34 42 Singaporean Hokkien Fried Mee 35 43 Ipoh Coffee 36 44 Gula Malacca 37 45 Rogede sild 38 46 Spegesild 39 47 Zaanse koeken 40 48 Chocolade 41 49 Maxilaku 42 50 Valkoinen suklaa 43 51 Manjimup Dried Apples 44 52 Filo Mix 45 53 Perth Pasties 46 54 Tourtire 47 55 Pat chinois 48 56 Gnocchi di nonna Alice 49 57 Ravioli Angelo 50 58 Escargots de Bourgogne 51 59 Raclette Courdavault 52 60 Camembert Pierrot 53 61 Sirop d'rable 54 62 Tarte au sucre 55 63 Vegie-spread 56 64 Wimmers gute Semmelkndel 57 65 Louisiana Fiery Hot Pepper Sauce 58 66 Louisiana Hot Spiced Okra 59 67 Laughing Lumberjack Lager 60 68 Scottish Longbreads 61 69 Gudbrandsdalsost 62 70 Outback Lager 63 71 Floterysost 64 72 Mozzarella di Giovanni 65 73 Rd Kaviar 66 74 Longlife Tofu 67 75 Rhnbru Klosterbier 68 76 Lakkalikri 69 77 Original Frankfurter grne Soe Price $ 15.30 $ 16.15 $ 8.50 $ 82.45 $ 26.35 $ 17.85 $ 5.10 $ 19.76 $ $ 13.18 $ 14.83 $ $ 33.15 $ 53.13 $ $ 8.50 $ 17.85 $ 7.65 $ 3.83 $ $ 37.32 $ 38.76 $ 105.22 $ 22.01 $ 10.63 $ 27.20 $ 2.13 $ 11.90 $ 15.30 $ 16.15 $ 22.10 $ 223.98 $ 15.30 $ 15.64 $ 8.20 $ 11.90 $ 39.10 $ 16.53 $ $ 8.08 $ 10.20 $ 8.08 $ 10.84 $ $ 17.00 $ 13.81 $ 45.05 $ 5.95 $ $ 27.88 $ 6.33 $ 20.40 $ $ 32.30 $ 16.58 $ 11.26 $ 46.75 $ 28.90 $ 24.23 $ 41.91 $ 37.32 $ 28.26 $ 17.89 $ 14.45 $ 11.90 $ 10.63 $ 30.60 $ 12.75 $ 18.28 $ 29.58 $ 12.75 $ 8.50 $ 6.59 $ 15.30 $ 11.05 112 111 20 112 11 17 69 123 85 26 17 27 5 95 36 15 10 65 20 38 0 0 0 0 0 10 0 70 0 0 70 60 0 0 0 0 0 0 10 0 0 0 21 115 21 36 62 79 19 113 17 24 22 76 0 0 0 0 80 0 52 100 0 10 0 6 26 15 26 14 101 4 125 57 32 10 0 0 0 20 0 0 o Makrup 10% 15% 15 pts Make F2 a drop down list that shows the different markups from column H. (10 pts) Write a formula that would calucalte the new price with the selected markup in column F. Number of items with zero inventory Product with the max inventory Number of items with more than 50 units on order Product ID: Product Name: Price (before markup): Value of Inventory ($): Value of Order($): 15 pts Show the number of products with zero inventory in HG. (15 pts) Display the name of the product with Max inventory in H7 15 pts) Display the number of items that have a an order of more than 50 units, in HS 15 pts Create a drop down list in H11 that shows all the Product IDs. (20 pts/The values in the yellow box (H13:H16) should get populated automatically when a new Product ID is selected (NOTE: Value of inventory and order is calculated based on price) 15 pts) if the item is out of stock then display a messge that says "ORDER NOW!" in H18 (20 pts] Dispaly a message similar to the following in H2O for any prodcut selected: B D D E F G H 1 K L L M N 0 Units In Stock 39 Units On Order 0 Makrup 10% 15% 15 pts Make F2 a drop down list that shows the different markups from column H. 17 40 70 0 (10 pts) Write a formula that would calucalte the new price with the selected markup in column F. 0 29 31 22 24 Number of items with zero inventory Product with the max inventory Number of items with more than 50 units on order 30 0 0 35 39 0 Product ID 29 0 42 0 0 0 Product Name: Price (before markup) Value of Inventory ($): Value of Order($): 15 pts Show the number of products with zero inventory in H6. (15 pts) Display the name of the product with Max inventory in H7 15 pts) Display the number of items that have a an order of more than 50 units, in HS 15 pts Create a drop down list in H11 that shows all the Product IDs (20 ptsThe values in the yellow box (H13:H16) should get populated automatically when a new Product ID is selected (NOTE: Value of inventory and order is calculated based on price) 15 pts if the item is out of stock then display a messge that says "ORDER NOW!" in H18 (20 pts) Dispaly a message similar to the following in H20 for any prodcut selected: 40 0 104 61 20 49 26 0 10 0 9 0 0 0 0 0 0 0 0 70 40 0 0 0 0 50 0 1 2 ID Product Name 31 Chai 4 2 Chang 5 5 3 Aniseed Syrup 6 9 Mishi Kobe Niku 710 kura 8 11 Queso Cabrales 9 13 konbu 10 14 Tofu 11 15 Genen Shouyu 12 16 Pavlova 13 17 Alice Mutton 14 18 Carnarvon Tigers 15 21 Sir Rodney's Scones 16 22 Gustaf's knckebrd 17 23 Tunnbrd 18 24 Guarana Fantastica 19 27 Schoggi Schokolade 20 28 Rssle Sauerkraut 21 29 Thringer Rostbratwurst 22 30 Nord-Ost Matjeshering 23 31 Gorgonzola Telino 24 32 Mascarpone Fabioli 25 33 Geitost 26 34 Sasquatch Ale 27 35 Steelerye Stout 28 36 Inlagd Sim 29 37 Gravad lax 30 38 Cte de Blaye 31 39 Chartreuse verte 32 40 Boston Crab Meat 33 41 Jack's New England Clam Chowder 34 42 Singaporean Hokkien Fried Mee 35 43 Ipoh Coffee 36 44 Gula Malacca 37 45 Rogede sild 38 46 Spegesild 39 47 Zaanse koeken 40 48 Chocolade 41 49 Maxilaku 42 50 Valkoinen suklaa 43 51 Manjimup Dried Apples 44 52 Filo Mix 45 53 Perth Pasties 46 54 Tourtire 47 55 Pat chinois 48 56 Gnocchi di nonna Alice 49 57 Ravioli Angelo 50 58 Escargots de Bourgogne 51 59 Raclette Courdavault 52 60 Camembert Pierrot 53 61 Sirop d'rable 54 62 Tarte au sucre 55 63 Vegie-spread 56 64 Wimmers gute Semmelkndel 57 65 Louisiana Fiery Hot Pepper Sauce 58 66 Louisiana Hot Spiced Okra 59 67 Laughing Lumberjack Lager 60 68 Scottish Longbreads 61 69 Gudbrandsdalsost 62 70 Outback Lager 63 71 Floterysost 64 72 Mozzarella di Giovanni 65 73 Rd Kaviar 66 74 Longlife Tofu 67 75 Rhnbru Klosterbier 68 76 Lakkalikri 69 77 Original Frankfurter grne Soe Price $ 15.30 $ 16.15 $ 8.50 $ 82.45 $ 26.35 $ 17.85 $ 5.10 $ 19.76 $ $ 13.18 $ 14.83 $ $ 33.15 $ 53.13 $ $ 8.50 $ 17.85 $ 7.65 $ 3.83 $ $ 37.32 $ 38.76 $ 105.22 $ 22.01 $ 10.63 $ 27.20 $ 2.13 $ 11.90 $ 15.30 $ 16.15 $ 22.10 $ 223.98 $ 15.30 $ 15.64 $ 8.20 $ 11.90 $ 39.10 $ 16.53 $ $ 8.08 $ 10.20 $ 8.08 $ 10.84 $ $ 17.00 $ 13.81 $ 45.05 $ 5.95 $ $ 27.88 $ 6.33 $ 20.40 $ $ 32.30 $ 16.58 $ 11.26 $ 46.75 $ 28.90 $ 24.23 $ 41.91 $ 37.32 $ 28.26 $ 17.89 $ 14.45 $ 11.90 $ 10.63 $ 30.60 $ 12.75 $ 18.28 $ 29.58 $ 12.75 $ 8.50 $ 6.59 $ 15.30 $ 11.05 112 111 20 112 11 17 69 123 85 26 17 27 5 95 36 15 10 65 20 38 0 0 0 0 0 10 0 70 0 0 70 60 0 0 0 0 0 0 10 0 0 0 21 115 21 36 62 79 19 113 17 24 22 76 0 0 0 0 80 0 52 100 0 10 0 6 26 15 26 14 101 4 125 57 32 10 0 0 0 20 0 0 o