Create a quiz in Excel
Create a quiz in Excel
Microsoft Excel and Google Spreadsheet are available.
This page explains how to create a quiz using Excel.
1. Create a problem
Problems can be created from a spreadsheet.
The template can be downloaded from
(*Please note that the more questions you have, the longer it will take when using the conversion tool and the uploader.)
Japanese: format English: format
2. the procedures and rules for creating questions
-
- Add#format:tablein column A. If this description is missing, it will not work properly.
column A column B column C column D column E #format:table - To add other options in column A. Enter them in line 2, 3 or more if desire.
Options: Roman characters starting with #column A column B column C column D column E #format:table #shuffle_questions:true - Enter a Quiz sentence in column A following the options, a Quiz format in B, a correct answer in C, and incorrect answers in D and beyond.
column A column B column C column D column E #format:table #shuffle_questions:true Quiz sentence Quiz format Correct answer Incorrect answer 1 Incorrect answer 2 Dry ice is the solid form of sa: Carbon dioxide Oxygen Nitrogen - If you start a new line, it will be recognized as the next quiz.
column A column B column C column D column E #format:table #shuffle_questions:true Dry ice is the solid form of sa: Carbon dioxide Oxygen Nitrogen What is the capital city in Japan? sa: Tokyo Osaka Osaka When all questions are completed, save the file.
3. generate quizzes using the conversion tool
Select the created question data and click the "Convert" button to generate the quiz player.
For more information on the process of conversion, see "Conversion ToolPlease refer to the page "3.
You can check the contents of the quiz you have created by clicking on the menu button below.
Preview → Displays the conversion result.
Download → Download the conversion results.
Limited publication → publish only to those who know the URL.
General Release → Open to the public on the QuizGenerator website.
*Copy and paste the tag (IFrame) for embedding the quiz for limited public use, and you can put the quiz you created on your blog or website.FAQ
When entering English characters, the first letter is capitalized.
Move the mouse cursor over the cell that will be capitalized and right-click>Format Cells.
Next, select a string from the classification (C) and click the OK button.
- Add#format:tablein column A. If this description is missing, it will not work properly.