Data Validation tool in Excel is to control the type and values of information that users can enter into specific cells. This helps ensure the accuracy and consistency of your data, leading to more reliable calculations and analysis. You are responsible to develop a reliable worksheet to record each customer transaction of a private chain store.

In worksheet DS $6$ apply the following data validation rule:

a$)$ In cell range A$2$:A$50$ Customer ID should be entered. The customer ID is exactly $9$ digits. Generate a "Stop" alert when someone tries to enter an incorrect ID$.$

b$)$ In cell range B$2$:B$50$ Date of transaction should be entered. The store has opened since February $1$st of $2020$ and the transaction date must be between the opening date and today. Generate an "Stop" alert when an incorrect date is entered.

c$)$ In cell range C$2$:C$50$ the store should be specified. The chain currently has $6$ stores in San Bernardino, Palm Desert, Ontario, Riverside, Corona, and Palm Springs. Generate a "Warning" alert when someone tries to type a store other than these.

d$)$ In cell range D$2$:D$50$ the amount of each transaction should be entered. The amount of transaction is usually between $5$ and $800$ dollars. Generate an "Information" alert when an amount outside of this range has been entered.Date $($Between $02/01/2020$ and Today$)$

Store $($from the list$)$

Amount of Transaction $($Any numbe greater than $5$ and less than $999999)$