Excel "tests"

[Anthony Deane]

Hi,
Does anybody have a link or a guide to how to create one of those excel
tests. (You know, the kind that you see with quiz questions, and when you
type the answer in you get a tick or a cross etc.)

Any help is appreciated

Anthony

 

[Guest]

Hi

The usual way it is done is to have the corresponding answers in some
obscure hidden cells. In the tick/cross box you'd have:
=IF(theiranswercell=correctanswercell,"Correct","Wrong")
You can then lock all of the cells, except the ones they type their answers
into, and then protect the sheet so the formulas cannot be seen and the data
can't be changed.