How to make a self-marking quiz in Excel


Here is a quick way to set some basic tests/quizzes that mark themselves using Microsoft Excel. It’s a time-saver when using simple multiple-choice quizzes or easy-to-select responses. Although this is nowhere near the usability of Flubaroo, it’s great for teachers who might not have access to online resources.

I have made the Workbook available for website members to download in the Resources section.