Creating a Quiz...
 

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..

Creating a Quiz...
 

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..

Creating a Quiz...
 

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..