{"id":13734,"date":"2020-01-31T14:04:19","date_gmt":"2020-01-31T05:04:19","guid":{"rendered":"https:\/\/quizgenerator.net\/?p=13734"},"modified":"2020-01-31T14:04:19","modified_gmt":"2023-04-07T07:21:56","slug":"blog_excel-quiz","status":"publish","type":"post","link":"https:\/\/quizgenerator.net\/en\/2020\/01\/blog_excel-quiz\/","title":{"rendered":"How to use Excel to publish fill-in-the-blank questions on the web"},"content":{"rendered":"<p><img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/quizgenerator.net\/wp-content\/uploads\/2020\/01\/quiz1450-1024x282.jpg\" alt=\"Quiz Creation Tools\" width=\"1024\" height=\"282\" class=\"aligncenter size-large wp-image-13699\" srcset=\"https:\/\/quizgenerator.net\/wp-content\/uploads\/2020\/01\/quiz1450-1024x282.jpg 1024w, https:\/\/quizgenerator.net\/wp-content\/uploads\/2020\/01\/quiz1450-300x83.jpg 300w, https:\/\/quizgenerator.net\/wp-content\/uploads\/2020\/01\/quiz1450-768x212.jpg 768w, https:\/\/quizgenerator.net\/wp-content\/uploads\/2020\/01\/quiz1450.jpg 1450w\" sizes=\"auto, (max-width: 1024px) 100vw, 1024px\" \/><\/p>\n<p>This is Kitaoka \ud83c\udf4e, our marketing manager. In this article, we will talk about our quiz creation tool<strong>&nbsp;QuizGenerator<\/strong>and<strong>Excel (excel) file<\/strong>using the<span style=\"border-bottom:solid 2px red;\"><strong>How to create fill-in-the-blank questions that can be easily published on the web<\/strong><\/span>We are pleased to introduce the<\/strong><\/span><br \/>\nWith this quiz creation tool, you can easily create a quiz on the Internet.<span class=\"yellowline\"><strong>WEB Quiz<\/strong><\/span>It is possible to introduce and publish Please refer to this article and try how to make and operate the web quiz.<\/p>\n<p class=\"mokujimidasi\">Contents<\/p>\n<ul class=\"mokuji\">\n<li>1. use QuizGenerator and Excel to make a web quiz!<\/li>\n<li>2. let's make a fill-in-the-blank question using Excel.<\/li>\n<li>3. use a conversion tool to turn your quiz into a web quiz<\/li>\n<li>4. summary<\/li>\n<\/ul>\n<p>&nbsp;<\/p>\n<h2><strong>Using QuizGenerator and Excel, you can make a web quiz!<\/strong><\/h2>\n<div class=\"box16\">\n<p><a href=\"https:\/\/quizgenerator.net\/wp-content\/uploads\/2020\/01\/09469f8b0b89895f44c1f888f4d98415.gif\" rel=\"noopener noreferrer\" target=\"_blank\" data-rel=\"lightbox-image-0\" data-magnific_type=\"image\" data-rl_title=\"\" data-rl_caption=\"\" title=\"\"><img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/quizgenerator.net\/wp-content\/uploads\/2020\/01\/90c44c501ead248a9948e1bb6a2aef3d.gif\" alt=\"Fill-in-the-blank quiz using Excel\" width=\"1228\" height=\"426\" class=\"aligncenter size-full wp-image-13747\" \/><\/a><\/p>\n<\/div>\n<p>If you have learning materials or interesting quizzes but have no idea how to use them! Why don't you use our quiz generator to publish your quizzes on the Internet?<br \/>\nWhy don't you convert your paper-based quizzes and learning materials to the web and deliver them to people around the world who are connected to the Internet and who are having trouble learning? Quizzes created with QuizGenerator can be enjoyed on any device, including PCs, smartphones, and tablets.<\/p>\n<div class=\"box27\">\n    <span class=\"box-title\">Do you have any of these problems?<\/span><\/p>\n<p><strong>I want to set up a quiz on the web: \u3001\u3001\u3001\u3001\u3001<\/strong><br \/>\n\u2192 I don't know how to do it in the first place. Is it going to be difficult to post quizzes online?<br \/>\n<strong>I want to use the quiz to promote my company or school. \u3001\u3001\u3001\u3001\u3001<\/strong><br \/>\n\u2192 I gave up on advertising because it costs a lot of money and it's a hurdle for personal use.<br \/>\n<strong>We want to focus on new employee training and employee education. \u3001\u3001\u3001\u3001\u3001<\/strong><br \/>\n\u2192 We rely only on existing training materials, and internal training has become chronic without progress.<\/p>\n<\/div>\n<p><strong>If you are in charge of these problems, our e-learning system can solve the above problems!<\/strong><br \/>\nEven if you are not used to operating a computer, there is no problem. The process is quite simple!<br \/>\nThere are no complicated operations. All you have to do is type in questions and answers in the designated areas according to the specified format, and you can easily create quizzes as you like. What's more!<span style=\"color:red;font-weight:bold;\">QuizGenerator is available for free of charge.<\/span><\/p>\n<p>&nbsp;<\/p>\n<h3><span style=\"border-bottom:solid 2px red;\"><strong>Click here to see the features of \u25bcQuizGenerator<\/strong><\/span><\/h3>\n<p class=\"well2\"><a href=\"https:\/\/quizgenerator.net\/en\/%e3%82%af%e3%82%a4%e3%82%ba%e3%82%b8%e3%82%a7%e3%83%8d%e3%83%ac%e3%83%bc%e3%82%bf%e6%90%ad%e8%bc%89%e6%a9%9f%e8%83%bd%e3%81%a8%e5%88%a9%e7%94%a8%e6%89%8b%e9%a0%86\/%e5%95%8f%e9%a1%8c%e5%bd%a2%e5%bc%8f%e4%b8%80%e8%a6%a7\/\" rel=\"noopener noreferrer\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/learningbox.online\/wp-content\/uploads\/2020\/01\/7c03a367cda8796fb145005cd03fac5b-1024x378.png\" alt=\"E-learning - Quiz\" width=\"1024\" height=\"378\" class=\"aligncenter size-large wp-image-30448\" \/><\/a><strong>QuizGenerator allows you to create quizzes from more than 12 types of question formats and publish them on the web!<\/strong><br \/>\n<strong>Web quiz can be easily created in 3 steps.<\/strong><br \/>\n<strong>The quizzes you create can be centrally managed by our e-learning system (learningBOX).<\/strong>\n<\/p>\n<p>......QuizGenerator is well suited for delivering quizzes to an unspecified number of users, but<span style=\"border-bottom:solid 2px red;\">If you're using it for in-house training, certification exams, or school<a href=\"https:\/\/learningbox.online\/en\/\" rel=\"noopener noreferrer\" target=\"_blank\"><strong>&nbsp;learningBOX<\/strong><\/a>is more recommended.<\/span>With learningBOX, you can easily re-edit the quizzes you create in your browser. You can offer course learning to your learners, manage their grades, retake tests, notify them of their success, and much more! If you have trouble finding a place to put your quizzes, please use learningBOX.<\/p>\n<p>\u25bc<strong>Analyzing &amp; monitoring<\/strong>\u00a0and<strong>learner management<\/strong>if I do (something)<strong>E-learning system learningBOX<\/strong>Come in!<br \/>\n<a href=\"https:\/\/learningbox.online\/en\/\" rel=\"noopener noreferrer\" target=\"_blank\"><img decoding=\"async\" src=\"https:\/\/quizgenerator.net\/wp-content\/uploads\/CreateQuiz\/en_infospaceuegazo.jpg\"><\/a><\/p>\n<p>&nbsp;<\/p>\n<h2><strong>Let's create a fill-in-the-blank question using Excel.<\/strong><\/h2>\n<div class=\"box16\">\n<p><a href=\"\/\/quizgenerator.net\/wp-content\/uploads\/2020\/01\/44a88735cd0c40eafd88d658698cf1c6.gif\" rel=\"noopener noreferrer\" target=\"_blank\" data-rel=\"lightbox-image-1\" data-magnific_type=\"image\" data-rl_title=\"\" data-rl_caption=\"\" title=\"\"><img decoding=\"async\" src=\"https:\/\/quizgenerator.net\/wp-content\/uploads\/2020\/01\/0c33e2848377c5062b4dc279eb2d3464-1.gif\" alt=\"Excel Web Quiz\" class=\"aligncenter size-full wp-image-13856\" \/><\/a><\/p>\n<\/div>\n<p>\u25bcQuizGenerator is an application of the <a href=\"https:\/\/quizgenerator.net\/en\/%e3%82%af%e3%82%a4%e3%82%ba%e3%82%b8%e3%82%a7%e3%83%8d%e3%83%ac%e3%83%bc%e3%82%bf%e3%81%a7%e3%82%af%e3%82%a4%e3%82%ba%e3%82%92%e4%bd%9c%e3%82%8b\/%e3%83%86%e3%82%ad%e3%82%b9%e3%83%88%e3%81%a7%e5%95%8f%e9%a1%8c%e3%82%92%e3%81%a4%e3%81%8f%e3%82%8b\/\" rel=\"noopener noreferrer\" target=\"_blank\">text file<\/a>\u30fb<a href=\"https:\/\/quizgenerator.net\/en\/%e3%82%af%e3%82%a4%e3%82%ba%e3%82%b8%e3%82%a7%e3%83%8d%e3%83%ac%e3%83%bc%e3%82%bf%e3%81%a7%e3%82%af%e3%82%a4%e3%82%ba%e3%82%92%e4%bd%9c%e3%82%8b\/csv%e3%81%a7%e5%95%8f%e9%a1%8c%e3%82%92%e4%bd%9c%e3%82%8b\/\" rel=\"noopener noreferrer\" target=\"_blank\">Excel<\/a>\u30fb<a href=\"https:\/\/quizgenerator.net\/en\/%e3%82%af%e3%82%a4%e3%82%ba%e3%82%b8%e3%82%a7%e3%83%8d%e3%83%ac%e3%83%bc%e3%82%bf%e3%81%a7%e3%82%af%e3%82%a4%e3%82%ba%e3%82%92%e4%bd%9c%e3%82%8b\/%e5%95%8f%e9%a1%8c%e4%bd%9c%e6%88%90%e3%83%95%e3%82%a9%e3%83%bc%e3%83%a0%e3%81%a7%e5%95%8f%e9%a1%8c%e3%82%92%e3%81%a4%e3%81%8f%e3%82%8b\/\" rel=\"noopener noreferrer\" target=\"_blank\">Quiz\/exam creation form<\/a> You can make a quiz from three of the following. This time, I'd like to make a fill-in-the-blank question using Excel, which is in almost every computer.<\/p>\n<p>\u25bc Enter the text of the question, the format of the question, and the answer according to the following format that we will introduce. Please see the sample example (fill-in-the-blank question) below.<\/p>\n<p>Click here to download a sample \u2192.<a  data-e-disable-page-transition=\"true\" class=\"download-link\" title=\"\" href=\"https:\/\/quizgenerator.net\/en\/download\/12172\/?tmstv=1777437580\" rel=\"nofollow\" id=\"download-link-12172\" data-redirect=\"false\" >\n\twordbank-1.xlsx<\/a>\n<\/p>\n<blockquote>\n<table style=\"border-collapse: collapse; width: 100.957%; height: 210px;\" border=\"1\">\n<tbody>\n<tr style=\"height: 30px;\">\n<td style=\"width: 3.93675%; height: 30px;\"><\/td>\n<td style=\"width: 29.3967%; height: 30px;\">A<\/td>\n<td style=\"width: 9.86348%; height: 30px;\">b<\/td>\n<td style=\"width: 12.9359%; height: 30px;\">C<\/td>\n<td style=\"width: 14.6915%; height: 30px;\">d<\/td>\n<td style=\"width: 12.7347%; height: 30px;\">e<\/td>\n<td style=\"width: 16.4411%; height: 30px;\">f<\/td>\n<\/tr>\n<tr style=\"height: 23px;\">\n<td style=\"width: 3.93675%; height: 23px;\">1<\/td>\n<td style=\"width: 29.3967%; height: 23px;\">#format:table<\/td>\n<td style=\"width: 9.86348%; height: 23px;\"><\/td>\n<td style=\"width: 12.9359%; height: 23px;\"><\/td>\n<td style=\"width: 14.6915%; height: 23px;\"><\/td>\n<td style=\"width: 12.7347%; height: 23px;\"><\/td>\n<td style=\"width: 16.4411%; height: 23px;\"><\/td>\n<\/tr>\n<tr style=\"height: 10px;\">\n<td style=\"width: 3.93675%; height: 10px;\">2<\/td>\n<td style=\"width: 29.3967%; height: 10px;\">#messages_intro:fill-in-the-blank questions<\/td>\n<td style=\"width: 9.86348%; height: 10px;\"><\/td>\n<td style=\"width: 12.9359%; height: 10px;\"><\/td>\n<td style=\"width: 14.6915%; height: 10px;\"><\/td>\n<td style=\"width: 12.7347%; height: 10px;\"><\/td>\n<td style=\"width: 16.4411%; height: 10px;\"><\/td>\n<\/tr>\n<tr style=\"height: 30px;\">\n<td style=\"width: 3.93675%; height: 30px;\">3<\/td>\n<td style=\"width: 29.3967%; height: 30px;\">#shuffle_questions:true<\/td>\n<td style=\"width: 9.86348%; height: 30px;\"><\/td>\n<td style=\"width: 12.9359%; height: 30px;\"><\/td>\n<td style=\"width: 14.6915%; height: 30px;\"><\/td>\n<td style=\"width: 12.7347%; height: 30px;\"><\/td>\n<td style=\"width: 16.4411%; height: 30px;\"><\/td>\n<\/tr>\n<tr style=\"height: 30px;\">\n<td style=\"width: 3.93675%; height: 30px;\">4<\/td>\n<td style=\"width: 29.3967%; height: 30px;\">#mode:master<\/td>\n<td style=\"width: 9.86348%; height: 30px;\"><\/td>\n<td style=\"width: 12.9359%; height: 30px;\"><\/td>\n<td style=\"width: 14.6915%; height: 30px;\"><\/td>\n<td style=\"width: 12.7347%; height: 30px;\"><\/td>\n<td style=\"width: 16.4411%; height: 30px;\"><\/td>\n<\/tr>\n<tr style=\"height: 27px;\">\n<td style=\"width: 3.93675%; height: 27px;\">5<\/td>\n<td style=\"width: 29.3967%; height: 27px;\">#lang:en<\/td>\n<td style=\"width: 9.86348%; height: 27px;\"><\/td>\n<td style=\"width: 12.9359%; height: 27px;\"><\/td>\n<td style=\"width: 14.6915%; height: 27px;\"><\/td>\n<td style=\"width: 12.7347%; height: 27px;\"><\/td>\n<td style=\"width: 16.4411%; height: 27px;\"><\/td>\n<\/tr>\n<tr style=\"height: 30px;\">\n<td style=\"width: 3.93675%; height: 30px;\">6<\/td>\n<td style=\"width: 29.3967%; height: 30px;\">1) Read the examples and rearrange them in the correct order.&lt;br&gt;I love music.&quot;&lt;br&gt;{1}{2}{3}<\/td>\n<td style=\"width: 9.86348%; height: 30px;\">wordbank:<\/td>\n<td style=\"width: 12.9359%; height: 30px;\">I<\/td>\n<td style=\"width: 14.6915%; height: 30px;\">like<\/td>\n<td style=\"width: 12.7347%; height: 30px;\">music<\/td>\n<td style=\"width: 16.4411%; height: 30px;\"><\/td>\n<\/tr>\n<tr>\n<td style=\"width: 3.93675%;\">7<\/td>\n<td style=\"width: 29.3967%;\">2) Read the examples and rearrange them in the correct order.&lt;br&gt;'The ball is under the table.'&lt;br&gt;There {1} a boll{2}the{3}<\/td>\n<td style=\"width: 9.86348%;\">wordbank:<\/td>\n<td style=\"width: 12.9359%;\">is<\/td>\n<td style=\"width: 14.6915%;\">under<\/td>\n<td style=\"width: 12.7347%;\">table<\/td>\n<td style=\"width: 16.4411%;\">are<\/td>\n<\/tr>\n<tr>\n<td style=\"width: 3.93675%;\">8<\/td>\n<td style=\"width: 29.3967%;\">3) Please rearrange the sentences so that they are correct regarding Article 25 of the Japanese Constitution.&lt;br&gt;&quot;Every {1} has the right to live a {2} and {3} life of {4}.&quot;<\/td>\n<td style=\"width: 9.86348%;\">wordbank:<\/td>\n<td style=\"width: 12.9359%;\">people<\/td>\n<td style=\"width: 14.6915%;\">health<\/td>\n<td style=\"width: 12.7347%;\">cultural<\/td>\n<td style=\"width: 16.4411%;\">the lowest degree (possible, allowable, etc.)<\/td>\n<\/tr>\n<tr>\n<td style=\"width: 3.93675%;\">9<\/td>\n<td style=\"width: 29.3967%;\">4) Kinkakuji Temple was built in the {1} era by {2} the third shogun.<\/td>\n<td style=\"width: 9.86348%;\">wordbank:<\/td>\n<td style=\"width: 12.9359%;\">Muromachi (era 1392-1573, or 1333-1573, or 1336-1573)<\/td>\n<td style=\"width: 14.6915%;\">Ashikaga Yoshimitsu<\/td>\n<td style=\"width: 12.7347%;\">Kamakura<\/td>\n<td style=\"width: 16.4411%;\">Ashikaga Yoshimasa (Japanese military governor)<\/td>\n<\/tr>\n<tr>\n<td style=\"width: 3.93675%;\">10<\/td>\n<td style=\"width: 29.3967%;\">5) Rearrange the carbon so that it burns and becomes carbon dioxide.&lt;br&gt;{1}+{2}&rarr;{3}<\/td>\n<td style=\"width: 9.86348%;\">wordbank:<\/td>\n<td style=\"width: 12.9359%;\">2H<sub>2<br \/>\n<\/sub>.<\/td>\n<td style=\"width: 14.6915%;\">0<sub>2<\/p>\n<p><\/sub>.<\/td>\n<td style=\"width: 12.7347%;\">2H<sub>2<\/p>\n<p><\/sub>O<\/td>\n<td style=\"width: 16.4411%;\">indecent<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/blockquote>\n<div class=\"box28\">\n    <span class=\"box-title\">Click here for points<\/span><\/p>\n<p>The first line, starting with #, is the configuration for the whole question. #format:table in the first line declares that the question data should be written in a tabular format. 5 onwards, each line corresponds to a question. From the fifth line onwards, each line corresponds to a question. Each line contains the question text, \"wordbank:\", the correct answer in order starting from {}, and dummy choices separated by tabs.<br \/>\nIn the following example, the question text for the first question is \"Read the example sentences and rearrange them in the correct order: 'I like music' \u2192 {1}{2}{3}<br \/>\nThe correct answer choices are {1} for \"I\", {2} for \"like\", and {3} for \"music\". *<strong>br<\/strong>means a new line.<strong>sub<\/strong>displays the text as a subscript.<\/p>\n<\/div>\n<p>&nbsp;<\/p>\n<h2><strong>Turn your quiz into a web quiz using a conversion tool<\/strong><\/h2>\n<p class=\"well2\">\nSelect the question data you have created and click the \"Convert\" button to generate a quiz player.<br \/>\n<iframe loading=\"lazy\" style=\"width: 500px; height: 240px;\" src=\"\/quizgen5.6.17\/\" width=\"320\" height=\"240\" frameborder=\"0\"><span data-mce-type=\"bookmark\" style=\"display: inline-block; width: 0px; overflow: hidden; line-height: 0;\" class=\"mce_SELRES_start\"><\/span><span data-mce-type=\"bookmark\" style=\"display: inline-block; width: 0px; overflow: hidden; line-height: 0;\" class=\"mce_SELRES_start\"><\/span><\/iframe>\n<\/p>\n<p><strong>\u25bc Limited release<\/strong>\u3000\u2192 Only people who know the URL can view the quiz. If you copy and paste the embedding tag (IFrame), you can put the quiz you made on your blog or website.<\/p>\n<p><h3><strong>A fill-in-the-blank quiz created in Excel<\/strong> <\/h3>\n<div>&nbsp;&nbsp;This question is to fill in the blank in the sentence with words.<\/div>\n<p class=\"player-emb\">\n<div class=\"player-emb-menu translation-block\"><strong>Download<\/strong>: <a href=\"https:\/\/quizgenerator.net\/en\/res5-16-4\/quiz_en.zip\/\">source file<\/a>, <a href=\"https:\/\/quizgenerator.net\/en\/res5-16-4\/quiz_quiz_en.zip.zip\/\" target=\"_self\">converted file<\/a>\u3000\n    <a href=\"https:\/\/quizgenerator.net\/en\/res5-16-4\/quiz_quiz_en.zip\/\" target=\"_blank\">Open in a new window<\/a><br><\/div>\n<iframe src=\"\/res8.0.0\/quiz_y7.txt\/\" frameborder=\"1\" \nstyle=\"width: 100%; height: 720px;\"\nclass=\"embed54\"\nscrolling=\"no\"><\/iframe>\n\n<style>\n\t\/\/ iframe.embed{\n\t\/\/ \tborder: 2px #337ab7 dashed;\n\t\/\/ \tbox-shadow: 5px 5px 5px rgba(0,0,0,0.15);\n\t\/\/ }\n\tiframe.embed54{\n\t\tborder: 2px #FFF;\n\t}\n<\/style>\n<\/p><br \/>\n&nbsp;<\/p>\n<h2><strong>Summary<\/strong><\/h2>\n<p>In this article, we introduced how to create fill-in-the-blank questions that can be easily published on the web using our quiz generator and Excel file. With QuizGenerator, you can create and publish a wide variety of quizzes on the web. If you have learning materials or interesting quizzes, but are having trouble finding a way to use them! Why don't you publish your quizzes on the Internet using our QuizGenerator? QuizGenerator is a web service that you can use for free. QuizGenerator is a web service that you can use for free, so why don't you take this opportunity to make a quiz? Thank you for your cooperation in this article.<\/p>","protected":false},"excerpt":{"rendered":"My name is \ud83c\udf4e Kitaoka and I am in charge of marketing. In this article, I'll show you how to create a quiz using our QuizGenerator and an excel file.","protected":false},"author":13,"featured_media":13916,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"_acf_changed":false,"content-type":"","_lmt_disableupdate":"yes","_lmt_disable":"","vkexunit_cta_each_option":"","footnotes":""},"categories":[129],"tags":[],"class_list":["post-13734","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-quizgenerator"],"acf":[],"modified_by":"i.hirota","_links":{"self":[{"href":"https:\/\/quizgenerator.net\/en\/wp-json\/wp\/v2\/posts\/13734","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/quizgenerator.net\/en\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/quizgenerator.net\/en\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/quizgenerator.net\/en\/wp-json\/wp\/v2\/users\/13"}],"replies":[{"embeddable":true,"href":"https:\/\/quizgenerator.net\/en\/wp-json\/wp\/v2\/comments?post=13734"}],"version-history":[{"count":117,"href":"https:\/\/quizgenerator.net\/en\/wp-json\/wp\/v2\/posts\/13734\/revisions"}],"predecessor-version":[{"id":13926,"href":"https:\/\/quizgenerator.net\/en\/wp-json\/wp\/v2\/posts\/13734\/revisions\/13926"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/quizgenerator.net\/en\/wp-json\/wp\/v2\/media\/13916"}],"wp:attachment":[{"href":"https:\/\/quizgenerator.net\/en\/wp-json\/wp\/v2\/media?parent=13734"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/quizgenerator.net\/en\/wp-json\/wp\/v2\/categories?post=13734"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/quizgenerator.net\/en\/wp-json\/wp\/v2\/tags?post=13734"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}