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 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
Get step-by-step solutions from verified subject matter experts
