Fun and Games

Games are great for demonstrating interactive and random number techniques. Fun features encourage repetition, which accelerates learning. This file has four sheets for single player practice, including two games with simulated competition.
 
Poker: cards are dealt to two players, with click to hold for up to three deals before the winner is revealed. Counting and scoring processes are displayed. Uses symbols and array functions.
 
Dice: two pairs of dice are rolled and the result scored. A game can be up to 100 rolls. Dice are designed in a symbol font with various dot options, using array constants to put the dots on the face.
 
Snake: uses four directional arrows to trace the cursor around a play zone, demonstrating how selection works. Uses the Worksheet_SelectionChange event. Pick one of two simple games, or just practice.
 
Palindrome: fun word-play; enter a phrase and it is separated by letter and reflected to see if a palindrome can be made. Adjust spacing and punctuation, and record results. Uses array and text functions.
 
Excel features: Advanced formulas; Logical, Text, Array Functions; Name Manager named ranges and formulas; Conditional Formatting; Data Validation rules and messages; Table processing; Controls; VBA: each sheet contains its own macros for game play, selection and navigation.