lJ IQUULJHJ MIMI-I'll\": U] \"UUUUIHH '9 BSBITU402 Develop Complex Spreadsheets EUREEEEHIQES 0 Columns must be wide enough to display data properly. U 0 Include a header containing the le name of the workbook. I] 0 Today's date and a Branch name area must appear on the worksheet. {T he branch I] name will be lled in when the template is used.) 0 Calculate the total sales for each month. 0 Save the workbook le as a template with an appropriate le name in the correct tem- plates folder. Note that macros are required in the template. DD 0 A summary of the sales for each of the three months recorded must appear on the worksheet. This summary must include average, maximum and minimum calculations for each month. All gures must be rounded to the nearest $100. D 0 Format the spreadsheet so it is clear and easy to read. Use Calibri font in keeping with the organisation's house style. Format currency columns to two decimal places. D 0 Check all that formulae work correctly. 0 Ensure that the workbook template is set up to automate all calculations so that user only needs to enter the sales data for each month. 0 Ensure users cannot enter data in formula cells by protecting these cells. 0 Develop a macro that will sort all sales persons into alphabetical order. 0 Develop a macro that will print only the sales summary information. 0 Assign these two macros to buttons at the top of the worksheet. DUDE DD Part 2 0 Using the template created in Part 1 produce a workbook for each branch using the data shown below. 0 Ensure all data is checked to ensure accurate input. 0 Each workbook should be saved with an appropriate le name in your working folder. EDD D 0 Ensure the sales person data is sorted into alphabetical order and summary informa- tion is printed for each workbook