562 attributed reviews in the last 3 years
Refreshingly small course sizes
Outstandingly good courseware
Whizzy online classrooms
Wise Owls only (no freelancers)
Almost no cancellations
We have genuine integrity
We invoice after training
Review 30+ years of Wise Owl
View our top 100 clients
This exercise is provided to allow potential course delegates to choose the correct Wise Owl Microsoft training course, and may not be reproduced in whole or in part in any format without the prior written consent of Wise Owl.
Open the file contained within the folder name shown above.
This workbook has separate sheets showing an (imaginary) child's expenditure from January to May:
Click on the sheet tabs for each month to see the expenditure for that month.
Use your CTRL key to copy the May sheet to create another copy and re-name it as June:
When you click and drag using CTRL it creates another copy of that sheet.
Type in new figures for June as shown below:
June is an expensive month! Change the month name in cell B1 to June.
Use your CTRL key to copy the June sheet to create another copy and re-name it as TOTALS.
Delete all the costs in cells B4:B10.
On the TOTALS sheet, in cell B4, use a 3D sum to add together all iTunes costs for all 6 months.
Copy this down to calculate all the other costs.
Change the iTunes cost in June to £45 (do people still use iTunes?) and check that the total updates:
Your formula in column B is a 3D sum.
Select all the sheet tabs to go into group mode so that any changes you now make will be made to all the sheets, then do the following:
Format all the numbers to Currency with 2 decimal places;
Add light shading behind all the number cells;
Change the text in cell A7 from Socialising to Tickets for Clubs
Remove row 10 - your child says sport is too expensive!
Remember to now make sure that group mode is off (click on the sheet tabs) at the end!
The new TOTALS sheet should look very similar to this:
No more sport, sadly!
Use Save As... to save the file in your own new Excel work folder.
You can find other training resources for the subject of this exercise here:
25 Aytoun Street