Answered step by step
Verified Expert Solution
Link Copied!

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

image text in transcribed

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 6088

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Blockchain Technology In Accounting And Auditing

Authors: Prof Oleksandr Melnychenko

1st Edition

1976900328, 978-1976900327

More Books

Students also viewed these Accounting questions

Question

Identify the cause of a performance problem. page 363

Answered: 1 week ago