Cape Machinery sells various types of machinery and equipment. You have been provided with the attached...

Transcribed Image Text:

Cape Machinery sells various types of machinery and equipment. You have been provided with the attached sales data records. You noted different date formats are used in the document. The records are for the February to May 2023 period. From the knowledge you have acquired from the Computer Advanced module, create a sales report for the company's management by answering the following questions. Required: 1.1 Correct the date format in the sales record to use the YYYYMMDD date format (4 marks) 1.2 Calculate the total sales recorded for each item and the total sales for the period. (3 marks) Cape Machinery sells various types of machinery and equipment. You have been provided with the attached sales data records. You noted different date formats are used in the document. The records are for the February to May 2023 period. From the knowledge you have acquired from the Computer Advanced module, create a sales report for the company's management by answering the following questions. Required: 1.1 Correct the date format in the sales record to use the YYYYMMDD date format (4 marks) 1.2 Calculate the total sales recorded for each item and the total sales for the period. (3 marks)

Answer rating: 100% (QA)

The image is showing a text that outlines two tasks required to be completed based on a dataset from ... View the full answer