Bus308: Excel Macro Assignment

1. Create a macro to find the sum of the selling quantity of bikes of category road or hybrid with a cost greater than $100. Create a button to run this macro in the results sheet

2. Create a macro to find the average quantity of bikes of category Hybrid OR another category entered by the user (the user needs to enter the second category when the macro runs)

3. Create a macro to display the number of bikes of type road and cost greater than a value entered by the user (Create a button for this macro)

A B D E F G H Bicycle Inventory NP 3 ID Product Category Product Name Purchase Cost Selling Price Supplier Quantity on Hand 1 Leisure Blue Moon $75.29 $ 105.41 Simpson's Bike Supply 2 Min. Bluff Breaker $375.00 $495.00 The Bike Path 3 Leisure Breeze $89.95 $130.95 The Bike Path 4 Leisure Breeze LE $109.95 $149.95 The Bike Path 00 5 Road Classic 109 $207.49 $290.49 Bicyclist's Choice 6 Children Coolest 100 $69.99 $97.98 Bicyclist's Choice YOU N- O VOA WA 10 7 Mtn. Eagle 1 $410.01 $574.01 Bike-One 11 8 Mtn. Eagle 2 $401.11 $561.54 Bike-One 12 9 Min. Eagle 3 $350.52 $490.73 Bike-One 13 10 Hybrid Eagle 7 $150.89 $211.46 Bike-One 14 11 Road Elegant 210 $281.52 $394.13 Bicyclist's Choice 15 12 Children Green Rider $95.47 $133.66 Simpson's Bike Supply 16 13 Mtn. Jetty Breaker $455.95 $649.95 The Bike Path 17 14 Children Red Rider $15.00 $25.50 Simpson's Bike Supply 18 15 Hybrid Runblend 2000 $180.95 $255.99 Run-Up Bikes 19 16 Leisure Runcool 3000 $85.95 $135.99 Run-Up Bikes 20 17 Children Runkidder 100 $50.95 $75.99 Run-Up Bikes 21 18 Road Runroad 1000 $250.95 $350.99 Run-Up Bikes 22 19 Road Runroad 4000 $390.95 $495.99 Run-Up Bikes 23 20 Road Runroad 5000 $450.95 $599.99 Run-Up Bikes Starlight +10n 17 tun GG Cimnear Sunnly Data Results + Ready { Accessibility: Good to go MAR 3,349 18 O zoom 4B C D E G H 18 15 Hybrid Runblend 2000 $180.95 $255.99 Run-Up Bikes 19 16 Leisure Runcool 3000 $85.95 $135.99 Run-Up Bikes 20 17 Children Runkidder 100 $50.95 $75.99 Run-Up Bikes 21 18 Road Runroad 1000 $250.95 $350.99 Run-Up Bikes 22 19 Road Runroad 4000 $390.95 $495.99 Run-Up Bikes 23 20 Road Runroad 5000 $450.95 $599.99 Run-Up Bikes 24 21 Leisure Starlight $100.47 $140.66 Simpson's Bike Supply 25 22 Leisure Supreme 350 $50.00 $70.00 Bicyclist's Choice 26 23 Hybrid Tea for Two $429.02 $609.00 Simpson's Bike Supply 3 27 24 Road Twist & Shout $490.50 $635.70 Simpson's Bike Supply 0 28 29 30 31 32 33 42 43 Data Results + Ready Accessibility: Good to go MAR 3,349 18 E zoomQuestion 1 Question 2 C D E G H K M Create a macro to find the sum of selling quantity of bikes of category road or hybrid with a cost gretaer than $100, Create a button to run this macro in the results sheet Create a macro to find the average quantity of bikes of category Hybrid 0R another category entered bythe user (the user needs to enter the second category when the macro runs) Question 3 Create a macro to display the number of bikes of type road and cost greater than a value entered by the user (Create a button for this macro)