You could use a MultiPage Control on a Userform to list the questions,
with radio (option) buttons to select the answer, then a "Submit"
button to validate the user input and print the score to the screen.
For that matter, you could do it with just a regular Userform.

HTH,
JP

Paul,
First of all - I do not agree with you in that the person taking test will
not know which one is right or wrong just the final tally.

To get you going in the right direction - Wite your questions starting in
Column A Row 2. Use answers A, B, C, D in Column C in Row after last line of
question. In Column to right of question, say Column F Row same as last line
after question put the correct answer (A, B, C, or D). Keep all your answers
in this Column.
Next Column to right, type"= IF(C2=A,1,0)"
C2 is the place you put correct answer
A is correct answer, could be B, C or D
After last question, total the sum of correct answers.
Type "=SUM(D2:D25) how ever many questions.
         Column A        Column B      Column C     Column D      Column G
Row1   What is 1 + 1 =?                 Answer                            
Total
                             A= 2
                             B = 3
                             C = 1
                             D = 5
Row 6                                                A              
=IF(C6=A,1,0)

Row 55                                                              
=SUM(C6:C55)
Then hide Columns C,D and E.
You will need a VB script to total the sheet and close it so the student can
not see which is correct.
hth