Quiz Excel (XLSX) export guide

QuizGen exports one question per row, with columns for the question, choices, answer, points, and explanation. The questions can be organized and edited in Excel.

The sample quiz covers the input, hidden layers, and output of a digit-recognition neural network. It illustrates the column structure and answer formats.

Published Updated

Sample workbook structure

Worksheet
Sheet1, one sheet
Columns
A–L, 12 columns
Rows
Header in row 1; 10 questions in rows 2–11
Export labels
2 multiple choice, 2 true/false, 6 essay

XLSX column structure

The first row contains column headers.

XLSX column structure
Excel columnColumn headerContents
A문제유형Question type: 객관식 (multiple choice), 참거짓 (true/false), or 에세이 (essay).
B명칭Quiz title, repeated for every question in this file.
C질문Question text.
D–I보기1, 보기2, 보기3, 보기4, 보기5, 보기6Multiple-choice options in order. Unused cells are empty; all six cells are empty for other question types.
J정답Correct option number, 1 or 0 for true/false, or answer text for essay-labelled questions.
K배점Points stored as a number. This sample uses 1 and 10.
L정답해설Explanation of the answer.

The exported workbook’s rows and columns follow COURSEMOS LMS’s bulk question upload template.

XLSX workbook sample rows

Rows 2, 4, 8, and 10 are shown below. Headers and cell values are unchanged. Scroll horizontally to see the answers, points, and explanations. Empty cells are displayed as —.

XLSX workbook sample rows
RowA문제유형B명칭C질문D보기1E보기2F보기3G보기4H보기5I보기6J정답K배점L정답해설
2객관식숫자 인식 신경망의 입력, 은닉층과 출력입력층 노드가 \(4\)개, 첫 번째 은닉층 노드가 \(3\)개, 두 번째 은닉층 노드가 \(2\)개인 신경망이 있습니다. 인접한 층 사이가 모두 연결되어 있고, 입력층이 아닌 각 노드에 편향이 하나씩 있을 때 가중치와 편향의 총개수는 얼마입니까?24개22개21개23개——41인접한 두 층 사이의 가중치 개수는 두 층 노드 수의 곱이고, 입력층이 아닌 노드마다 편향을 더합니다. 따라서 총개수는 \((4\times3)+3+(3\times2)+2=23\)입니다.
4참거짓숫자 인식 신경망의 입력, 은닉층과 출력입력 픽셀 값은 0에서 255 사이이며, 255가 가장 큰 값이고 0이 가장 작은 값이다.——————01입력 픽셀 값의 범위는 0에서 1까지이며, 0이 가장 작고 1이 가장 큽니다.
8에세이숫자 인식 신경망의 입력, 은닉층과 출력픽셀 크기가 \(28\times28\)인 입력 이미지의 입력값은 모두 몇 개입니까?——————784개1각 픽셀마다 입력값 하나가 주어지므로 입력값의 개수는 픽셀 수와 같습니다.
10에세이숫자 인식 신경망의 입력, 은닉층과 출력출력층의 10개 노드는 ____.——————0부터 9까지의 숫자 레이블에 각각 대응한다1출력층에는 10개 노드가 있고, 각 노드는 0부터 9까지의 숫자 레이블 하나에 대응합니다.

Answer formats by question type

Multiple choice uses option numbers

The 4 in J2 points to option 4 in G2.

True/false answer format

O or True exports as 1; X or False exports as 0.

Short answers and blanks also use the essay label

Essay, short-answer, and fill-in-the-blank questions all use 에세이 in the XLSX type column. Answers are text; multiple accepted short answers are joined with commas.

Math stays as editable text

LaTeX such as \(28\times28\) in C8 remains a string. It is not converted into an Excel formula or a rendered math image. The ____ blank marker is also preserved in the question.

XLSX download steps

  1. Sign in and open the editor for a quiz you created.
  2. Open the download menu and select XLSX as the file format.
  3. Download the file and open it in a spreadsheet application.

This sample is available without signing in. Exporting your own quiz requires a signed-in account with a verified email. Matching questions are excluded from XLSX; use PDF for a matching-only quiz.

ANN structure and how to work 인공신경망 구조 및 학습

Watch on YouTube

The PDF export guide includes page layouts and samples of printable question papers with answers and explanations.

View PDF export samples

Frequently asked questions

Answers are in column J and explanations in column L. To share only the questions, delete these two columns from a copy of the workbook.

You can edit questions, choices, answers, and explanations directly in their cells.

Check the destination service’s import template first. Column names, question types, and answer formats vary by service, so column order or values may need to be changed.

Build a quiz from your material and export it

Quizzes created from PDFs, images, YouTube videos, URLs, and text can be saved as Excel workbooks for organizing and editing questions.

Create a quiz from your material