Quiz

This checker is a pop quiz. The results show whether each answer was Correct or Incorrect, and calculates a total score.

When should I use this template?

When we want to calculate a score based on the number of Correct/Incorrect answers.

Template walkthrough

Context

We are testing users on some math questions, and some multiple-choice questions. In the results, we want to show whether the answer to each question is Correct/Incorrect, and calculate their total score out of 100.

Step 1: Set questions

Here's what it should look like:

Step 2: Set answer logic

  1. Set correct answer in IF statement

  2. Set "Correct" outcome in THEN statement

  3. Set "Incorrect" outcome in ELSE statement

For math questions, because the answers are numbers, we don't need to put them in quotes. However we still need to use the double equal operator (==).

N1 == 10

For multiple choice questions, because the answers are text, we'll need to put the answer in quotes (") as well as use the double equal operator (==).

R5 == "Weasley Joke Emporium"

Step 3: Set score logic

Let's count how many questions will return a Correct result. We can use a countif function to do this.

  1. Count how many answers are Correct

  2. Calculate it into a score out of 100

Since O1 to O7 will give the result of each question, we'll set that as our array. Our condition is to count how many will return "Correct".

countif([O1,O2,O3,O4,O5,O6,O7],"correct")

Arrays must be defined with square brackets [ ], with inputs separated by a comma.

Now that we've got a count of how many out of 7 are Correct, let's change it into a score out of 100. We'll also use the round function to round it off to an integer.

round((O8/7)*100)

Step 4: Preview

Let's Save draft then Preview our checker. View the questions and result format below.

Last updated