HAPPY FACE/SAD FACE
"J" and "L"? What on earth?!
We need Excel to show a happy face when the answer is right and a sad face when the answer is wrong. Although a happy face is on the Drawing toolbar, that won't work for our purposes. Instead, click in cell D2 and type a capital J. Highlight the J, and then select Wingdings as your font. Tada! You've got a happy face (Wingdings is a font of commonly used symbols).

Before moving on, let's correct the Correct column.

- Highlight cells C2, C3, and C4.
- Select Wingdings font.
- Change the size to 22.
- Change the color to green -- or any other color you want that shows up. Yellow is not a good choice. And remember, just the outline of the happy/sad face will appear. The face will not be filled in with a color.
If you have a 2 in cell B2, you should now see a happy face in cell C2. If you have anything else in cell B2, you should see a sad face.

Next: Finishing touches.
|