multiple choice quiz

Is this a one off situation where the questions and answers are always going to be the same (almost like a survey)?  Or you looking to make an app that will allow you to make multiple quizzes, and change the questions and answers regularly?

The answers are going to be the same I just need it to calculate the percentage and make a value for the answer.

If your questions are all going to have different 'weight' values, one way to do this (even though its not the most scalable) is to create an [Points awarded] field for each of the questions.

Example:
[Q1] What color are banana's?
Multiple Choice Options:
A - Red
B - Yellow
C - Blue

[Q1 - Value]   (Make this a formula numeric field, with a similar equation)

If([Q1]="B - Yellow", 5, 0)

That will award 5 points for the right answer, and 0 for anything else.

Then you can take all your [Q - Value] fields and add them up, and divide by the total points possible.

[Score]

Sum([Q1 - Value], [Q2 - Value], ..... [Q20 - Value]) / 100

(Set the properties to display as a percent)

There is another way you can do it with a few tables and relationships, but if you are just doing this once, this might be your best option.

thank you !

What if you have a multi-select text, is it the same concept with the same formula?