Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Go to the sheet called v&if. In cell B9, use the Vlookup function to determine the Unit Price. In cell B1, type in Shrimp and

Go to the sheet called v&if. In cell B9, use the Vlookup function to determine the Unit Price. In cell B1, type in Shrimp and check to make sure that your worksheet is working properly. Type in the other table entries, making sure that the correct price displays for each one. . Your next task is to determine the amount of sales tax, if any, that a user would pay. Cell B3 is the cell where the user indicates whether 1 (an individual does not have to pay sales tax) or (an individual must pay sales tax). The only way that no sales tax is to be paid is if the user enters in a "1". If any other number (other than a 1) is entered into cell B3, then sales tax must be paid. What you are doing is planning for the user making an error in a business application where sales tax is being determined, it will be very costly to YOU if the appropriate amount of tax is not collected since you will have to make-up the difference. Therefore, your application should only NOT calculate sales tax if a 1 is entered. ALL OTHER NUMBER

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

Joe Celkos Data And Databases Concepts In Practice

Authors: Joe Celko

1st Edition

1558604324, 978-1558604322

More Books

Students also viewed these Databases questions

Question

Why would a supplier require a customer to sign a promissory note?

Answered: 1 week ago

Question

Ability to work comfortably in a team environment

Answered: 1 week ago

Question

Exposure to SQL desirable but not required

Answered: 1 week ago