FINISHING YOUR WORKSHEET

Almost done! Highlight cell C2, and change the font back to a text-based font. (Why? We need to use that formula for other cells and, without changing the font, the Wingdings symbols will make it hard to copy.) You should see a J or L in cell C2 again.

Next, highlight cells C2, C3, and C4, and then click Edit>Fill>Down. You now should see Ls in cells C3 and C4. Click in cell C3, and you'll see that your if/then statement has been copied and pasted there, except now the statement uses B3 (the answer to 2+2) as the condition it's testing.

But our if/then statement still has "2" as the answer. We need a "4" instead, because the equation for cell A3 is 2+2=? So...

• Find the Formula Bar at the top of the screen.
  
  
• Click in the blank just behind the 2, and change the 2 to a 4.
• Hit Enter or Return.
• Type a 4 in cell B3, and you'll see a J appear in cell C3.
• Click in cell C4, go to the formula bar and change the 2 to a 6 in the if/then statement (because A4 asks what the sum of three plus three is).
• Highlight cells C2 through C4, and change them back to Wingdings font. Experiment with both correct and incorrect answers in cells B2, B3, and B4 and watch the happy and sad faces change as your answers change!
  
  
• Save your work.
• Click File > Save As and select Template as the file type to create a version of the worksheet that students can practice on, but not permanently alter. Make sure you double-check where the template is saved (why not put it on the desktop of your classroom computers), and be sure to name the file something you and you students will recognize.

The above technique might seem complicated at first, but consider that, after you've made one worksheet, you can go back and change the correct answers and the questions in column A and be done in seconds. Use the worksheet you just created as the starting point for many more worksheets. If you want a title on your worksheet (for printing purposes), click View > Header and Footer, click Custom Header, type your name, worksheet, date, and/or title, and click OK.

That's it!

Next: Learn more.