Secret Code messages in Excel

Here is an activity I made using a few of the skills our CAT learners need to know. It’s a secret message decoder! Basically, numbers correspond to letters based in two sets. The task is to write a formula with functions that will help decipher the code and figure out what the sentence says.

This is a starting point for you, the teacher. I expect you to make it better and take it further!

If you like the font I used (see the screenshots), it’s called ‘Top Secret’ and you can download it here.

The activity consists of the following skills

  • Data validation message (when cell is selected)
  • Named ranges
  • ISBLANK function
  • NESTED IF statements
  • HLOOKUP
  • Conditional formatting using icon sets
  • CONCAT function

Here is a video showing you how it all works

Download the Excel file
About Matthew Hains 775 Articles
Matthew is a Computer Applications Technology teacher at an independent school in South Africa.

Be the first to comment

Leave a Reply

Your email address will not be published.


*