How to create quizzes with Excel
Microsoft Excel is a program produced by Microsoft, dedicated to the production and management of spreadsheets; it is part of the Microsoft Office personal productivity software suite and is available for Windows and Macintosh operating systems.
The first spreadsheet was made in 1978. Excel is currently the most-used spreadsheet. The extension .XLS, for versions from 97 to 2003 and .XLSX, since version 2007, identify most of the spreadsheets (in English spreadsheet) created with Excel (the MIME type of the files identified by this extension is typically application/vnd. Ms-excel).
Excel can import and export data in other formats, such as the format .CSV. Excel is an excellent program for creating spreadsheets and for monitoring information, but it is also useful for creating quizzes. This type of sheet can be used to create quizzes of all kinds, from school to small board games.
Asking questions and answers is also a good way to improve your skills. In this guide, you will find the right explanation on how to create quizzes with Excel. Let’s see it together!
Construction of the sheet
Open an empty spreadsheet in Excel, using column A for the question, column B for the answer, and column C for the grade of the answers. Enter the title of the quiz at the top of the first line. These were just the preliminary operations, to shape the quiz. Now let’s move on to the actual construction. Immediately below in the first column, you have the list of questions.
Put the question at the top and in the lines below the list of answers associated with a letter (A, B, C, etc.) or a number. Once you have finished the questions, set the cell where to enter the answers. The fundamental thing is that this cell functions as a drop-down menu; to do this, you must create the list of letters (or numbers) associated with the answers in a separate section of the sheet. To create the cell with a drop-down menu, select the ” Validate data ” and ” Allow ” items in the ” Data ” section.
Calculation system
If you also want to create an automatic calculation system, enter the letter (or number) corresponding to the correct answer in the cells next to those containing the answer choices. The column where these cells are located must be hidden at the end of the job.
Enter the ” If ” function to allow the question score to be calculated automatically. The function must be structured with the equality between the answer cell given by the quiz user and the correct answer cell as a condition. This system will allow the software to automatically connect the answers and the questions to signal to whoever is completing the test if his answer is the correct one.
With small extensions searchable online, you can embellish the card with different lighting or with animations. If you need a minimal visual impact, it is always advisable to leave the default Excel layout unchanged.
Result
If the condition is true, the function must result in the score associated with the correct answer (vice versa, it will be put zero if the condition is not respected). In the bottom row, calculate the sum of the cells in the last column to get the total score.
This part relating to the calculation of the score must be hidden, and the sheet must be protected. The fact that the calculation is hidden will allow for a much clearer and cleaner form. If, on the contrary, you are still in the test phase of the quiz, you can leave the spreadsheet in plain sight, to facilitate the control of the sections. All that remains is to wish you a good job!
