Excel Breakout Puzzle 3
It is time for another Excel Breakout Puzzle! Excel Breakout Puzzle? Yes … they are totally fun 🙂 You have to use your Excel knowledge and skills to find the hidden code. I’ve hidden a 5 digit code in an Excel workbook, and if you are up for the challenge, see if you can find it.
Background
Before I get to the puzzle, let me provide a quick background. The escape room trend is sweeping the globe. Here is the basic idea. You and some friends go to an escape room, and get locked inside. You have to look around the room and gather clues to figure out codes to various combination locks. Opening a lock provides access to additional clues, which provide additional codes, and so on. You ultimately figure out the final code used on the door lock to escape the room.
Excel Breakout Puzzles
My family LOVES doing these escape rooms together. They are so fun that I wanted to do something similar in my Excel courses. So, I came up with the idea for an Excel breakout puzzle. You basically need to open the Excel workbook, and look around for clues. You use your Excel skills to solve the puzzle and reveal the code.
These Excel breakout puzzles are used in the Excel University Graduate Certification program as a fun way to apply what you’ve learned in each lesson.
If you’d like to try to solve an Excel breakout puzzle, see if you can find the 5-digit code I’ve hidden in this Excel workbook:
Hope you have fun! And if you figure out the code, let me know by posting a comment below.
SPOILER ALERT
If you’d like to see the answer, just roll the video below.
Also, there may be comments below that show the code, so, if you want to try it first, don’t scroll this page down into the comments section.
Note: I’d recommend giving the Excel breakout puzzle a try BEFORE watching this video. The video gives the answer.
Previous breakout puzzles:
Excel is not what it used to be.
You need the Excel Proficiency Roadmap now. Includes 6 steps for a successful journey, 3 things to avoid, and weekly Excel tips.
Want to learn Excel?
Access all Undergrad and Masters lessons with a Campus Pass or CPE Pass. Includes on-demand training plus live office hours.
Done in < 30 seconds!
Not hard if you use a command (that surprisingly is not that well known as it is seldom discussed) from one of Excel's very useful features you'll find on the Data tab of the Ribbon (There's a clue in the instruction to Step 1) – but there is also at least one other much slower & round-about way to find the key from Step 1. (Hope I haven't given away too much!)
Nice one, Jeff. Do you think we can have the protect workbook/sheet pass to see how it was done?
ghc7ehg9
13401
Google Sheets opens your puzzle with the invalid cells identified without doing anything.
Still fun but not as challenging as your prior puzzles.
Regards
Greg
Nice one!
Got it.
The sum of the 5 digits making up the hidden code is 9 and includes a 0…
Deon
Yeah! 13401
Awesome! Really well done 🙂
I admit, I had to watch the video to get the solution to the 3rd breakout puzzle. Now I am stumped with the 1st and 2nd ones. I think I may have figured out the 2nd one, but am not sure. Is the answer to the 2nd puzzle 847?
That’s not the answer, but I have the solution to the 2nd puzzle here:
https://www.excel-university.com/excel-university-graduate-certification-breakout-puzzle/
Thanks
Jeff
Nice Jeff, 13401, was fun:-)
13401
Fun! Thanks!
Thanks for the hint from Col! 13401
That was cool. Done in 15 seconds…13401
Great Puzzle to reinforce an excel concept. Thanks!
Well, I didn’t do anything sophisticated. I just looked at the values in the cells of the top row on Sheet 2 and used the four that weren’t there (1,2,6,7). No Excel skills needed.
Dave … wow, I try hard to close up any loopholes like the one you found, but, you hacked me, nice! The way I hoped it would work is that on Step 1, you use the Circle Invalid Data command from the Data Validation menu to identify the key. Then, enter the key into Step 2. But, there are usually multiple ways to accomplish anything in Excel, and I see this breakout puzzle is no exception 🙂
Thanks
Jeff
Well done!