problem

  • Thread starter Thread starter john mcnelley
  • Start date Start date
J

john mcnelley

Dear People

I have been trying a few odd things as seen in the newsgroup and have
seemingly got the
hang of Vblookup. Quite clever stuff really. The next problem I am looking
at ... is how to
make a quiz using excel without recourse to a lot of VB ... which I don't
understand much at all.

I got this idea by looking at an old DOS program I found on the net which
asked a whole
bunch of questions and depending upon the multiple choice answers, put you
into a suitable
box at the end of the process. As I have Windows XP, getting this old DOS
program to work
properly is a bit fanciful.

I have found a matchmaker excel worksheet which I can get a sense of how
this project might work
but I don't really know enuf about Excel to do much with it. What I am
working with at the moment
is a phoney psychological test with about 30 questions that would appear on
one Worksheet with
a facility to enter a "y" for yes and a "n" for no and then grade the result
from there.

Eecchh tho, if this seems vague, it is mainly because my understanding of
Excel is vague. Has anyone
any idea how this could be done ... simply tho.

How would one make a Cosmo type Quiz in Excel???? The idea I find intriguing
and brain bending.

John
(e-mail address removed)
 
Check out the use of forms in excel, this is the way I think you'd want to
go although it does use VBA.

If you don't want to use VBA you would have to stick to just worksheet
functions, I would use a sheet for your questions and a summary sheet for
the assesment, let the user add a "Y" or "N" in the column next to the
question. You could use a third column to hold a weighting, so, if someone
puts "Y" in column 2 (question in column 1) you might want in column 3
something like .... =if(column2="Y",1,0) you could use multiple if's if you
wanted to get answers like Y,N,X,Q

Once all the questions have been answered sum up the scores with a sum
function and use a lookup value to get an idea of the persons assement score
(you know the stuff <5 = complete nutter, >5 <10 = there is hope ... etc
etc)

Check functions like upper and lower so you can catch those people who use
different cases (Y or y)

HTH

Chris
 
Back
Top