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

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

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