Question 1 [10] You are an intern in a retail store's laptop and tablet sales department. The sales manager has complained of incorrect data recordings. The date data are recorded in different formats with poorly documented sales figures. It is difficult to read the recorded sales figures with no currency symbol. You used your Excel skills to enforce data validation in the spreadsheet to prevent such challenges in the future. Below is the table containing the recorded sales. Answer the questions below. Required: 1.1 Create a sales spreadsheet the company can use to record the sales in the correct currency values. (2 marks) 1.2 Calculate the total sales recorded. (2 marks) 1.3 Add data validation to restrict date entries and input message to the Date column to notify users to enter dates only between 2022/01/01 and 2022/12/31. (2 marks) 1.4 Add an alert message to the date column that notifies the user that the column only accepts dates if a text is entered. (2 marks) 1.5 Restrict the total sales column to accept currency without decimals and add a message that reads, "Only enter currency values without decimals." (2 marks)