Excel for Marketing Managers

Coordinate Grid Matching

Coordinate
Grid Matching

13. Now let’s see if this works.

a. Press F9 to move the smiley face. Type in the cell location of the smiley

face in cell B8, then type a question mark in cell D8. Press F9 again.

You should get a positive response from Excel in a green cell.

b. Change the answer to a wrong one in B8, and press F9.

Now you should have the negative response in a pink cell.

14. This step is important, because it will hide the correct answer from the
    students!

a. Click on cell A8, and press Ctrl+1. Click on the Font tab.

Figure 156

Setting up

conditional

formatting for

responses to

student

answers