The Student Room Group
Reply 1
Are you sure it's 2512?

FatMax
Argh sorry 2513, creating an interactive quiz for the hospital
Reply 3
Hi,
Can you please specify the questions,I might help you here...
Thanks
Reply 4
the_fullmetalalchemist
Argh sorry 2513, creating an interactive quiz for the hospital


From my *very* brief reading of the task I don't think it has to be that complex. If I was doing it I'd...

1. Enter questions and multi-choice responses down column A
2. Next to each question/responses have a clearly labelled cell were person enters their response
3. Have "correct" response hidden somewhere off the visible sheet (probably in a protected hidden column)
4. Use an IF statement to compare the actual response to the correct response

Everything else in the task is just counting

HTH
FatMax
vesta code
Hi,
Can you please specify the questions,I might help you here...
Thanks


Task 2
FatMax
From my *very* brief reading of the task I don't think it has to be that complex. If I was doing it I'd...

1. Enter questions and multi-choice responses down column A
2. Next to each question/responses have a clearly labelled cell were person enters their response
3. Have "correct" response hidden somewhere off the visible sheet (probably in a protected hidden column)
4. Use an IF statement to compare the actual response to the correct response

Everything else in the task is just counting

HTH
FatMax



Are you serious, its that simple...? Thank You sooo much! :smile:
But what about creating the instant feedback at the end of the quiz (how many answers the user gets right, wrong and how many attempted)
Which function would you use and how?
Reply 8
COUNTIF

FatMax

Latest

Trending

Trending