100+ Free MOS Excel Associate (MO-210) Practice Questions
Pass your Microsoft Office Specialist: Excel Associate (Microsoft 365 Apps) exam on the first try — instant access, no signup required.
What does the Format Painter do?
Explore More Microsoft Certifications
Continue into nearby exams from the same family. Each card keeps practice questions, study guides, flashcards, videos, and articles in one place.
More From This Family
Videos and articles for deeper review.
Key Facts: MOS Excel Associate (MO-210) Exam
~35
Performance-Based Tasks
Microsoft Learn MO-210 page
50 min
Time Limit
Microsoft Learn MO-210 page
700/1000
Passing Score
Microsoft MOS scoring standard
US$100
Exam Fee (US list)
Certiport / Microsoft Learn
No expiration
Certification Validity
Microsoft MOS program FAQ
Microsoft 365 Apps
Tested Excel Build
Microsoft Learn MO-210 page
MO-210 is a 50-minute, performance-based Excel Associate exam delivered through Certiport on Microsoft 365 Apps. Microsoft Learn lists approximately 35 tasks, a US$100 fee, and a 700/1000 passing score. MOS certifications do not expire, but Microsoft refreshes the underlying objectives over time.
Sample MOS Excel Associate (MO-210) Practice Questions
Try these sample questions to test your MOS Excel Associate (MO-210) exam readiness. Each question includes a detailed explanation. Start the interactive quiz above for the full 100+ question experience with AI tutoring.
1Which Excel file format supports macros?
2You need to jump quickly to cell ZZ500 without scrolling. What is the fastest way?
3On the Page Layout tab, which option scales the printed sheet to fit on exactly one page wide by any number of pages tall?
4Which feature ensures that row 1 prints at the top of every printed page?
5You select cells A1:F50 and click Page Layout > Print Area > Set Print Area. What happens when you next print?
6Which command checks a workbook for hidden personal data such as comments and document properties before sharing?
7You want different headers on the first printed page than on later pages. Which option enables this?
8Which view lets you visually drag page break dividers to reposition them?
9You need to save a worksheet so it can be opened in a text editor with values separated by commas. Which Save As file type is correct?
10Which keyboard shortcut opens the Find and Replace dialog directly on the Replace tab?
About the MOS Excel Associate (MO-210) Exam
MO-210 is the current Microsoft Office Specialist: Excel Associate exam built on Microsoft 365 Apps. The exam is delivered live inside Excel by Certiport, so candidates complete real Excel tasks rather than answering multiple-choice questions. Skill areas include managing worksheets and workbooks, managing data cells and ranges, managing tables and table data, performing operations using formulas and functions (SUMIF/SUMIFS, IF, IFS, SWITCH, text and date functions), and creating and modifying charts. MO-210 replaces the legacy Office 2019 MO-200 Excel Associate exam.
Assessment
Approximately 35 task-based, performance-based items completed in a live Excel environment; tasks may include multiple sub-actions
Time Limit
50 minutes
Passing Score
700 out of 1000 (per Microsoft Learn standard MOS scoring)
Exam Fee
US$100 (US list price; varies by country and Certiport authorized testing center) (Microsoft)
MOS Excel Associate (MO-210) Exam Content Outline
Manage worksheets and workbooks
Import data, navigate with the Name Box and Go To Special, configure page layout (margins, orientation, scale, breaks, print area, print titles), customize headers and footers, manage workbook properties, run Document Inspector and Accessibility Checker, and save in formats including .xlsx, .xlsm, .csv, and .pdf.
Manage data cells and ranges
Manipulate data with Paste Special, Flash Fill, Fill Series, Text to Columns, Remove Duplicates, and Data Validation. Format cells with number formats (Date, Currency, Percentage, custom codes 0/#/?), alignment (wrap text, merge & center, center across selection), borders, and themes. Manage defined names, apply conditional formatting (Highlight Cells, Top/Bottom, Data Bars, Color Scales, Icon Sets, formula rules).
Manage tables and table data
Create Tables (Insert > Table or Format as Table), apply Table Styles, toggle Header Row / Total Row / Banded Rows, use SUBTOTAL in the Total Row, write structured references with TableName[Column] and [@Column], add Slicers, sort and filter (multi-level, custom lists, by color, Top 10), and Convert to Range.
Perform operations by using formulas and functions
Use relative, absolute ($A$1), and mixed references with the F4 toggle. Apply arithmetic, comparison, and concatenation (&) operators. Use SUM, AVERAGE, MIN, MAX, COUNT, COUNTA, COUNTBLANK, SUMIF/SUMIFS, COUNTIF/COUNTIFS, AVERAGEIF/AVERAGEIFS, MAXIFS/MINIFS, IF, IFS, SWITCH, LEFT/RIGHT/MID, LEN, UPPER/LOWER/PROPER, CONCAT, TEXTJOIN, TODAY/NOW, DATE, NETWORKDAYS, ROUND, ROUNDUP, ROUNDDOWN, INT, MOD.
Manage charts
Insert charts (column, bar, line, pie, scatter, combo) including Recommended Charts. Modify chart data with Switch Row/Column and Select Data. Format chart elements (titles, axis titles, data labels, legend, gridlines, trendlines). Apply Chart Styles and Quick Layout. Move charts to a new sheet. Insert sparklines (Line, Column, Win/Loss). Add alt text for accessibility.
How to Pass the MOS Excel Associate (MO-210) Exam
What You Need to Know
- Passing score: 700 out of 1000 (per Microsoft Learn standard MOS scoring)
- Assessment: Approximately 35 task-based, performance-based items completed in a live Excel environment; tasks may include multiple sub-actions
- Time limit: 50 minutes
- Exam fee: US$100 (US list price; varies by country and Certiport authorized testing center)
Keys to Passing
- Complete 500+ practice questions
- Score 80%+ consistently before scheduling
- Focus on highest-weighted sections
- Use our AI tutor for tough concepts
MOS Excel Associate (MO-210) Study Tips from Top Performers
Frequently Asked Questions
How many questions are on the MOS Excel Associate MO-210 exam?
Microsoft Learn describes MO-210 as a performance-based exam consisting of approximately 35 tasks completed inside a live Excel environment. Each task may include several sub-actions you must complete using the actual application, which is why exam length is measured in tasks rather than multiple-choice questions.
How long is the exam and how is it scored?
MO-210 is timed at 50 minutes. Microsoft scores MOS exams on a scale of 0 to 1,000 with a passing score of 700. Tasks are auto-graded based on the state of the workbook when you finish, so partial credit may apply when only some sub-steps are correct.
What does MO-210 cost and where do I take it?
The standard US list price is approximately US$100 per attempt, though authorized Certiport testing centers, schools, and bundles can change the final price. The exam is delivered exclusively through Certiport, either at a physical Certiport Authorized Testing Center or via Certiport's online proctored option where available.
Does the MOS Excel Associate certification expire?
No. Microsoft Office Specialist certifications, including MOS Excel Associate MO-210, do not expire. Microsoft does periodically refresh the underlying exam objectives or retire older versions (for example, the legacy Office 2019 MO-200 Excel Associate exam has been retired in favor of the current Microsoft 365 Apps version), but the certification you already hold remains valid.
What is the difference between MOS Excel Associate (MO-210) and MOS Excel Expert (MO-211)?
MO-210 (Associate) covers core skills: managing workbooks, cells and ranges, tables, basic-to-intermediate formulas (SUMIF/SUMIFS, IF, IFS, SWITCH, basic text/date functions), and charts. MO-211 (Expert) builds on those skills and adds advanced workbook management, advanced conditional formatting, dynamic array functions (FILTER, SORT, UNIQUE), LET, LAMBDA, XLOOKUP, advanced PivotTables, Power Pivot data modeling, and Power Query workflows.
Is MO-210 the same as the older MO-200 exam?
No. MO-200 was the Excel Associate exam built on Office 2019 and has been retired by Microsoft. MO-210 is its replacement, built on Microsoft 365 Apps and reflecting current Excel features such as Sheet Views, modern charts, and updated ribbon. Always study against the MO-210 skills outline if you plan to take the current exam.