Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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.. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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.. |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
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.. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Creating username and passwords | Excel Worksheet Functions | |||
Correct answers like a quiz | Excel Worksheet Functions | |||
Office Friday fun - cracking an excel Quiz... | Excel Discussion (Misc queries) | |||
Creating an invoice with a lookup list | Excel Discussion (Misc queries) | |||
how do i create a quiz using excel? | Excel Discussion (Misc queries) |