| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
making a test paper
How do i insert a yes/no facility that can be clicked on at the end of a
question? I've seen what I want in the templates but I can't modify to offer multiple answers. Thanks Spacemagnet |
|
#2
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
making a test paper
Explore data validation?
Select the range, click Data Validation Under Allow: List Enter in Source: Yes, No Click OK -- Max Singapore http://savefile.com/projects/236895 xdemechanik --- "spacemagnet" wrote: How do i insert a yes/no facility that can be clicked on at the end of a question? I've seen what I want in the templates but I can't modify to offer multiple answers. Thanks Spacemagnet |
|
#3
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
making a test paper
Thanks Max, it worked just as you said. However, as soon as a click on
another box it disappears only coming back when I return to the box. How do I keep it visable for all to see? "Max" wrote: Explore data validation? Select the range, click Data Validation Under Allow: List Enter in Source: Yes, No Click OK -- Max Singapore http://savefile.com/projects/236895 xdemechanik --- "spacemagnet" wrote: How do i insert a yes/no facility that can be clicked on at the end of a question? I've seen what I want in the templates but I can't modify to offer multiple answers. Thanks Spacemagnet |
|
#4
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
making a test paper
One way is use an input message ..
Re-select the DV range, click Data validation Click on the Input Message tab Under Input message, type say: Select response Click OK -- Max Singapore http://savefile.com/projects/236895 xdemechanik --- "spacemagnet" wrote: Thanks Max, it worked just as you said. However, as soon as a click on another box it disappears only coming back when I return to the box. How do I keep it visable for all to see? |
|
#5
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
making a test paper
Thanks Max i think I'm getting to grips with it now.
"Max" wrote: One way is use an input message .. Re-select the DV range, click Data validation Click on the Input Message tab Under Input message, type say: Select response Click OK -- Max Singapore http://savefile.com/projects/236895 xdemechanik --- "spacemagnet" wrote: Thanks Max, it worked just as you said. However, as soon as a click on another box it disappears only coming back when I return to the box. How do I keep it visable for all to see? |
|
#6
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
making a test paper
Welcome, spacemagnet.
For more info on Data Validation, try Debra Dalgleish's marvellous coverage at her: http://www.contextures.com/xlDataVal01.html -- Max Singapore http://savefile.com/projects/236895 xdemechanik --- "spacemagnet" wrote in message ... Thanks Max i think I'm getting to grips with it now. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Paper size. | Excel Discussion (Misc queries) | |||
| Calculate mean of test scores from rows of test answers | Excel Discussion (Misc queries) | |||
| Paper Size A3. | Excel Discussion (Misc queries) | |||
| graph paper | Setting up and Configuration of Excel | |||
| test..where are my messages..test | New Users to Excel | |||
Linear Mode
