How to Create an Automated Quiz in Microsoft Excel

Microsoft Excel is a very useful tool for users. Further, it is efficient for graph tables & calculation purposes. In addition, you can make important documents with this feature. If you are a professional teacher or a guide, this is very useful for you. Thus, you can create an automated quiz for the students easily. This is a very special feature of MS Excel. But, many users don’t have any idea about ‘How to Create an Automated Quiz in Microsoft Excel?’. No need to worry at all. We are present here for you people. We are providing detailed information related to this topic. This will help you in many ways. We have also covered the article on ‘How to Use the CHOOSE Function in Microsoft Excel‘. So, let’s take a ride at ‘How to Create an Automated Quiz in Microsoft Excel?’.

How to Create an Automated Quiz in Microsoft Excel?

If you need the quiz regularly, you must go this way. Moreover, there is no need for any third-party software for this. You will use the built-in feature for this. We are delivering here a tutorial ‘How to Create an Automated Quiz in Microsoft Excel?’. We assure you that this data will be beneficial for you in many ways. You will have a quality experience with this operation. It will lead to an innovative & powerful methodology for that. Thus, let’s start this amazing journey here.

Process Used to Create an Automated Quiz in Microsoft Excel

There is a specific process used for this purpose. So, simply follow the steps below to do so.

1 ) Create a Quiz

The very first thing is to open the MS Excel document. Then, add the multiple-choice questions here. Let’s suppose we add 3 questions with the options. Further, on the right-side section of the screen, provide the window for the answers.

How to Create an Automated Quiz in Microsoft Excel step 1

2 ) Choose the Second Sheet

After that, you should choose the second sheet to add the answers. So, on the bottom side of the screen, there are the sheet numbers available. Choose the ‘Sheet 2’ to proceed ahead.

sheet selection in Excel

3 ) Create an Answer Sheet

In addition to the above, now, create an answers sheet for the questions on sheet 1. So, fill the boxes with correct answers.

answer sheet creation in Excel

4 ) Add the Formula

Now, you should select the column ‘C’. Then, add the following formula in the specified section.

=IF(Sheet1!J2=Sheet2!B2, “you scored 0″,”you scored 1”)

Formula addition in Excel sheet

Now, you will observe the result as ‘you scored 0’. It is because no one has answered it yet.

Excel sheet operation window

Then, keep the cursor on the right-bottom corner of the cell. Drag it down up to the C4 cell. This will represent the score in that section.

5 ) Score Calculation

Now, in the C6 cell you should calculate the score. Add the following formula in the formula section.

=COUNTIF(C2:C5, “you scored 1”)

score calculation window

Thus, the quiz is ready for giving.

6 ) Hiding the Answers

Further, if you want to hide the answers then you can. So, select ‘column B’ of the answers. Right-click o the same & choose the ‘Hide’ option from the list of various options available.

answer hiding window

7 ) Protecting the Sheet

You can also protect the sheet by providing the password. Thus, right-click on Sheet 2 & choose the ‘Protect Sheet’ option. Then create a password for this & click on the ‘Ok’ button.

sheet protection window

In this way, following the above-mentioned steps, you can easily create an automated quiz in Microsoft Excel.

Leave a Comment