Open the file called Spreadsheet plan 402 from the 978-1-925291-30-8 BSBITU402 exercise files folder and use it to plan and sketch the worksheet. Show your sketch to your trainer and discuss the design and selection of formulas.
Part 2 1. Create the Wages template as shown in your spreadsheet plan. 2. Print the template then close.
Part 3 1. Use the Wages template to create a workbook for the week ending 11 November 2016. Click on the Enter hours macro button and type: Employee Hours Eaton, Andrew 25 Ewens, Courtney 30 Garcia. Juan 40 Nyugen, Tan 15 Potter, Melissa 35 Roberts, Lachlan 22 Sinclair, Elizabeth 20 2. Save the worksheet as a macro-enabled workbook with the file name Wages 11 Nov in your working folder. 3. Print and close the workbook