You are an intern in a retail store's laptop and tablet sales department. The sales manager...

 

Transcribed Image Text:

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. Date of purchase Product name Unit cost in Rands Quantities sold 2022/09/08 Galaxy Book Odyssey 85000 3 2022/09/16 Galaxy Book 2 49000 4 2022/10/17 Galaxy Book 2 Pro 65000 2 2022/10/21 Galaxy Book 3 72000 5 2022/11/12 Galaxy Book3 Pro 80000 7 2022/11/22 55" Odyssey Ark 30000 3 2022/11/24 Galaxy Tab S8 6000 6 2022/11/26 Galaxy Tab A7 4000 7 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) 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. Date of purchase Product name Unit cost in Rands Quantities sold 2022/09/08 Galaxy Book Odyssey 85000 3 2022/09/16 Galaxy Book 2 49000 4 2022/10/17 Galaxy Book 2 Pro 65000 2 2022/10/21 Galaxy Book 3 72000 5 2022/11/12 Galaxy Book3 Pro 80000 7 2022/11/22 55" Odyssey Ark 30000 3 2022/11/24 Galaxy Tab S8 6000 6 2022/11/26 Galaxy Tab A7 4000 7 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)

Answer rating: 100% (QA)

To create a sales spreadsheet with the requested features follow these steps in Excel 11 Create a Sales Spreadsheet Create a new Excel spreadsheet and enter the following headers in cells A1 B1 C1 and ... View the full answer