Question: Please make sure to provide an specific data validation rule and explain it Pdta. What other information do you need? Examine the image below which


Please make sure to provide an specific data validation rule and explain it
Pdta. What other information do you need?
Examine the image below which shows a validation error in cells A6 and A10 of a spreadsheet A B 4 CustomerID UT Customer Name John Steel 5 C043 6 C0123 DJules Verne 7. C032 Howard Snyder 8. C027 Paolo Gomez 9 C034 Mario Jones 10 035 rlos Hernandez Yoshi Latimer 11 36 12 C003 Antonio Moreno 13 C009 Laurence Davis 14 C010 Elizabeth Lincoln Task 1(a): In your own words, explain (range: 25-50 words), what kind of data validation rule you think is in place for cells A5-A14 (focus on the validation criteria), and how you reached that conclusion. Task 1(b): In your own words, describe (range: 50-75 words) an example (e.g., taken from your personal experience or from the financial data used for Question 2) that you have encountered that used/uses data validation rules when collecting data, and explain the importance of using validation rules in this case. Examine the image below which shows a validation error in cells A6 and A10 of a spreadsheet A B 4 CustomerID UT Customer Name John Steel 5 C043 6 C0123 DJules Verne 7. C032 Howard Snyder 8. C027 Paolo Gomez 9 C034 Mario Jones 10 035 rlos Hernandez Yoshi Latimer 11 36 12 C003 Antonio Moreno 13 C009 Laurence Davis 14 C010 Elizabeth Lincoln Task 1(a): In your own words, explain (range: 25-50 words), what kind of data validation rule you think is in place for cells A5-A14 (focus on the validation criteria), and how you reached that conclusion. Task 1(b): In your own words, describe (range: 50-75 words) an example (e.g., taken from your personal experience or from the financial data used for Question 2) that you have encountered that used/uses data validation rules when collecting data, and explain the importance of using validation rules in this caseStep by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
