Building a simple Survey Tool in Excel with some specific logical algorithm

Hello experts,

I need a quick support from experts in this forum.

I am in need to create a simple Excel Tool (a kind of Survey) that should have the following:
1) Questions with Answer Options
2) Set of Questions would be under some categories which will have some weightages
3) Each Answer Options will have some specific scores
4) After completion of filling the questionnaire, the result should reflect in an overall score (may be out of 100)

Can someone help me on this? I think a re-usable macro enabled sheet (in the similar line) should work with some editing/customization that I will do.

Thank you in advance!

Cheers.

Thank you Ali, Sourabh and Paul for your respective responses.
Yes, I might had broken some forum rules as I was in a hurry to get assistance. Will keep these in mind.

SurveyMonkey is designed do this sort of thing - for example, see http://help.surveymonkey.com/article...atrix-Question - so why waste time using Excel.......