Quiz anyone?

[JamesW]

Wiki: A spambot is an automated computer program, or, more rarely, a script, designed to assist in the sending of spam.

You can usual tell on here because they add random links to their posts in the hope people will click on them - some can be malicious.

 

[Jon von der Heyden]

Although as far as spam here is concerned I don't think we get hit by spam bots. For the most part they are posted manually...

 

[JamesW]

That's just sad

 

[arkusM]

Multiple choice!!!!

That gives me something to think about for the future, not sure how I would format the sheet etc, but a good suggestion anyway, thanks.

Ak

You could give Validation from a list a try. Then the rest of you formulas should still work.

 

[Akashwani]

Hi arkusM,

Thanks for the comment.

Now you have me thinking
Are you suggesting that I put a dropdown list in each answer cell with the answer options in the dropdown list?

Any suggestions on a quiz topic?

Ak

 

[Akashwani]

Hi all,

I have given some thought into what has been suggested so far and I have created a new (test) quiz... "Famous" Faces.
With it being a "test" quiz, there could be one or two problems that I haven't spotted, so I would like to apologise for that and no doubt I will be informed promptly of them

This quiz has the answers in a drop down list within each "Answer" cell, so no problems with spellings! There is a slight catch to this, which I'm sure the observant ones will spot pretty quickly.
I have placed the pictures over several rows so that the sheet scrolls in a better way.

I hope that you enjoy doing this quiz as much as I was frustrated whilst creating it.

Famous Faces Quiz.xls

By the way, don't tell me I missed person X Y or Z off!

Good luck, I look forward to your comments.
There is NO vba in the file.

Ak

 

[Jon von der Heyden]

I reckon I got 36 but it doesn't tell me what I scored. Still enjoyable though and a welcome break from mundane VBA programming

 

[Akashwani]

Hi Jon,

Thanks for doing the quiz.
Did you answer ALL 48 questions?
You need to answer ALL 48 questions to get your results.
I've just tested it and it works for me.
Did you get the

Ak

 

[Jon von der Heyden]

I got the

Ok, I left blank the ones I didn't know. That explains why. Thanks

 

[Akashwani]

A big thank you to all the people that have downloaded the quizzes that I have posted on here. Over 50 downloads, I think that's great, just amazing, thank you.....

Excel Workbook
	A	B
1	Quiz	Downloads
2	Capital City	10
3	Cartoon	11
4	Famous Faces	6
5	Music	10
6	Wildlife	15
7	Total	52
Sheet1

I hope that you have all enjoyed doing them and that you pass them along to friends/family and work colleagues.

I look forward to doing another one and sharing it with you as soon as a topic comes up.

Thank you for making me feel like they are worth the time and effort.

Ak