Constructing a spreadsheet simulation model of Chuck-a-luck: An application of logical functions

Chuck-a-luck is an inviting game played at carnivals in the Midwestern United States and England. A player picks a number from 1 to 6 and an operator rolls three dice. If the number chosen by the player comes up on all three dice, the player wins $3; if it comes up on two of the three dice, the player wins $2; if it comes up on one of the three dice, the player wins $1. Only if the chosen number does not appear at all does the player pay anything, which is just $1. We would like to know if Chuck-a-luck is a fair game, and what is its average payoff? In addition, we are interested in simulating this game using logical functions built into spreadsheet software as well as other computer programming languages.