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?’.
Table of Contents
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.
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.
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.
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”)
Now, you will observe the result as ‘you scored 0’. It is because no one has answered it yet.
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”)
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.
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.
In this way, following the above-mentioned steps, you can easily create an automated quiz in Microsoft Excel.