Excel Quiz Template With Auto-Scoring (Formulas Included)
TL;DR. A simple Excel quiz template that auto-scores when students fill in their answers. Three sheets: Quiz (student-facing), Answers (teacher-facing key), Results (auto-calculated score).
Sheet 1 — Quiz (student-facing)
Columns: # | Question | Option A | Option B | Option C | Option D | Your Answer
Students type A/B/C/D in the Your Answer column.
Sheet 2 — Answers (teacher-facing)
Columns: # | Correct Answer (A/B/C/D)
Sheet 3 — Results (auto-calculated)
Per row, formula compares student answer to correct answer:
IF(Quiz!E2 = Answers!B2, 1, 0)
Sum column for total correct. Percentage:
SUM(Results!C2:C21) / COUNTA(Quiz!B2:B21) * 100
Letter grade:
IF(P >= 90, "A", IF(P >= 80, "B", IF(P >= 70, "C", IF(P >= 60, "D", "F"))))
Sharing the file
Save as .xlsx. Each student fills in their copy and emails back. Or use Google Sheets for real-time collection.
Limitations
When to use SimpleQuizMaker instead
Related reading
Get weekly study & quiz tips
Join teachers and students who get practical tips on quizzing, active recall, and AI-powered learning.
James Okafor
EdTech Researcher & Instructional Designer
More articles by James →
Practice with AI-generated quizzes
Ready to create your first quiz?
Use AI to generate quizzes from your own study materials in seconds.
Try SimpleQuizMaker Free