Just for Fun… The Amazing Macro-powered Excel Slide Puzzle

You know slide puzzles right?

You have a picture set out on tiles which have been scrambled, and you have to slide them around to put the picture back together. Well now you can enjoy them in Excel!

Make sure you enable macro’s and you’re ready to go. If you complete the puzzle and want to start again (or just get stuck) the spreadsheet can even shuffle the tiles for you.

If you like this check out other posts in our Just for Fun category!

Just for fun… Heads or Tails?

You have a row of 1,000 coins, all of which are heads up. You flip the second, fourth, sixth, and all other even coins over so that they’re tails. Then you flip over the third, sixth, and all other coins which are multiples of three. Now you do this for every fourth coin, every fifth coin, etcetera, all the way up to every thousandth coin. Which coins are heads up, and why?

I heard this puzzle mentioned on TV the other day on Growing Pains of a Teenage Genius, and decided to solve it with Excel.

This spreadsheet lets you change the number of coins, or even change the number of sides of the object (a coin is a two sided object, but you could change it to a six sided dice for example).