Locked lesson.
About this lesson
Add a Multiple Choice Quiz Question.
Exercise files
Download this lesson’s related exercise files.
3.02 create-quiz-questions - Exercise.docx43.7 KB 3.02 create-quiz-questions - Exercise solution .docx
90.1 KB
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.
- 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.