{"id":4569,"date":"2024-03-14T15:02:19","date_gmt":"2024-03-14T06:02:19","guid":{"rendered":"https:\/\/support.learningbox.online\/?post_type=how-to-use&#038;p=4569"},"modified":"2025-10-22T11:56:28","modified_gmt":"2025-10-22T02:56:28","slug":"creating-questions-in-excel","status":"publish","type":"how-to-use","link":"https:\/\/support.learningbox.online\/en\/how-to-use\/creating-questions-in-excel\/","title":{"rendered":"Creating problems in Excel"},"content":{"rendered":"<p class=\"wp-block-paragraph\">Learn how to create questions using spreadsheet software such as Microsoft Excel or Google Spreadsheet.<\/p>\n\n\n\n<h2 class=\"wp-block-heading is-style-default u-mb-ctrl u-mb-20 has-white-color has-black-background-color has-text-color has-background has-large-font-size\">creation procedure<\/h2>\n\n\n\n<p class=\"u-mb-ctrl u-mb-10 wp-block-paragraph\"><strong><span class=\"swl-fz u-fz-l\">01. First of all<\/span><\/strong><\/p>\n\n\n\n<p class=\"wp-block-paragraph\">In the first line of column A, enter \"#format:table\".<br>*Please note that if you do not describe it, it will not work correctly.<\/p>\n\n\n\n<figure class=\"wp-block-image size-full is-style-border\"><img loading=\"lazy\" decoding=\"async\" width=\"801\" height=\"298\" src=\"https:\/\/support.learningbox.online\/wp-content\/uploads\/how-to-use\/contents\/creating-questions-in-excel-01_225.jpg\" alt=\"\" class=\"wp-image-4580\" srcset=\"https:\/\/support.learningbox.online\/wp-content\/uploads\/how-to-use\/contents\/creating-questions-in-excel-01_225.jpg 801w, https:\/\/support.learningbox.online\/wp-content\/uploads\/how-to-use\/contents\/creating-questions-in-excel-01_225-300x112.jpg 300w, https:\/\/support.learningbox.online\/wp-content\/uploads\/how-to-use\/contents\/creating-questions-in-excel-01_225-768x286.jpg 768w, https:\/\/support.learningbox.online\/wp-content\/uploads\/how-to-use\/contents\/creating-questions-in-excel-01_225-18x7.jpg 18w\" sizes=\"auto, (max-width: 801px) 100vw, 801px\" \/><\/figure>\n\n\n\n<p class=\"u-mb-ctrl u-mb-10 wp-block-paragraph\"><strong><span class=\"swl-fz u-fz-l\">02. Enter option values<\/span><\/strong><\/p>\n\n\n\n<p class=\"wp-block-paragraph\">To set option values, enter them on the second and subsequent lines of column A.<br>This one is also always written after \"#\".<br>Please enter one option per line.<br>*For more information on option values, please refer to the \"Option Values\" section.<a href=\"https:\/\/quizgenerator.net\/%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\/%E3%82%AA%E3%83%97%E3%82%B7%E3%83%A7%E3%83%B3%E9%A0%85%E7%9B%AE%E4%B8%80%E8%A6%A7\/\" target=\"_blank\" rel=\"noreferrer noopener\">Options<\/a>.<\/p>\n\n\n\n<figure class=\"wp-block-image size-full is-style-border\"><img loading=\"lazy\" decoding=\"async\" width=\"803\" height=\"365\" src=\"https:\/\/support.learningbox.online\/wp-content\/uploads\/how-to-use\/contents\/creating-questions-in-excel-02_225.jpg\" alt=\"\" class=\"wp-image-4582\" srcset=\"https:\/\/support.learningbox.online\/wp-content\/uploads\/how-to-use\/contents\/creating-questions-in-excel-02_225.jpg 803w, https:\/\/support.learningbox.online\/wp-content\/uploads\/how-to-use\/contents\/creating-questions-in-excel-02_225-300x136.jpg 300w, https:\/\/support.learningbox.online\/wp-content\/uploads\/how-to-use\/contents\/creating-questions-in-excel-02_225-768x349.jpg 768w, https:\/\/support.learningbox.online\/wp-content\/uploads\/how-to-use\/contents\/creating-questions-in-excel-02_225-18x8.jpg 18w\" sizes=\"auto, (max-width: 803px) 100vw, 803px\" \/><\/figure>\n\n\n\n<p class=\"u-mb-ctrl u-mb-10 wp-block-paragraph\"><strong><span class=\"swl-fz u-fz-l\">03. Create the question<\/span><\/strong><\/p>\n\n\n\n<p class=\"wp-block-paragraph\">Then, in the lines below the option values, enter the question text, correct\/incorrect answers, etc.<br>Please refer to the image below and enter the information.<\/p>\n\n\n\n<figure class=\"wp-block-image size-large is-style-border\"><img decoding=\"async\" src=\"https:\/\/quizgenerator.net\/wp-content\/uploads\/2023\/12\/5f1c9fff36807f3d79d12cd7d9f04c64-1024x542.png\" alt=\"\"\/><\/figure>\n\n\n\n<p class=\"wp-block-paragraph\">To set multiple questions, enter one question on each line.<\/p>\n\n\n\n<figure class=\"wp-block-image size-large is-style-border\"><img decoding=\"async\" src=\"https:\/\/quizgenerator.net\/wp-content\/uploads\/2023\/12\/2cd0d94a66f3dc8dc42bf74a71060f66-1024x548.png\" alt=\"\"\/><\/figure>\n\n\n\n<p class=\"wp-block-paragraph\">When you have finished creating the problem, save the file.<\/p>\n\n\n\n<p class=\"u-mb-ctrl u-mb-10 wp-block-paragraph\"><span class=\"swl-inline-color has-swl-main-color\"><span class=\"swl-fz u-fz-l\"><span style=\"--the-icon-svg: url(data:image\/svg+xml;base64,PHN2ZyBoZWlnaHQ9IjFlbSIgd2lkdGg9IjFlbSIgeG1sbnM9Imh0dHA6Ly93d3cudzMub3JnLzIwMDAvc3ZnIiBhcmlhLWhpZGRlbj0idHJ1ZSIgdmlld0JveD0iMCAwIDQ4IDQ4Ij48cGF0aCBkPSJNMjQgMUMxMS4zIDEgMSAxMS4zIDEgMjRzMTAuMyAyMyAyMyAyMyAyMy0xMC4zIDIzLTIzUzM2LjcgMSAyNCAxem0wIDExLjJjMS45IDAgMy41IDEuNiAzLjUgMy41cy0xLjYgMy41LTMuNSAzLjUtMy41LTEuNi0zLjUtMy41IDEuNi0zLjUgMy41LTMuNXptNSAyMi42YzAgLjYtLjQgMS0xIDFoLThjLS42IDAtMS0uNC0xLTF2LTJjMC0uNi40LTEgMS0xaDEuNXYtNmwtMS44LTIuNGExIDEgMCAwIDEgLjgtMS42aDVjLjYgMCAxIC40IDEgMXY5SDI4Yy42IDAgMSAuNCAxIDF2MnoiPjwvcGF0aD48L3N2Zz4=)\" data-icon=\"LsInfo\" data-id=\"4\" aria-hidden=\"true\" class=\"swl-inline-icon\">\u2003<\/span><\/span><\/span><strong><span class=\"swl-fz u-fz-l\">Note<\/span><\/strong><\/p>\n\n\n\n<p class=\"wp-block-paragraph\">Japanese\/English templates can be downloaded below.<br>We hope you will take advantage of it.<\/p>\n\n\n\n<div class=\"wp-block-file\"><a href=\"https:\/\/support.learningbox.online\/wp-content\/uploads\/2024\/03\/quiz_format-1-1-1.xlsx\" class=\"wp-block-file__button wp-element-button\" download>Japanese Template<\/a><\/div>\n\n\n\n<div class=\"wp-block-file\"><a href=\"https:\/\/support.learningbox.online\/wp-content\/uploads\/2024\/03\/eng_sample_template-1.txt\" class=\"wp-block-file__button wp-element-button\" download>English Template<\/a><\/div>","protected":false},"excerpt":{"rendered":"<p>Microsoft Excel\u3084Google\u30b9\u30d7\u30ec\u30c3\u30c9\u30b7\u30fc\u30c8\u306a\u3069\u3001\u8868\u8a08\u7b97\u30bd\u30d5\u30c8\u3092\u4f7f\u7528\u3057\u3066\u554f\u984c\u3092\u4f5c\u6210\u3059\u308b\u65b9\u6cd5\u306b\u3064\u3044\u3066\u3054\u8aac\u660e\u3057\u307e\u3059\u3002 \u4f5c\u6210\u624b\u9806 01.\u307e\u305a\u306f\u3058\u3081\u306b A\u5217\u306e1\u884c\u76ee\u306b\u3001\u300c#format:table\u300d\u3068\u5165\u529b\u3057\u3066\u304f\u3060 [&hellip;]<\/p>\n","protected":false},"author":5,"featured_media":0,"parent":0,"menu_order":43,"template":"","meta":{"_acf_changed":false,"content-type":"","swell_btn_cv_data":"","slim_seo":{"title":"Creating Problems in Excel - How to Use learningBOX","description":"This guide explains how to create problems using spreadsheet software such as Microsoft Excel or Google Sheets. Creation Steps 01. Getting Started Enter \u201c#format:table\u201d in row 1 of Column A. *Please note that the formula will not work correctly if you do not enter this. 02. Entering Option Values Options"},"_slim_seo_primary_term_category-how-to-use":0,"footnotes":""},"category-how-to-use":[98],"class_list":["post-4569","how-to-use","type-how-to-use","status-publish","hentry","category-how-to-use-quiz-exam-quiz-exam"],"acf":[],"publishpress_future_action":{"enabled":false,"date":"2026-09-30 08:06:22","action":"change-status","newStatus":"draft","terms":[],"taxonomy":"category-how-to-use","extraData":[]},"publishpress_future_workflow_manual_trigger":{"enabledWorkflows":[]},"_links":{"self":[{"href":"https:\/\/support.learningbox.online\/en\/wp-json\/wp\/v2\/how-to-use\/4569","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/support.learningbox.online\/en\/wp-json\/wp\/v2\/how-to-use"}],"about":[{"href":"https:\/\/support.learningbox.online\/en\/wp-json\/wp\/v2\/types\/how-to-use"}],"author":[{"embeddable":true,"href":"https:\/\/support.learningbox.online\/en\/wp-json\/wp\/v2\/users\/5"}],"version-history":[{"count":31,"href":"https:\/\/support.learningbox.online\/en\/wp-json\/wp\/v2\/how-to-use\/4569\/revisions"}],"predecessor-version":[{"id":16345,"href":"https:\/\/support.learningbox.online\/en\/wp-json\/wp\/v2\/how-to-use\/4569\/revisions\/16345"}],"wp:attachment":[{"href":"https:\/\/support.learningbox.online\/en\/wp-json\/wp\/v2\/media?parent=4569"}],"wp:term":[{"taxonomy":"category-how-to-use","embeddable":true,"href":"https:\/\/support.learningbox.online\/en\/wp-json\/wp\/v2\/category-how-to-use?post=4569"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}