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 case