Task 8: Prepare the Sales Report Template for Future Use 

In this task, you will prepare the spreadsheet template for future use by others. To achieve this, you will need to clear all the content in the template while recording your macro as required in the Project Brief.  

R 1. in the Template, implement Function 6 as per the Project Brief’s requirements: 

• record the macro and assign to the Clear Template Macro Button 

• test the macro button and all other functionalities for accuracy 

• run the Clear Template Macro Button 

• run the Export the Report Macro Button 

• output must conform to the Style Guide standards 

R 2. save and store the Template in accordance with organisational requirements 

R 3. request feedback from the Sales Manager (Assessor) on the draft Template 

R 4. after the receipt of this feedback, modify your draft template in light of the feedback received 

R 5. attach the screenshots of your cloud-platform with all the folders and files as an Appendix to your Student Assessment Workbook.

Appendix