How to create a Quiz in Excel

Download PC Repair Tool to chop-chop find & ready Windows errors automatically

If y'all are a instructor, yous have to create quizzes for students on a regular basis. Many gratis quiz maker software are as well available merely it tin can be risky to install them on your PC if they are not downloaded from official or trusted websites. Do you lot know, you can create automated quizzes without installing 3rd-party software on your PC? In its article, we will show you the process to create an automated quiz in Microsoft Excel.

How to create a Quiz in Excel

Hither, we volition create all multiple choice questions in sheet ane and brand an answer canvas in canvass 2. To automate the quiz, we volition write formulae in sheet 2. Let'south see the process.

1] Launch Excel and write multiple option questions in canvas i. Here, nosotros have merged some cells using the "Merge and Center" option. See the below screenshot.

2] Now create a new sheet by clicking the "Plus" icon adjacent to sheet 1.

three] You take to write the right answers in sheet two.

4] At present, we volition automate the quiz past writing the formulae in sheet two. Write the following formula in column C of sheet 2.

=IF(Sheet1!J2=Sheet2!B2, "you scored 0","y'all scored one")

Please view the cell addresses carefully in the above formula, where J2 indicates the jail cell of canvass 1 in which answer to the question number one is to exist written. B2 indicates the cell of sheet 2 in which we have written the correct respond to question 1. Nosotros are getting the value "you scored 0" by default because initially, no student has attempted the test. You accept to write the correct jail cell accost otherwise you will get an mistake.

five] At present, drag the selected cell to the last cell. This will copy and paste the formula to all the empty cells.

6] Now, we have to enter a formula to calculate the score. For this, write the following formula to jail cell C6. You tin can select any cell to summate the score.

=COUNTIF(C2:C5, "you scored 1")

In the above formula, C2:C5 indicates the range of the number of questions. We have a total of iv questions, therefore, we accept selected this range.

The automated quiz is ready. But y'all have to protect canvass ii then that no student can edit the values or see the correct answers. For this, nosotros will hide the cavalcade of right answers and protect the sheet with a password. To hide column B, select it, correct-click on it and then select "Hibernate."

To add together password protection to sheet 2, right-click on it, select "Protect sheet," create a password and click OK.

This is how you can create an automated quiz in MS Excel by using formulae.

Permit us know if you accept any questions.

Read: What is the maximum number of columns & rows in Excel.

Nishant is a tech enthusiast who loves writing about technology and gadgets. He has completed B.Tech. Autonomously from writing, he likes to spend his time on his plantation.