Self-Correcting+Google+Quiz

=To Make Your Quiz Self-Correcting ...=

The Copy&Paste 10 Questions Edition

 * Step 1:** Take the quiz yourself. Enter the exact right answers.


 * Step 2:** Access the form as a spreadsheet. In cell **M3** enter the number 10; the maximum perfect score for this quiz.


 * Step 3:** Copy the formula below (including the "=") and paste it into cell **N3**.

=(IF(C3=$C$2,1,0)+IF(D3=$D$2,1,0)+IF(E3=$E$2,1,0)+IF(F3=$F$2,1,0)+IF(G3=$G$2,1,0)+IF(H3=$H$2,1,0)+IF(I3=$I$2,1,0)+IF(J3=$J$2,1,0)+IF(K3=$K$2,1,0)+IF(L3=$L$2,1,0))


 * Step 4:** Copy the formula below (including the "=") and paste it into cell **O3**.

=ROUND((N3)/(COUNTA($C$2:$L$2))%,0)


 * Step 5:** Test it out by taking the quiz again and entering some right & some wrong answers.