Why not turn to some professional quiz tools in the market ? They will
make quiz creations more easily and also you can have questions in
different question types.
You can have a look at QuizCreator here
http://www.sameshow.com/quiz-creator.php?sid=5
See if it can meet your requirements
BOBODD wrote:
Look up 3D referencing in the Excel help, you can refer to items on sheet1 as
"Sheet1!A3" (no speechmarks).
"tiarna" wrote:
Hi,
I have to create a quiz in Excel & am finding it slightly differcult, i can
manage dropdown boxes & validations, but i'm confused as to how i can put my
answers/IF functions on sheet 2(to hide the calculations) but make the
appear/corespond in Sheet 1..
Any help would be greatly apreciated..