Home › Quizzes › Quiz Makers & AI Tools › Excel Quiz Maker from Your Notes

Turn your Excel notes into a practice quiz with AI

Upload a PDF, slide deck or set of notes about formulas, lookups or pivot tables, and get questions with explanations you can study in the browser.

Create quizzes nowFree · No credit card required

Drop files here or browsePDF, DOCX, PPTX, text or photos of your notes · several files with Plus

Free · First set needs no signup · Creates quizzes in seconds

How to build an Excel quiz from your own material

A quiz maker for Excel works best when it starts from the lessons you are actually studying. Tutorial handouts, course slides and your own notes on formulas, conditional formatting or data validation give the generator the exact steps and terms your class uses, so the questions match what will appear on a test.

Questions drawn from your own Excel tutorials, not a generic bank
Explanations that show why a formula returns a value
Paid exports to PDF, DOCX, Anki and CSV for offline practice
Quizzes for a learning management system via QTI 2.1 or Moodle XML on Pro

Example Excel formula practice questions

What does =SUM(A1:A5) return?The total of the numeric values in cells A1 through A5. SUM adds every number in the range and ignores text.

What does the fourth argument FALSE do in VLOOKUP?It requires an exact match. Without it, VLOOKUP may return an approximate match from an unsorted list.

True or false: pressing F4 while editing a cell reference cycles through absolute and relative forms.True. F4 adds or removes dollar signs so the reference stays fixed when the formula is copied.

What does =COUNTIF(B2:B20,"Yes") count?The number of cells in B2:B20 that contain exactly "Yes". COUNTIF tallies cells that meet one condition.

Which key combination entered an array formula in older Excel versions?Ctrl+Shift+Enter. It tells Excel to treat the formula as an array formula, while newer dynamic array versions do not need it.

Generate the full set

Multiple-choice, true/false and open questions

Pick the question style that fits the skill you are testing, from quick formula recall to short written answers.

Explanations on every question

Each answer comes with a short reason, so a wrong guess about how VLOOKUP or COUNTIF works becomes a lesson.

Study mode in the browser

The free plan lets you take generated quizzes right away, with three generations each month and no credit card needed.

How it works

Add your material

Upload a PDF, DOCX, PPTX or plain text file, or photograph a page of handwritten Excel notes.

Choose question types

Select multiple-choice, true/false or open questions, and how many you want.

Practice and review

Work through the quiz, read the explanations, and export to PDF or DOCX on a paid plan.

Keep each quiz focused on one skill, such as lookup functions or absolute references. Ten to fifteen questions on a single topic is usually enough to see where you are weak. Re-run the quiz after you have fixed the gaps, and read the explanations for every wrong answer before you move on.

Explore related topics

Quiz Maker Excel Template Alternative

Skip the blank spreadsheet. Generate quiz questions with explanations from your notes.

Excel Quiz Generator

Turn your own Excel notes or slides into multiple-choice and short-answer practice questions.

Free MCAT Practice Test Answers

Build MCAT practice questions and explanations from your own notes, PDFs or slides.

Online quiz maker: how it works

How an AI online quiz maker works, which question types it makes, and when a paid plan is worth it.

AI Math Quiz Generator

Upload math notes or PDFs and get practice quizzes with answers and explanations.

Adaptive AI Exam Generator

Practice exam questions from your notes, with explanations for every answer.

Adobe Acrobat Online Quiz Maker

Turn Acrobat training PDFs and slides into quizzes with explanations.

Adobe Quiz Maker from Your Notes

Turn Adobe course PDFs, slides and notes into AI quizzes with explanations and exports.

Frequently asked questions

What Excel topics can the quiz cover?

Any topic in the material you upload, such as SUM, VLOOKUP, pivot tables or absolute references. The quiz is only as broad as your source notes or slides.

How many questions should I practice at once?

Around ten to fifteen questions on one skill is a good starting size. Smaller sets make it easier to see which formulas still need work.

Can I export the quiz?

Exports are a paid feature. Plus includes PDF, DOCX, Anki and CSV export, and Pro adds QTI 2.1 and Moodle XML.

Do I need a credit card to start?

No. The free plan gives three generations per month with study in the browser, and students get 40% off a paid plan with a school email.

Generate free quizzes

Keep exploring the topic

Review the main ideas visually or practice recalling them.