Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

help please asap Product/Equpitment Error Reporting Employee Name Employee ID Product or Equipment Product/Equipment # Error Notes Problem 5.3 Data Validation In the Part worksheet

help please asap
image text in transcribed
image text in transcribed
Product/Equpitment Error Reporting Employee Name Employee ID Product or Equipment Product/Equipment # Error Notes Problem 5.3 Data Validation In the Part worksheet you are report errors in products or equip life easier you are to developing correctly. Step 1: in column A, the user sho is kept in Column I which is hidde well (4 points) Step 2: in column the user sho include input and error message they select the cell and an error Step 3:Column Cemployee shoul Step 4: In columns D and Eingu columns Column E should allow Step 5: All input criteria created enter up to 10 rows of data 2 points) Problem 5.3 Data Validation In the "Part3" worksheet you are developing a data sheet for employees across departments to report errors in products or equipment. This data base can be completed by anyone to make your life easier you are to develop input criteria using "Data Validation" to be sure data is entered correctly. Step 1: In column A, the user should choose from a drop-down list of Employee Names. This list is kept in Column I which is hidden in the template and should be hidden in you final version as well. (4 points) Step 2: In column B, the user should type the Employee ID. Employee IDs are 8 digits. You must include input and error messages such that the user knows what to enter in the column when they select the cell and an error message if they enter more or less than 8 digits. (4 points) Step 3: Column Cemployee should choose from product or equipment from a drop-down box. (2 points) Step 4: In columns D and E input messages should explain what the user should enter in the columns Column E should allow for text wrapping. (2 points) Step 5: All input criteria created should be in the first 10 rows of the table so that a user could enter up to 10 rows of data. (2 points) Product/Equpitment Error Reporting Employee Name Employee ID Product or Equipment Product/Equipment # Error Notes Problem 5.3 Data Validation In the Part worksheet you are report errors in products or equip life easier you are to developing correctly. Step 1: in column A, the user sho is kept in Column I which is hidde well (4 points) Step 2: in column the user sho include input and error message they select the cell and an error Step 3:Column Cemployee shoul Step 4: In columns D and Eingu columns Column E should allow Step 5: All input criteria created enter up to 10 rows of data 2 points) Problem 5.3 Data Validation In the "Part3" worksheet you are developing a data sheet for employees across departments to report errors in products or equipment. This data base can be completed by anyone to make your life easier you are to develop input criteria using "Data Validation" to be sure data is entered correctly. Step 1: In column A, the user should choose from a drop-down list of Employee Names. This list is kept in Column I which is hidden in the template and should be hidden in you final version as well. (4 points) Step 2: In column B, the user should type the Employee ID. Employee IDs are 8 digits. You must include input and error messages such that the user knows what to enter in the column when they select the cell and an error message if they enter more or less than 8 digits. (4 points) Step 3: Column Cemployee should choose from product or equipment from a drop-down box. (2 points) Step 4: In columns D and E input messages should explain what the user should enter in the columns Column E should allow for text wrapping. (2 points) Step 5: All input criteria created should be in the first 10 rows of the table so that a user could enter up to 10 rows of data. (2 points)

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

Fundamentals Of Multinational Finance

Authors: Michael H. Moffett, Arthur I. Stonehill, David K. Eiteman

3rd Edition

0321541642, 9780321541642

More Books

Students also viewed these Finance questions