#1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 2
Default Quiz...

Could anyone help me out, i've just created a quiz in excel & i'm just
wondering if anyone knows how i go about clearing the answers & totals after
users complete the quiz? so its ready for the next person to have a go at.The
answers are in drop-down boxes, so i was also wondering if anyone knew of a
way to limit users from only having one choice from the drop down menu
therefore if their answer is wrong it's wrong!!
  #2   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 80
Default Quiz...

If they only have one choice, and its wrong, then you are wrong, not them?
--
Hth

Kassie Kasselman


"tiarna" wrote:

Could anyone help me out, i've just created a quiz in excel & i'm just
wondering if anyone knows how i go about clearing the answers & totals after
users complete the quiz? so its ready for the next person to have a go at.The
answers are in drop-down boxes, so i was also wondering if anyone knew of a
way to limit users from only having one choice from the drop down menu
therefore if their answer is wrong it's wrong!!

  #3   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 222
Default Quiz...

Have a look around www.quizardry.com where you will find Excel quiz files and
also some blank files to create your own

"tiarna" wrote:

Could anyone help me out, i've just created a quiz in excel & i'm just
wondering if anyone knows how i go about clearing the answers & totals after
users complete the quiz? so its ready for the next person to have a go at.The
answers are in drop-down boxes, so i was also wondering if anyone knew of a
way to limit users from only having one choice from the drop down menu
therefore if their answer is wrong it's wrong!!

  #4   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 35,218
Default Quiz...

Depends on what you used to create the dropdowns, too.

You may want to be more specific -- did you use data|validation, dropdowns from
the Forms toolbar, comboboxes from the control toolbox toolbar???

tiarna wrote:

Could anyone help me out, i've just created a quiz in excel & i'm just
wondering if anyone knows how i go about clearing the answers & totals after
users complete the quiz? so its ready for the next person to have a go at.The
answers are in drop-down boxes, so i was also wondering if anyone knew of a
way to limit users from only having one choice from the drop down menu
therefore if their answer is wrong it's wrong!!


--

Dave Peterson
Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Creating a Quiz... tiarna Excel Discussion (Misc queries) 2 December 20th 06 10:14 AM
Quiz or Exam creator using Excel, Access, Acrobat? JTaylor Excel Discussion (Misc queries) 0 October 3rd 06 08:03 PM
Correct answers like a quiz Penny Freeman Excel Worksheet Functions 1 April 18th 06 09:52 AM
Office Friday fun - cracking an excel Quiz... Petitboeuf Excel Discussion (Misc queries) 4 January 23rd 06 12:34 PM
how do i create a quiz using excel? Andruu Excel Discussion (Misc queries) 1 June 27th 05 03:03 AM


All times are GMT +1. The time now is 09:33 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"