Question: Problem 5.3 Data Validation In the Part3 worksheet you are to develop a worksheet for customers to complete an order for fruit from your farm.

 Problem 5.3 Data Validation In the Part3 worksheet you are todevelop a worksheet for customers to complete an order for fruit from

Problem 5.3 Data Validation In the Part3 worksheet you are to develop a worksheet for customers to complete an order for fruit from your farm. Step 1: In column A, the user should choose from a drop-down list of the 5 fruits you sell. (5 points) i) Apples, Oranges, Grapes, Berries, and Bananas Step 2: In column B, the user should type the number of pounds they would like to order. You only sell up to 10 pounds of any one fruit to any one customer. You do not sell partial pounds. You must include input and error messages such that the user knows what to enter in the column. (5 points) Step 3: Column C should automatically populate with the price of that item. Assume each type of fruit sell for $5 a pound. (5 points) Problem 5.3 Data Validation In the Part3 worksheet you are to develop a worksheet for customers to complete an order for fruit from your farm. Step 1: In column A, the user should choose from a drop-down list of the 5 fruits you sell. (5 points) i) Apples, Oranges, Grapes, Berries, and Bananas Step 2: In column B, the user should type the number of pounds they would like to order. You only sell up to 10 pounds of any one fruit to any one customer. You do not sell partial pounds. You must include input and error messages such that the user knows what to enter in the column. (5 points) Step 3: Column C should automatically populate with the price of that item. Assume each type of fruit sell for $5 a pound. (5 points)

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Finance Questions!