Task 3: Use Lookup Function to Retrieve Data into the Template 

In this task, you will demonstrate your skills to populate the Sales Report Template by importing data from an external Excel spreadsheet (Current Sales Data.xslx), recording macros, and using complex Excel functions. 

Look up data using the ‘Look Up Current Data Macro Button’ 

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

• test the lookup function, the macro button, and all other functionalities for accuracy 

• 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. 

Appendix