Creating a "quiz"

[Dog Paw]

Hi,

I'm not sure if anyone knows the answer to this, but here's my problem:

I want to have a multiple-choice quiz with questions that the user fills out. At the end of the test, the user is given a suggestion based on their answers.

For example, let's say this is a quiz for what car would be the best for you to buy. You answer questions like, "Is four wheel drive important to you?" or "What year do you want the model to be?" If you said yes to the first question, then one of the possible cars that may be suggested to you at the end (let's say Volkswagen) gets "points." At the end of the test, the car in the list of possible outcomes with the most points is suggested to the user as the best car for them.

The problem is, I've made something like this in Excel, and it works exactly like I want it to. But no one wants to download an Excel document and fill in the multiple-choice questions by putting answers into the cells, and it looks unprofessional.

Is there any way to somehow take all this Excel information and the formulas I've created and convert it into a better format, or is there some way to do all this without Excel? It would be better if I could have this in a professional-looking test sheet that can be put on a web page for people to take, instead of downloading an .xls Excel document and doing it that way. It would also be nice if I could create the design in Photoshop so I could control how the test looks. But I don't have programming knowledge, so I'm not sure if this is possible to do without Excel.

If anyone could help I'd really appreciate it. Let me know if I didn't explain my problem clearly.

Thanks for any help!

[jwright650]

Would a UserForm work better for you?

EDIT: added an example(but you have to enable macros)