Microsoft Office
Multiple worksheets exercise
Harder than average exercise

This Microsoft Office MULTIPLE WORKSHEETS exercise is provided to allow potential course delegates to assess their suitability for the Wise Owl ADVANCED EXCEL course only, and may not be reproduced in whole or in part in any format without the prior written consent of Wise Owl.

Exercise: Difficult multiple sheets with cartoon royalties

1)	Download the files needed to start this exercise: exercise-170.zip (and click here if you experience any problems unzipping this file after downloading it).
2)	Add cells at the bottom of the Total sheet to show the total number of cartoons shown and royalties received.
3)	Create 3-dimensional range names as follows: TotalCartoons to refer to all of the cartoons figures for all of the areas TotalRoyalties to refer to all of the royalty figures for all of the areas
4)	Create formulae in the two cells you have just added, which show total cartoons and royalties by summing over the ranges you have created:
	The final answer should look like this
5)	Move the Europe worksheet to a new workbook by clicking and dragging, and check that your totals have changed in the original sheet.
6)	Close this workbook down without saving any changes.

Thank you for showing an interest in this Advanced Excel training course!

Return to the list of exercises for this topic