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.

Spreadsheet.png