Microsoft Excel Exam at a Glance

What changed for Microsoft Excel in 2026

• Oct 16, 2026: Delivery changed to Proctored live-in-the-application exam via Certiport Authorized Testing Centers (in-center or remote-proctored) (previously Proctored live-in-the-application exam via Certiport Authorized Testing Centers).^[2]
• Oct 16, 2026: Eligibility changed to No formal prerequisites; about 150 hours of instruction and hands-on experience recommended (previously No formal prerequisites; ~150 hours of instruction and hands-on experience recommended (Associate)).^[6]
• Jun 30, 2026: Certiport retired the Microsoft Office Specialist 2016 certifications, including MOS Excel 2016, on June 30, 2026. The Microsoft 365 Apps and Office 2019 Excel exams are still available.^[7]

An Excel practice test checks the formulas, tables, charts, and data skills that Excel skills assessments and the Microsoft Office Specialist exams measure. The Excel Associate exam (MO-210) gives you 50 minutes, so practice hands-on tasks against a timer. Practice with the free Excel practice test on PracticeTestGeeks (500+ questions with answer explanations).

Excel Graphical Features

Excel Practice Test: Features of Excel

Excel has a variety of graphical features for representing data in charts and pictorial format. Charts, Shapes, Smart Arts, Clip Arts, and Pictures are a few examples.

Candidates preparing for gmetrix can build exam confidence with our GMetrix practice exam 2026, which covers all key topics and question formats used in the real assessment.

Free Excel Study Tools

Interactive Excel resources on PracticeTestGeeks, free to start:

• Free Excel Questions and Answers — 16 questions with instant scoring and answer explanations
• Excel flashcards — review key terms and concepts card by card
• Excel study guide — topic-by-topic overview of what the exam covers
• Excel cheat sheet — one-page printable summary for last-minute review

According to Microsoft (Microsoft Office Specialist program), delivered by Certiport, a Pearson VUE business, “Microsoft Office Specialist (Microsoft 365 Apps) - each exam is 50 minutes: Word: 33-37 Questions Excel: 33-37 Questions”^[1]

Worked examples: how to reason through Microsoft Excel questions

These are practice questions written for this site, not questions from the real exam. Each explanation shows why the right answer is right and why the others are wrong.

Example 1

Question: A user wants to create a navigation menu on the first worksheet that links to specific cells in other worksheets within the same workbook. Which is the correct way to configure a hyperlink for this purpose?

1. In the Insert Hyperlink dialog, select 'Existing File or Web Page' and browse to the current file.
2. Use the HYPERLINK function with just the cell reference, like =HYPERLINK("D10", "Go to D10").
3. In the Insert Hyperlink dialog, select 'Place in This Document' and then choose the worksheet and enter the cell reference.
4. In the Insert Hyperlink dialog, select 'Create New Document' and link it back to the original workbook.

Answer: C. In the Insert Hyperlink dialog, select 'Place in This Document' and then choose the worksheet and enter the cell reference.

Explanation:

Option C is correct. In the Insert Hyperlink dialog, 'Place in This Document' lets you pick a worksheet in the current workbook and type the cell reference, such as D10, so the link jumps inside the file. Option A points to a file or web address, so it treats the workbook as an outside document instead of an internal location. Option B fails because HYPERLINK needs a location written as a full internal address, and a bare cell reference does not say which sheet or file to open. Option D creates a new document, which is not what a navigation menu needs. Rule to remember: for links to places inside the same workbook, use 'Place in This Document'.

Example 2

Question: What key combination on the keyboard locks cell references in a formula?

1. CTRL
2. ALT
3. F4
4. F2

Answer: C. F4

Explanation:

Option C, F4, is correct. While you are editing a formula, pressing F4 on a cell reference cycles it through relative, absolute and mixed forms by adding or removing dollar signs. That is how you lock a reference so it does not shift when the formula is copied. CTRL and ALT are modifier keys. They change what another key does but do not cycle reference types on their own. F2 is wrong because it puts the active cell into edit mode, which is a step before locking a reference, not the lock itself. Rule to remember: F4 toggles dollar signs, F2 starts editing.

Example 3

Question: After loading a query to a worksheet, the source CSV file receives new rows. What is the quickest way to bring those rows into Excel?

1. Re-import the file with a new query
2. Click Refresh All on the Data tab
3. Manually copy the new rows into the table
4. Delete the query and recreate it

Answer: B. Click Refresh All on the Data tab

Explanation:

Option B is correct. A loaded query stores its steps, and Refresh All on the Data tab re-runs those steps against the current contents of the source CSV, so the new rows arrive with the same cleanup applied. Re-importing with a new query (A) and deleting then recreating the query (D) both repeat work you have already done and can lose your transformation steps. Copying rows by hand (C) breaks the link to the source and is easy to get wrong. Rule to remember: when the source data changes, refresh the existing query instead of rebuilding it.

How to use these practice tests

Start with the official Microsoft page for the Excel Associate exam and read the skills it lists. Then open Excel and practise each skill by hand, because the real exam asks you to perform tasks in the application. Use the practice sets here to find gaps in knowledge.

Begin with the basics: managing worksheets and workbooks, cells and ranges and tables. Move on to formulas and functions, then charts. If you are aiming at the advanced exam, add PivotTables and PivotCharts, Power Query and advanced formulas and macros.

After each set, read the explanation for every question you missed. Then recreate the task in a workbook until you can do it without hints. Keep a short list of shortcuts and settings that tripped you up, and review it before you book. Near test day, run a mixed set such as Excel MCQ under a time limit so the pace feels familiar.

Excel Data Base Features

Excel can be used as a data base and perform a variety of data operations. Pivot Tables, Slicers, Tables, Spark lines, Database, Sorting, Filtering, Data Validation, Grouping, and so on are examples.

Excel Tools and Functions

Excel Tools and Excel Functions will assist in performing powerful calculations and enhancing the Excel Application Features. Excel Formulas, VBA Macros, Add-ins, Hyperlinks, Conditional Formatting, Spell Check, Protection, and so on.

Easy to Store Data

Advantages of Using MS Excel

MS Excel is widely used for a variety of purposes because data is easily saved and information can be added and removed with little discomfort and effort.

MS Excel is widely used to save or analyze data because there is no limit to the amount of information that can be saved in a spreadsheet. Filtering data in Excel is simple and convenient, which is why sorting and filtering show up in almost every Excel exam practice set.

Data Recovery Is Simple

Finding information written on paper may take longer; however, this is not the case with excel sheets. It is simple to locate and recover data.

The Use of Mathematical Formulas

With MS Excel's formulas option, calculating has become easier and less time-consuming.

Increased Security

These spreadsheets can be password protected on a laptop or personal computer, and the likelihood of losing them is much lower than data written in registers or on scrap paper.

Data in One Location

Previously, data was to be kept in various files and registers once the paperwork was completed. This is now more convenient because multiple worksheets can be added to a single MS Excel file.

Clearer Information Visibility

It is easier to analyze data when it is saved in the form of a table. As a result, information is presented in the form of a more readable and understandable spreadsheet.

Practice

How to Prepare for an Excel Test?

There is no one way to prepare for an Excel test, but there are definitely effective ways to prepare. Make sure you've covered all of the fundamentals before taking the test:

Plenty of free Excel practice test sets are available online, including Excel assessment test practice free of charge on this page, so take as many as you can. Good Excel test practice means working through Excel questions for practice in a live spreadsheet, not just reading about functions. Practice makes perfect, and you never know what questions will come up during your actual test — being prepared for anything could be the key to acing the test.

Keep track of your time

Because the Excel Test will almost certainly be timed, use a timer during your practice tests as well. It will not only help you to be faster, but it will also reveal which questions take you the longest to answer, allowing you to focus on what you need to practice more. Because Microsoft 365 ships monthly feature updates (the Excel August update is a typical example), do your Excel tests practice on a current build so the ribbon and function names match what you will see on exam day.

Control your surroundings

There is nothing worse than being interrupted while taking an Excel Test, so find a quiet place to do it. When practicing, it's also a good idea to recreate the same environment

Excel Test vs. Excel Exam: Which One Are You Taking?

An Excel test usually means an employer skills assessment taken during hiring, while an Excel exam usually means a Microsoft Office Specialist (MOS) certification exam. Knowing which one you face changes how you practice.

• Employer Excel test: set by the hiring company or its testing vendor, so the format, time limit, and scoring differ from one employer to the next. Many mix multiple-choice questions with tasks in a simulated or live spreadsheet, and the result is a score report for the recruiter, not a credential. Read the invitation for the time limit and skill level (basic, intermediate, or advanced).
• MOS Excel Associate exam (MO-210): 50 minutes of hands-on tasks across five areas: worksheets and workbooks, data cells and ranges, tables, formulas and functions, and charts.
• MOS Excel Expert exam (MO-211): four weighted areas: workbook options and settings (10-15%), managing and formatting data (30-35%), advanced formulas and macros (25-30%), and advanced charts and tables (25-30%).

For either one, the best Excel questions for practice are timed tasks in a real workbook: build the formula, check the result, then repeat until each task takes under two minutes.

Excel Exam Scoring: What Score Passes and When You Get Results

The passing score for Microsoft Office Specialist Excel exams is always 700 on Certiport's 1 to 1000 scaled score, and candidates get their MOS Excel score report as soon as they finish the exam. The report can also be viewed in their Certiport profile, so there is no waiting period before you know whether you passed the Excel exam.

• Scaled, not percentage: 700 is a point on the 1 to 1000 scale, not "70% correct," so do not try to convert your practice-test percentage into an exact MOS score. Treat steady accuracy on timed, hands-on practice tasks as the real readiness signal.
• If you fall short: after failing a Microsoft Office Specialist Excel exam, candidates must wait 24 hours before the first retake and 48 hours before each later retake, and there is no annual limit on attempts. Use the score report to pick the weakest objective area and drill it before you rebook.
• Employer Excel tests differ: a hiring company's Excel test is scored by its own testing vendor, so the cut-off, if any, is set by the employer and shared with the recruiter rather than published.

Excel Practical Questions for Exam Day: What You Will Actually Be Asked to Do

Most Excel test practice fails for one reason: people memorize definitions instead of doing tasks. Employer assessments and the MOS exams are both hands-on, so your Excel exam practice test should mirror the practical questions below. Each one appears on real screenings for analyst, accounting, and administrative roles.

• Lookups: pull a price or employee name from another table with =VLOOKUP(A2,Prices!A:C,3,FALSE), and know why XLOOKUP (no column index, exact match by default, lookup to the left) is the safer modern replacement.
• Absolute references: compute a percentage of a total by locking the total cell with $B$10 so the formula survives copy-down and fill-right. Pressing F4 toggles the dollar signs.
• Conditional logic and aggregates: flag overdue invoices with =IF(TODAY()>D2,"Overdue","OK"), then total them with SUMIF or COUNTIFS.
• PivotTables: summarize sales by region and month in under two minutes, add a slicer, and switch the value field from Sum to Average.
• Conditional formatting: apply a color scale or a rule such as "highlight cells greater than 1,000" and clear it again without deleting the data.
• Cleanup: remove duplicates, split full names with Text to Columns or TEXTSPLIT, freeze panes, and convert a range to a Table so new rows extend formulas automatically.

Time each task. The MOS Excel Associate exam gives 50 minutes for 33 to 37 live tasks, so budget roughly 80 to 90 seconds per task and move on when you are stuck.

Excel Questions for Practice: 6 Sample Items With Worked Answers

The fastest way to check your readiness for an Excel test is to answer short calculation questions, then confirm each result by typing the formula into a blank sheet. Assume cells A1:A5 hold the values 4, 8, 15, 16 and 23.

1. What does =AVERAGE(A1:A5) return? 13.2. The five values add up to 66, and 66 divided by 5 is 13.2.
2. What does =COUNTIF(A1:A5,">10") return? 3, because only 15, 16 and 23 are greater than 10.
3. Cell B2 contains =A2*$C$1. What does it become when copied down to B5? =A5*$C$1. The relative reference moves with the copy, while the dollar signs keep C1 locked.
4. What does =LEN("Excel Test") return? 10. LEN counts every character, including the space.
5. What does =ROUND(3.14159,2) return? 3.14, rounded to two decimal places.
6. B2 holds 69.5. What does =IF(B2>=70,"Pass","Fail") show? "Fail". IF compares the stored value and does not round it first, and 69.5 is below 70.

If you get all six right without opening Excel, move on to the timed practice questions above. If you miss any, rebuild that formula yourself until the result makes sense, because skills tests and the MOS exams grade the result you produce, not whether you can recall a definition.

Which Excel Version to Use for Excel Test Practice

Practice on the same kind of Excel your test uses, because features and function lists differ between versions. The current Microsoft Office Specialist exams, MO-210 (Excel Associate) and MO-211 (Excel Expert), are built for Microsoft 365 Apps, so a current desktop build of Excel is the closest match when you prepare for a certification Excel exam.

• Excel for the web covers the basics. It is free with a Microsoft account and handles everyday formulas, tables, and charts, but Microsoft states that you can't create, run, or edit VBA macros in Excel for the web. Because MO-211 measures the ability to "create advanced formulas and macros," Excel Expert candidates need the desktop app.
• Newer functions need a newer version. Microsoft notes that XLOOKUP is not available in Excel 2016 and Excel 2019, so practice files that rely on it will return errors on those versions. Learn VLOOKUP as well in case your test machine runs an older build.
• Employer Excel tests set their own environment. Some run inside the testing vendor's browser-based simulator rather than full Excel, so read the invitation and rehearse keyboard-driven tasks such as F4 to switch reference types and Ctrl+T to create a table.

Matching the environment means your timed practice reflects the real test, not the quirks of a different version.

How to Test Your Excel Skills Before the Real Excel Test

To test Excel skills honestly, complete one task per level in a blank workbook with a timer running and no web search; the first level where you stall is where your study plan should start.

• Basic: type a short sales list, total it with SUM, find the mean with AVERAGE, format the totals as currency, and sort the list from largest to smallest.
• Intermediate: convert the list to a Table with Ctrl+T, pull a value from a second table with XLOOKUP or VLOOKUP, count matching rows with COUNTIFS, and build a PivotTable that totals sales by region.
• Advanced: nest IF with AND or OR, add a data validation drop-down list, create a conditional formatting rule that uses a formula, and record a simple macro in the desktop app (Excel for the web cannot record VBA macros).

Score yourself on two things: whether each result is correct and how long it took. Check every answer by changing an input value and confirming the formula recalculates. Then take a timed Excel practice test on this page to measure the same skills under exam-style conditions, and repeat the self-check after a week of practice to see which level has moved.

Common Excel Test Mistakes and How to Avoid Them

Most points lost on an Excel test come from a few avoidable habits, not from unknown functions. Check your practice work for these before the real Excel exam:

• Typing results instead of formulas. Graders and recruiters check the cell, not just the number. A hard-coded total looks right until an input changes, so always build the answer with a formula.
• Leaving out the last VLOOKUP argument. If you omit range_lookup, Microsoft documents that VLOOKUP defaults to TRUE (approximate match), which can return a wrong row from unsorted data. Type FALSE, or use XLOOKUP, which matches exactly by default.
• Numbers stored as text. SUM ignores text values, so imported figures with a green error triangle can leave a total short without any warning. Convert them to numbers first.
• Forgetting that dates are numbers. Excel stores January 1, 1900 as serial number 1, so subtracting two dates returns the days between them. Format the result as a number, not a date.
• Sorting around merged cells. Excel refuses to sort a range whose merged cells differ in size, so unmerge first or use Center Across Selection.

Free Excel Assessment Test Practice: Online Quizzes and PDF Download

You can get Excel assessment test practice free on this page in two ways: take the topic quizzes online for instant scoring, or download the questions and answers as a PDF to work through offline. Both cover the same skills that employer Excel tests and the Microsoft Office Specialist exams check.

• Online topic quizzes: the free tests above are split by subject, including formulas, functions, and multiple-choice basics, so you can drill the area your assessment is most likely to stress and see your score as soon as you finish.
• Excel practice test free download: the PDF below suits study without an internet connection or on paper. Retype each formula question into a blank workbook afterward, because seeing the result in Excel is what fixes the method in memory.
• Full timed run: once your topic scores are steady, set a 50-minute timer, the length of the MOS Excel exams, and finish a complete set in one sitting.

No free practice set can copy every employer's testing platform, since each vendor uses its own format and question bank. Use practice scores to find weak topics, then rehearse those tasks hands-on in a live workbook until each one feels routine.

Where Can I Get a Microsoft Excel Practice Test?

You can get a free Microsoft Excel practice test on this page, while official practice tests for the Microsoft Office Specialist (MOS) Excel exams are sold through the Certiport Store. The right choice depends on whether you face an employer Excel test or a MOS certification exam.

• Free topic quizzes here: start with the Excel formulas quiz or the Excel multiple-choice questions, then move to the Excel certification practice test once your scores hold steady.
• Official MOS practice: Certiport, the Pearson VUE business that delivers the MOS Excel exams, offers learning materials, practice tests, and exam vouchers in its store. Save them for the final stretch, since the real exam is a timed, 50-minute set of hands-on tasks in Excel.
• Free official training: Microsoft Support publishes Excel training on formulas, tables, charts, and PivotTables at no cost. Rebuild each example in your own workbook instead of only reading it.
• Employer assessments: no public site hosts a hiring company's exact Excel test, so ask the recruiter which skill level and format to expect, then practice those tasks in a live spreadsheet.

XL Test

An XL test is simply a short name people use for an Excel test, meaning any timed or untimed check of your spreadsheet skills. People also search for it as "exceltest" (one word), but it is the same thing: a quick Excel test of formulas and data skills. Employers use it during hiring to see whether you can enter data, write formulas, sort and filter lists, and build a simple chart without help. Schools and training programs use the same format to grade coursework.

To get ready, practice the tasks that come up most often: SUM, AVERAGE, IF, VLOOKUP or XLOOKUP, cell references, number formatting, and PivotTables. Work in a real workbook rather than only reading about the features, because most assessments ask you to produce a result, not just recognize a term. Afterward, review every miss and redo it from scratch. If you want quick feedback first, try the Excel practice questions with video answers on this site, then return to the practice test above to check your speed and accuracy under realistic conditions.

Best Beginner Excel Courses

Microsoft's Excel is a data analysis program. It can perform a wide range of functions, including data comparison and presentation in a number of formats. You enter the data, and Excel takes care of the rest. If you are searching for an Excel download free of charge to practice on, note that the desktop app is sold through a Microsoft 365 subscription (which includes a one-month trial), while Excel for the web is free with a Microsoft account and handles most formulas, tables, and charts you will meet on a skills test. A genuine MS Excel download free of malware only comes from microsoft.com or office.com, so avoid third-party installers. We've put together a list of some of the greatest beginner excel online classes available for a wide range of needs and students.

• Udemy’s Microsoft Excel Class for Beginner to Advanced Learners
• Macquarie University’s Excel Skills for Business Certification
• Rice University’s Introduction to Data Analysis Using Excel
• GoSkills’ Microsoft Excel Classes—Basic and Advanced

You may also search for more courses to take an excel course online using keywords such as "in person excel classes near me", "excel data analysis training", "excel and data analysis course", "best online excel classes", "online excel assessment test", "virtual excel training", "data analytics excel course", "excel training providers", "online excel assessment", "excel classes for beginners", "excel and powerpoint classes near me", "beginner to advanced excel course" or "best excel classes".

Official Resources

• Certiport: Microsoft Office Specialist (Microsoft 365 Apps) lists the Excel Associate and Excel Expert exams, their objectives, and how to find a testing center or buy a voucher.
• Microsoft Learn: MOS Excel Associate (Microsoft 365 Apps) is the official credential page for exam MO-210, including the skills measured and renewal details.
• Microsoft Support: Excel help and learning offers free official training on formulas, PivotTables, charts, and the features tested on skills assessments.

Sources & last verified

1. certiport.pearsonvue.com — number of questions (official source). “Microsoft Office Specialist (Microsoft 365 Apps) - each exam is 50 minutes: Word: 33-37 Questions Excel: 33-37 Questions” Verified Oct 17, 2026 · source checked Oct 17, 2026.
2. Microsoft (Microsoft Office Specialist program), delivered by Certiport, a Pearson VUE business — time limit, delivery (official source). “Microsoft Office Specialist (MOS) exams 50 minutes 60 minutes” Verified Oct 17, 2026 · source checked Oct 17, 2026.
3. certiport.pearsonvue.com — passing score, score release (official source). “On the score report the passing score is distributed across a 1 to 1000 scale. The passing value is always equated to 700 on this…” Verified Oct 16, 2026 · source checked Oct 16, 2026.
4. Microsoft (Microsoft Office Specialist program), delivered by Certiport, a Pearson VUE business — retake policy (official source). “If you don’t pass a Microsoft Office Specialist (MOS) exam the first time, you must wait 24 hours before retaking it. If you don’t pass…” Verified Oct 17, 2026 · source checked Oct 17, 2026.
5. certiport.pearsonvue.com — validity (official source). “Please note: The policy took effect for Cisco Certified Support Technician on July 15, 2025, with Microsoft Office Specialist following on September 23, 2025.” Verified Oct 16, 2026 · source checked Oct 16, 2026.
6. Microsoft (Microsoft Office Specialist program), delivered by Certiport, a Pearson VUE business — eligibility (official source). “As a candidate, you should: Have approximately 150 hours of instruction and hands-on experience with the product. Have proven your proficiency at an industry associate…” Verified Oct 17, 2026 · source checked Oct 17, 2026.
7. certiport.pearsonvue.com — other (official source). “Microsoft Office Specialist 2016 certification program retirement: MOS 2016 certifications retired on June 30, 2026. After this date, exams for this MOS version will no…” Verified Oct 16, 2026 · source checked Oct 16, 2026.

How we verify: editorial & fact-checking policy. Report an error: contact us.