Quiz anyone?

[Jon von der Heyden]

Hi Ak

They bring a welcome break in the day, so thank you. Keep 'em coming mate.

 

[Akashwani]

Hi,

If there are any English football fans out there, try this....


Football Nicknames.xls


Good luck.

Ak

 

[Akashwani]

Ok, English football doesn't appear to be popular, so how about music?

Biggest selling Singles of all time.xls

Good luck and enjoy.

Ak

 

[needhelp2]

But deazr I think that you have to make a quiz like if some one open sheet then i ask to select his name which would be from dummy list,one he select name some MSQs comes on sheet or apear sheet with some questions, and a countdown time as well,use will solve question on given time line after that once his time finish or he finish his selection he press submit button,Upon this he got his result on form,plus same result would save with user name along with his date and time of question atemp,right after taht you could get his sheet,to keep your own record,

 

[pbornemeier]

I haven't done a quiz yet (will try some soon), but I read the thread and saw the comments on spelling. Have you considered using a Metaphone or Soundex algorithm compare an answer to an expected answer so as to help those of use who are a bit more relaxed (or forgetful) wrt spelling?

Metaphone
http://en.wikipedia.org/wiki/Metaphone
http://www.tcbutler.co.uk/vba-metaphonics-implementation-v1/

Double-Metaphone
http://www.codeguru.com/vb/gen/vb_misc/tips/article.php/c13137__2/#more

Soundex is easier to implement, but not as useful
http://en.wikipedia.org/wiki/Soundex
http://www.mrexcel.com/forum/showthread.php?t=252698

 

[Akashwani]

Hi Phil,

Thanks for the contribution.
I don't/didn't even know what Metaphone or Soundex algorithms are.
I've looked at the wiki link and it all seems rather complicated to me and probably too much work for me to do to apply it to a simple Excel based quiz.

Thanks again Phil and do try a quiz or 3, you may find them interesting or challenging.

Ak

 

[Crugers]

Hi Akashwani
Came back to mrexcel.com to find an answer to a 'serious' question that's been frustrating me all day.
And I spotted the first of your Quizzes...
WooHoo - just what I needed - a diversion!

Just tried the Wildlife one so far. Score: Pathetic!
To boost my spirit I then started cheating with Google Images...
At http://animals.nationalgeographic.com/animals/mammals/sun-bear/ . I copied the Scientific name from above the picture, Helarctos malayanus, and pasted it into D20 although I'm probably incorrect. It wasn't the first time to copy and paste.
Don't know what I've done wrong, besides cheating , but now I can't change the cell D20! I get the "protected cell dialog"...
I'm off to see if I can break the cities and footballers quiz...

Great stuff - keep up the good work! After all, all work and no play makes....

 

[Akashwani]

Hi Crugers,

I don't know what you've done either. but by cheating at least you are learning!!
The answer you were after is....
Tremarctos ornatus

Good luck with the other quizzes.

Ak

 

[Nalani]

I have enjoyed doing these quizes and have forwarded them to family and freiends.

It got me to thinking on doing the same but using VBA. Allthough I'm in no way an expert in VBA, I thought it might be a challege for me at least try.

The hardest part was trying to figure out a Subject to put into the Quiz. This is where I give Akashawni the most respect. It is not easy to come up with a subject.

I had thought of, and tried numerous subjects like Tools of the Trade, Cooking Utensiles, Cars of different Makers and Years, and others.

The one thing I had to keep in mind was, viewers were from all over the world.

So I came up with this: Flags.Quiz

It's my little attempt on a VBA workbook atempt. It most likely can use a lot of improvement, but like I said, I'm still learning.

Have fun, and please give feed back.

(spelling is crucial, but Propercase is not)

 

[Hermantoothtrot]

Cheeky plug for some quizzes I've created

http://excel-quizzes.cjb.net/