Locked lesson.

Upgrade

About this lesson

Add a Multiple Choice Quiz Question. 

Quick reference

Create Quiz Questions

Create a multiple choice quiz question. 

When to use

We create quiz questions when we want to test someone's knowledge and assign points for correct answers. 

Create Quiz Questions

  • Click Add new. 
  • Click Choice. 
  • Type the question 'What Excel function would we use to add up a list of numbers?'
  • Add an image (optional). 
  • Click in Option 1 and type 'COUNT'.
  • Click in Option 2 and type 'AVERAGE'.
  • Click Add Option. 
  • Click in Option 3 and type 'SUM'.
  • Click Add Option. 
  • Click in Option 4 and type 'MAX'. 

We now need to specify which one is the correct answer. 

  • Click the tick next to the correct answer. 
Add a Message

We can add a helpful message to each quiz answer to give the responder some context. For example, if they got the question wrong we can give more detail. 

  • Hover the mouse over any quiz answer and click the speech bubble icon. 
  • Add a message. 
  • Repeat this step for all answers. 

Assign Points

We can assign points for correct quiz answers. 

  • Click in the Points field and type '10'. 

Preview the Quiz

  • Click the Preview button to preview the quiz. 

Hints & tips

  • If we toggle on Multiple answers, responders need to get all answers correct to achieve the points. 
Login to download
  • 00:03 You'll find that many of the question types that you can add into a quiz
  • 00:08 are exactly the same as the question types you can add into a survey.
  • 00:13 There are, however, some differences, and
  • 00:15 it's those differences that I'll be working through in this section.
  • 00:19 Now, the first thing we're going to add to this quiz is a multiple choice question.
  • 00:24 So let's click on Add new.
  • 00:26 Let's select Choice, and now we can add our first question.
  • 00:29 What Excel function would we use to add up a list of numbers?
  • 00:34 Now, we can add an image as always.
  • 00:36 We're not going to in this instance.
  • 00:38 And then we can add in the options that we want them to choose from.
  • 00:41 So let's say option one is COUNT,
  • 00:46 option two is AVERAGE.
  • 00:49 Let's add another option of SUM, and let's add in MAX.
  • 00:56 The next thing we need to do is specify which one is the correct answer.
  • 01:01 And we do that simply using the check mark next to one of the options.
  • 01:05 So the answer to this question is, SUM, so let's click on the circle
  • 01:10 to mark that as correct and all of the others are incorrect.
  • 01:15 Now, notice again, when we hover our mouse over each of these answers
  • 01:19 to the right-hand side, we get an option to add a message.
  • 01:23 And this is a message that's going to pop up when that option is selected.
  • 01:27 So if we click on the Message icon, what I could say here is,
  • 01:32 if somebody selects this option, we can say incorrect, and
  • 01:37 then we can explain what this option does and why it's incorrect.
  • 01:42 So if this option is selected, they're going to get a message that says
  • 01:45 incorrect, COUNT will count the number of items in a list.
  • 01:49 And I can go through and I can add a message for each of these answers.
  • 01:53 And this is good, because it provides a little bit of detail and
  • 01:57 education if somebody selects the wrong answer.
  • 02:00 So this one is also incorrect,
  • 02:03 AVERAGE will find the average of a range of values in a list.
  • 02:08 The next one is correct.
  • 02:11 So we can say correct this time, SUM will add up a range of numbers.
  • 02:15 And then finally, let's just do one for MAX as well.
  • 02:18 This one is going to be incorrect.
  • 02:21 MAX will return the maximum value in a range.
  • 02:24 Now, something else that's different when we're creating a quiz as opposed to when
  • 02:29 we're creating a survey is that we can assign points to quiz questions.
  • 02:33 So if they get this question right, how many points are they going to achieve?
  • 02:38 So I'm going to say that for this question,
  • 02:40 you get 10 points if you choose the correct answer.
  • 02:44 Now, also notice with our little toggle sliders, if we were to toggle on multiple
  • 02:49 answers, that means that people can select more than one answer.
  • 02:53 And in order for them to achieve the full amount of points,
  • 02:56 they need to get both answers correct.
  • 02:59 Now, we're going to leave this on one answer.
  • 03:01 Notice we have a Maths slider,
  • 03:03 and we're going to be covering that a bit later on in this section.
  • 03:07 The question is required.
  • 03:08 If we click the three dots, we have our Shuffle options.
  • 03:11 So we could choose to shuffle those different options every time somebody
  • 03:15 loads the form.
  • 03:16 We could choose to display these as drop-down lists.
  • 03:18 We can add a subtitle and we can add branching.
  • 03:22 So when we click away, this is what the question looks like on the form.
  • 03:26 We can see that it's worth ten points, and we can see which answer is correct.
  • 03:31 Let's preview it and see what it looks like to our users.
  • 03:35 What Excel function would you use to add up a list of numbers, and
  • 03:38 then in brackets ten points.
  • 03:40 So if they were to select the wrong answer and submit the form,
  • 03:44 as soon as they view their results, you can see here it says,
  • 03:49 incorrect, you've achieved 0 out of 10 points.
  • 03:52 And then they can see the feedback underneath,
  • 03:55 COUNT will count the number of items in the list.
  • 03:58 So you can see how all of those options that we've set work together.
  • 04:03 If we go back into preview mode one more time and
  • 04:05 just take a look at it in the mobile view, that is what that's going to look like.

Lesson notes are only available for subscribers.

Gift this course