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.

Q1: 366

Q2: Mercury (must match, case sensitive)

Q3: China

Colin.Rebello@gmail.com

Before you submit here's what happens.

When you press submit here's what happens.