Number Mystery

Excel required
4 files: A. The Case of the Missing Smarties. See main image
B. The Case of the Missing Marbles.
C. The Case of the Missing Conkers.
D. The Case of the Missing Iphones
Work out the answer to each question and keep a cumulative total as you go along.
Having answered the final question, look to see if the Grand Total can be found in any of the rooms. Fill in the appropriate box with the number of Smarties/Marbles that you’ve found. Place a tick in the last box if the number does not appear in any of the rooms.
The worksheet provides a new set of random numbers each time the file is opened.
Use the fn key and f9 key to change the numbers manually

The cumulative tally is provided on a separate sheet.