Question: Project One Task Description In assessment 1, you were asked to prepare a cashbook template. If you have received a Satisfactory grade from your assessor

Project One Task Description In assessment 1, you were asked to prepare a cashbook template. If you have received a Satisfactory grade from your assessor for assessment 1, you can assume that your supervisor, Ethan, has approved your completed template. He would now like you to use this template to summarise the cash transactions for the January to March quarter. Task Six - Use the cashbook template 6.1 Create a new workbook based on your approved cashbook template. Save and name this spreadsheet to show that it contains Qtr 1 data - ensure the spreadsheet is saved as a macro-enabled document. 6.2 Name sheet 1: 'January'. Create copies of your January sheet twice, renaming the new sheets as 'February' and 'March'. Create a fourth sheet called 'Qrtly Totals', which will be blank for now. 6.3 Enter correct month names on each sheet in the cell provided for Month. Task Seven - Enter Data Note: Wages have NO GST so ensure your formula for wages indicates a zero. Do NOT override your formula to just type 0

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Accounting Questions!