Math Facts Game
Math Facts
Game- Copy the formula from A1 to A2.
This formula required a lot of precise typing, so you will just copy it into
cell A2. Click on cell A2, and press Ctrl+D. The formula you typed in cell A1
will be copied into cell A2, and the references to cell A1 will change to A2. - At this point, you need to clean up the appearance of the worksheet, but it
should work. Perform these steps to make sure.
a. Press the F9 key and watch the numbers in cells D16 and F16 change.b. Type your answer into C19 and E19, and then type? into cell G19.c. Press F9 and notice that the random numbers do not change, but you
will get a response in row 21 in the three merged cells.d. Type “show” (without quotes) into cell G19 and press F9 again. The cor-
rect answer will appear in row 21.If things aren’t working properly, you need to go back and carefully
proofread all your formulas and correct the errors.- Now that everything works, you can make some changes to improve the
appearance of the worksheet.
a. First, select cells A1 and A2 by clicking on one and dragging to the
other. Press Ctrl+1 to open the Format Cells dialog box, and click on the
Font tab.b. Under the word Color, there is a drop down menu that currently says
Automatic. Click on the arrow and select the white color box in the pal-
ette. This will make the text in these cells “invisible”. Click OK to exit.Tip:
Again, to customize this for your students, simply change the numbers after
RANDBETWEEN in the formula. The numbers you type are inclusive. Just remem-
ber to copy the changes into both cells A1 and A2.