Question: I need help answering Task 1(a) and Task 1(b) Task 1 Examine the image below which shows a validation error in cells A6 and A10
I need help answering Task 1(a) and Task 1(b)

Task 1 Examine the image below which shows a validation error in cells A6 and A10 of a spreadsheet. A B CustomerID Customer Name 5 C043 JonextSteel 6 C0123 Jules Verne C032 Howard Snyder CO27 Paolo Gomez C034 Mario Jones 10 C35 rlos Hernandez 11 C036 Yoshi Latimer 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 (focus on the validation criteria) you think is in place for cells A5-A14, 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
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
