Quiz Master (Excel template) to conduct quizzes

Here is an Excel template that can be used to conduct quizzes.

Quiz Master template

Download Quiz Master Excel template for free

Purpose

• Suited for conducting quiz events at work, school or home 
• Suitable for groups of people forming teams, or individuals (1 to 4)
• Font sizes have been chosen to suit presentations using projectors
• Works well with multiple choice questions

Quiz gameplay

• A quiz conductor asks the first question to the first participant and the other participants get to answer in a sequence
• Each question will be answered by every one of the participants regardless of whether a participant’s answer is correct or not
• Quiz conductor enters the participants’ answers in the template
• Only the quiz conductor will use the Excel template to conduct the quiz; Participants will not be using the document
• Answer is revealed for each question after all participants have answered
• Points are awarded for every correct answer
• Second question begins with second participant and others answer in the sequence
• Participant with the highest points at the end of all questions is the winner

Features

• Customizable number of questions (1 to 50)
• Customizable number of participants  (1 to 4)
• Customizable participant names
• Value of each answer can be customized
• Displays whose turn it is to answer next question
• Scoreboard gets updated automatically
• Revealing answers with a button
• Moving to the next question with a button
• Correct answers are highlighted
• Quiz progress bar shows the progress
• Easy to enter new questions for a new quiz
• Message board captures errors

What's in the template?

Three worksheets

1. Introduction 
• Information about the template and how to use it
2. Questions
• Where the quiz master will enter questions, answer choices, points and correct answer for each question in the quiz
3. Quiz 
• Input about  number of questions, number of participants  and participant names
• Quiz conducting interface where participants’ answers will be entered
• Scoreboard with scores updated for each participant

Preparation for the quiz

1. Create questions and answers  or collect from outside sources such as books or the internet 
2. Enter Information in the Questions worksheet  
3. Enter number of participants, number of questions and participant names 

Conducting the quiz

1. Click Up button in Current Question
• This makes the next question appear along with answer choices and points
• You may have to scroll down to view the next question 
2. Enter Participants’ answers
• Every participant will answer the questions in  a sequence
• Use the drop downs to answer the questions
3. Click Up button in Reveal Answer
• Reveals the correct answer for the question
• Highlights the correct answers from participants 
• Updates the scores in the scoreboard

Re-starting the quiz

1. Delete any responses from participants
• They are in rows 18 to 67 in columns J,K,L and M, in Quiz worksheet 
2. Set the Current question to 0 (zero)
• You can enter directly in cell F5 or use the down button
3. Set Reveal Answer to 0 (zero)
• You can enter directly in cell H5 or use the down button
4. (Optional) If you would like to change the questions, then update the Questions worksheet with new information
5. Start conducting the quiz

I have also prepared a downloadable PDF document that summarizes the above information. The screenshots are attached below as well.