Activities Complete the Activities Complete the foBSBTEC402 Design and produce complex spreadsheetsllowing activities: 1. Carefully read the following: For this project you are required to produce two spreadsheets on two occasions. You will demonstrate that you can use advanced functions, create graphs and follow organisational requirements. This will include completing the following tasks: Planning and preparation Creating and using templates Developing a spreadsheet solution Developing macros Testing data Importing and exporting data Creating graphs File management This project requires you to base your work within an organisational context. Due to the nature of complex spreadsheets, you will do this based on the case study business provided in the Simulation Pack. These two occasions can be on different days, or they can be completed on the same day after some time has passed, for example, one occasion in the morning and one occasion in the afternoon Ensure to read through the case study information provided in the Simulation pack before starting the activities. You will be collecting evidence for this unit in a Project Portfolio. The steps you need to take are outlined below. Before you begin, complete page 4 of your Project