Re: Excel "tests"

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.

--
Andy.


"Anthony Deane" <anthonydeane@xxxxxxxxxxx> wrote in message
news:d3jd76$d66$1@xxxxxxxxxxxxxxxxxxxxxxx
> 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
>


.