Excel Breakout Puzzle 6
I think it’s about time for another breakout puzzle … yes! This breakout puzzle has an astronomy theme … you know, stars, constellations, the milky way, telescopes, and so on. I’ve always enjoyed looking up at the night sky. Being able to recognize stars and constellations helps me feel at home when I travel to new cities. And with all of the technology we have today, we are able to see into the depths of the universe like never before. It is so vast, and its beauty is the inspiration for this breakout puzzle. Hope you enjoy it!
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.
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.
This breakout puzzle has 3 steps. In step 1, you want to find the 5 digit numeric key that I’ve hidden. You’ll have to use your Excel knowledge to find the key. Once you do, enter the key into the Step 2 sheet to reveal the 5-letter code. To verify that the code is correct, head to Step 3 and enter the code. If it is correct, you’ll be able to use the resulting link to view a fun congratulations page. If you think you are up for it, download the file below:
If you decide to give it a try … good luck, I hope you have fun 🙂
If you solve the puzzle, please post a comment with something like “Got it!” but please don’t post the actual code.
Here are the previous breakout puzzles in case you’d like to check them out:
- Excel Breakout Puzzle 5: BreakoutPuzzle-5.xlsx
- Excel Breakout Puzzle 4: Breakout4.xlsx
- Excel Breakout Puzzle 3: Breakout3.xlsx
- Excel Breakout Puzzle 2: Breakout2.xlsx
- Excel Breakout Puzzle 1: Breakout Puzzle
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.
Got it.. nice! Thanks for the challenge.
Way to go 🙂
Got it 🙂
Got it! Yay!
Got it, also in The Netherlands!
Can’t get it 🙁 Any help please ??
Are the icons with the conditional format important ? Thx for your answer, i’m lost
Hi Benoit … sorry for my delay, it has been a crazy couple of weeks. Here is a walk through of how to solve the puzzle:
1 – On the Step 1 sheet … the notes for getting the key are designed to get you thinking about stars, and in fact, the first letter of each line creates the word STAR. So, the hint about using the correct set of icons means that you want to apply a conditional formatting star icon set to the night sky, or, the range that is filled black. If you use the star icon set, or any other icon set with 3 icons, you’ll notice that there are 5 columns. The first column has 1 gold star, the second column has 5 gold stars, the next column has 2 gold stars, then 9, and then 1. So, the key is: 15291.
2 – On the Step 2 sheet … enter the key into the step 2 sheet one digit at a time into the 5 input cells. 1, 5, 2, 9, 1. This will create a line graph with a point on five constellations. Hercules, Cassiopeia, Leo, Aries, and Orion. Since Step 3 is asking for a five letter code, and there are five constellations, you’ll enter the first letter of each constellation.
3 – On the Step 3 sheet … enter the five letter code: hclao. This will update the hyperlink. Click the hyperlink and you should be taken the to congratulations page 🙂