Setting up questions & answers

[Paul]

Any pointers would be most appreciated. I'm wanting to create exams online
and have been told Excel will do this. For instance 20 questions with each
question having to choose the correct answer from a number of possible
answers. I want whoever to go through trhe 20 questions and only know how
many they got right by submitting at the end. They won't know which they
got right, only the number they got right. Any advice where to start with
Excel would be brilliant.

Best,

Paul B.

 

[JP]

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

 

[FloMM2]

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(D225) 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