software

Hi
I am trying to a test sheet for school kids in XP 2003
I have 20 questions They choose one of three possible answers from a drop
down list (did that). Now I want to compare their choice with the correct
answer in the adjacent cell, which will be a hidden column. If the word
matches correctly message says correct if not incorrect. an If statement
should do it I think .
I then want them to click a button to unhide the column with the correct
answers and reveal their score out of 20. I am not sure what formula to use
for the last calculation or the exact IF formula.
Can anyone help or am I going about this the wrong way?
Thanks

I have posted a simple example for you at cjoint.com/?cisU5tNmcF

--

HTH

Bob Phillips

(remove nothere from the email address if mailing direct)

quot;kimquot; gt; wrote in message
...
gt; Hi
gt; I am trying to a test sheet for school kids in XP 2003
gt; I have 20 questions They choose one of three possible answers from a drop
gt; down list (did that). Now I want to compare their choice with the correct
gt; answer in the adjacent cell, which will be a hidden column. If the word
gt; matches correctly message says correct if not incorrect. an If statement
gt; should do it I think .
gt; I then want them to click a button to unhide the column with the correct
gt; answers and reveal their score out of 20. I am not sure what formula to
use
gt; for the last calculation or the exact IF formula.
gt; Can anyone help or am I going about this the wrong way?
gt; Thanks