The QUIZ has 3 questions Q1,Q2 and Q3 and a computed result for points.
Try answering the QUIZ and you will see the answer
appear on the sheet. The computed result is sent back to the QUIZ under "Marks obtained".
Column A has the questions list Q1,Q2,Q3 (etc if more)
Column B (Is User Entry?):
for Q1,Q2,Q3 (or any question row) Col B="yes"
for any calculated row Column B="compute" as shown.
Column C : user entry values (Dont change.) Reserved for framework use.
Column D : Formula column
If this is a question row then the formula should flag a right answer as "yes" or "no".
If this is a compute row then the formula should compute the result Click Pic 1 on the top menu bar to see the formulas used.
4) Column E : DO NOT EDIT !
These are internal IDs using by Google for saving this to the Responses sheet.