Answered step by step
Verified Expert Solution
Question
1 Approved Answer
Please help Bicycles Inventory Data Table in the attached file. Create a search function with the following feature 1. Reads a product name as input
Please help
Bicycles Inventory Data Table in the attached file. Create a search function with the following feature
1. Reads a product name as input from a designated cell and displays its Selling Price and Quantity on Hand.
A Monthly Product Sales Data Table above. Create a search function with the following feature
2. Reads a product name and a month as inputs from the designated cells and displays Sales Quantity corresponding to the product and the month.
Answer must be an Excel file and show me the function used.
Bicycle Inventory Data Table Product Category Product Name Leisure Blue Moon Mtn. Bluff Breaker Leisure Breeze Leisure Breeze LE Road Classic 109 Children Coolest 100 Mtn. Eagle 1 Mtn. Eagle 2 Mtn. Eagle 3 Hybrid Eagle 7 Road Elegant 210 Children Green Rider Mtn. Jetty Breaker Children Red Rider Hybrid Runblend 2000 Leisure Runcool 3000 Children Runkidder 100 Road Runroad 1000 Road Runroad 4000 Road Runroad 5000 Leisure Starlight Leisure Supreme 350 Hybrid Tea for Two Road Twist & Shout Purchase Cost $75.29 $375.00 $89.95 $109.95 $207.49 $69.99 $410.01 $401.11 $350.52 $150.89 $281.52 $95.47 $455.95 $15.00 $180.95 $85.95 $50.95 $250.95 $390.95 $450.95 $100.47 $50.00 $429.02 $490.50 Selling Price Supplier Quantity on Hand $105.41 Simpson's Bike Supply $495.00 The Bike Path $130.95 The Bike Path $149.95 The Bike Path $290.49 Bicyclist's Choice $97.98 Bicyclist's Choice $574.01 Bike-One $561.54 Bike-One $490.73 Bike-One $211.46 Bike-One $394.13 Bicyclist's Choice $133.66 Simpson's Bike Supply $649.95 The Bike Path $25.50 Simpson's Bike Supply $255.99 Run-Up Bikes $135.99 Run-Up Bikes $75.99 Run-Up Bikes $350.99 Run-Up Bikes $495.99 Run-Up Bikes $599.99 Run-Up Bikes $140.66 Simpson's Bike Supply $70.00 Bicyclist's Choice $609.00 Simpson's Bike Supply $635.70 Simpson's Bike Supply UOAVON Monthly Product Sales Data Table Month January February March April May June July August September October November December Data + 7792 7268 7049 7560 8233 8629 8702 9215 8986 8654 8315 7978 5554 3024 5543 5232 5450 3943 5991 3920 4753 4746 3566 5670 3105 3228 2147 2636 2726 2705 2891 2782 2524 3258 2144 3071 3168 3751 3319 4057 3837 4664 5418 4085 5575 5333 4924 6563 10350 8965 6827 8544 7535 9070 8389 7367 5377 7645 8173 6088 Bicycle Inventory Data Table Product Category Product Name Leisure Blue Moon Mtn. Bluff Breaker Leisure Breeze Leisure Breeze LE Road Classic 109 Children Coolest 100 Mtn. Eagle 1 Mtn. Eagle 2 Mtn. Eagle 3 Hybrid Eagle 7 Road Elegant 210 Children Green Rider Mtn. Jetty Breaker Children Red Rider Hybrid Runblend 2000 Leisure Runcool 3000 Children Runkidder 100 Road Runroad 1000 Road Runroad 4000 Road Runroad 5000 Leisure Starlight Leisure Supreme 350 Hybrid Tea for Two Road Twist & Shout Purchase Cost $75.29 $375.00 $89.95 $109.95 $207.49 $69.99 $410.01 $401.11 $350.52 $150.89 $281.52 $95.47 $455.95 $15.00 $180.95 $85.95 $50.95 $250.95 $390.95 $450.95 $100.47 $50.00 $429.02 $490.50 Selling Price Supplier Quantity on Hand $105.41 Simpson's Bike Supply $495.00 The Bike Path $130.95 The Bike Path $149.95 The Bike Path $290.49 Bicyclist's Choice $97.98 Bicyclist's Choice $574.01 Bike-One $561.54 Bike-One $490.73 Bike-One $211.46 Bike-One $394.13 Bicyclist's Choice $133.66 Simpson's Bike Supply $649.95 The Bike Path $25.50 Simpson's Bike Supply $255.99 Run-Up Bikes $135.99 Run-Up Bikes $75.99 Run-Up Bikes $350.99 Run-Up Bikes $495.99 Run-Up Bikes $599.99 Run-Up Bikes $140.66 Simpson's Bike Supply $70.00 Bicyclist's Choice $609.00 Simpson's Bike Supply $635.70 Simpson's Bike Supply UOAVON Monthly Product Sales Data Table Month January February March April May June July August September October November December Data + 7792 7268 7049 7560 8233 8629 8702 9215 8986 8654 8315 7978 5554 3024 5543 5232 5450 3943 5991 3920 4753 4746 3566 5670 3105 3228 2147 2636 2726 2705 2891 2782 2524 3258 2144 3071 3168 3751 3319 4057 3837 4664 5418 4085 5575 5333 4924 6563 10350 8965 6827 8544 7535 9070 8389 7367 5377 7645 8173 6088Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started