Instruction on how to create Excel Quzzes.

[Taz Devil]

Do you have a template or a help section that can walk some of us through how to create quizes.

I have a basic idea how to do it but thats using the
if cell1 = cell2 then cell3 = Correct

but all it takes is for a user to find which cells hold the answer for them to be able to use them.

Do you have a template or anything that can be used.

P.S.
I am using Excel 97 SR-2

[madcat]

I don't use a template sorry I use formula and write them as I go.

Your idea for the logic is correct but the formula layout is quite difficult to explain...

if your questions are in column a and answers in column b. You then compare the entered answer with the one you are looking for which for example is on a second sheet in column a.. your forumula would look like this:


=if((B1=Sheet2!a1),1,0)

This would mark 1 if it is correct, 0 if not.

Have a look in the help index it explains formula really well.. most of the rest is quite simple formatting.

Always put a strong password on the sheet and workbook. I also use extra coding so online crackers can't work it out, but I'm not telling you how I do that bit!!

Hope this helps

MadCat