Career upgrade: Learn practical AI skills for better jobs and higher pay.
Level up
PracticeVideosBlogFlashcardsEspañol
All Practice Exams

100+ Free MO-210 Practice Questions

Pass your Microsoft Excel (Microsoft 365 Apps) (MO-210) exam on the first try — instant access, no signup required.

✓ No registration✓ No credit card✓ No hidden fees✓ Start practicing immediately
100+ Questions
100% Free
1 / 100
Question 1
Score: 0/0

Which formula removes ALL spaces from a text string, including spaces between words?

A
B
C
D
to track
Same family resources

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.

Microsoft Power BI Data Analyst

Practice QuestionsStudy GuideCheat SheetFlashcards2 videos4 blogs

Microsoft Certified: Security, Compliance, and Identity Fundamentals (SC-900)

Practice QuestionsStudy GuideCheat Sheet1 video2 blogs

Azure MD-102

Practice QuestionsStudy GuideCheat SheetFlashcards1 video1 blog

Microsoft Certified: Security Operations Analyst Associate (SC-200)

Practice QuestionsStudy GuideCheat SheetFlashcards1 video1 blog

Azure MS-102

Practice QuestionsCheat Sheet2 videos3 blogs

Microsoft Power Platform Functional Consultant

Practice Questions2 blogs

More From This Family

Videos and articles for deeper review.

VideoFREE MD-102 Exam Guide 2026: Pass Microsoft Endpoint Administrator (Intune, Autopilot, Windows 11)VideoFREE MD-102 Exam Guide 2026: Pass Microsoft Endpoint Administrator (Intune, Autopilot, Windows 11)VideoFREE MS-102 Exam Guide 2026: Pass Microsoft 365 Administrator (Entra, Defender XDR, Purview)VideoFREE MS-102 Exam Guide 2026: Pass Microsoft 365 Administrator (Entra, Defender XDR, Purview)ArticleFREE DP-600 Exam Guide 2026: Pass Microsoft Fabric Analytics Engineer (Direct Lake, DAX, Semantic Models)27 min readArticleFREE MD-102 Exam Guide 2026: Pass Microsoft Endpoint Administrator (Intune, Autopilot, Windows 11)24 min readArticleFREE MS-102 Exam Guide 2026: Pass Microsoft 365 Administrator (Entra, Defender XDR, Purview)24 min readArticleFREE PL-400 Power Platform Developer Exam Guide 2026: Pass First Try16 min read
2026 Statistics

Key Facts: MO-210 Exam

~35

Exam Tasks

Certiport

700/1000

Passing Score

Certiport

50 min

Exam Duration

Certiport

~$100

Exam Fee

Certiport

5

Exam Domains

MO-210 Objectives

Never

Expiration

Does not expire

The MO-210 Microsoft Excel exam has approximately 35 performance-based tasks in 50 minutes with a passing score of 700/1000. Key domains: Manage Worksheets and Workbooks (~20%), Manage Data Cells and Ranges (~25%), Manage Tables and Table Data (~20%), Perform Operations by Using Formulas and Functions (~20%), Manage Charts (~15%). No prerequisites. Administered through Certiport authorized centers. Certification does not expire.

Sample MO-210 Practice Questions

Try these sample questions to test your 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 keyboard shortcut inserts the current date as a static value in a cell?
A.Ctrl+Shift+;
B.Ctrl+;
C.Ctrl+D
D.Alt+Enter
Explanation: Ctrl+; inserts today's date as a static value that does not update automatically. This shortcut is useful when you need a fixed timestamp. Ctrl+Shift+; inserts the current time. Ctrl+D copies the value from the cell above, and Alt+Enter inserts a line break within a cell.
2Which Excel function returns the number of cells in a range that meet a single condition?
A.=SUMIF
B.=COUNTIF
C.=AVERAGEIF
D.=COUNTA
Explanation: =COUNTIF(range, criteria) counts the number of cells in a range that satisfy one condition. =SUMIF adds cells that meet a condition, =AVERAGEIF returns the average for matching cells, and =COUNTA counts all non-empty cells regardless of any condition.
3A user wants to prevent rows 1 and 2 from scrolling out of view while working in a large worksheet. What is the correct action?
A.Select row 3, then use View > Freeze Panes > Freeze Panes
B.Select row 1, then use View > Freeze Panes > Freeze Top Row
C.Select row 2, then use View > Freeze Panes > Freeze Top Row
D.Right-click row 2 and choose Lock Row
Explanation: To freeze the top two rows, click on row 3 (the first row that should scroll) and then choose View > Freeze Panes > Freeze Panes. Excel freezes everything above the selected row. Freeze Top Row only locks a single row regardless of selection, and there is no Lock Row right-click option.
4Which formula correctly sums all values in column B where the corresponding cell in column A equals "East"?
A.=COUNTIF(A:A,"East",B:B)
B.=SUMIF(A:A,"East",B:B)
C.=SUMIFS(A:A,"East",B:B)
D.=IF(A:A="East",SUM(B:B))
Explanation: =SUMIF(range, criteria, sum_range) evaluates each cell in the first argument against the criteria and sums the corresponding cells in the sum_range. =COUNTIF returns a count not a sum. =SUMIFS has sum_range as its first argument. The =IF/SUM construct is not valid syntax for conditional summing across a range without array entry.
5When a formula returns the error #VALUE!, what is the most likely cause?
A.A cell referenced by the formula is empty
B.The formula references a cell containing text where a number is expected
C.A required argument is missing from the function
D.The formula result exceeds Excel's maximum number limit
Explanation: #VALUE! occurs when a formula receives the wrong data type — most commonly a text string where a numeric value is required. An empty cell typically returns 0 in arithmetic. Exceeding numeric limits produces #NUM! instead.
6Which of the following correctly describes the difference between an absolute cell reference and a relative cell reference?
A.An absolute reference uses a colon; a relative reference uses a comma
B.An absolute reference stays fixed when copied; a relative reference adjusts to the new location
C.An absolute reference can only refer to values in the same worksheet
D.A relative reference is always faster to calculate than an absolute reference
Explanation: An absolute reference (e.g., $A$1) uses dollar signs to lock the row and/or column so the reference does not change when the formula is copied or filled. A relative reference (e.g., A1) adjusts automatically based on the relative position of the destination. The other options describe incorrect syntax or performance claims.
7A user applies a conditional formatting rule to highlight cells in B2:B20 greater than 100 in red. She then adds new data in B21. Will the conditional formatting apply to B21?
A.Yes, conditional formatting always expands to new rows
B.No, the rule only applies to the original range B2:B20
C.Yes, if the data is inside an Excel Table
D.Only if the workbook is saved and reopened
Explanation: Conditional formatting rules apply only to the range specified when the rule was created. New data added outside that range is not covered unless the range is manually expanded in Manage Rules or the data is inside a formal Excel Table that auto-extends table formatting.
8Which function returns the value from the 3rd row and 2nd column of the array A1:D10?
A.=VLOOKUP(3,A1:D10,2,FALSE)
B.=INDEX(A1:D10,3,2)
C.=MATCH(3,A1:A10,0)
D.=OFFSET(A1,3,2)
Explanation: =INDEX(array, row_num, col_num) returns the value at the intersection of the specified row and column within the array. =INDEX(A1:D10,3,2) returns the value in row 3, column 2 of that range. =VLOOKUP searches for a value in the first column, =MATCH returns a position number, and =OFFSET shifts from a starting cell to return a different cell.
9Which function pair is most flexible for looking up a product name in column A and returning a price from column C, allowing the return column to be to the left of the lookup column?
A.VLOOKUP and HLOOKUP
B.INDEX and MATCH
C.XLOOKUP and OFFSET
D.SUMIF and COUNTIF
Explanation: INDEX and MATCH together handle lookups where the return column can be anywhere relative to the lookup column. MATCH finds the row position of the lookup value, and INDEX retrieves the value at that position from any column. VLOOKUP can only return values to the right of the lookup column.
10Which action renames a worksheet tab in Excel?
A.Right-click the tab and choose Rename
B.Go to Home > Cells > Format > Rename Sheet
C.Either of the above options
D.Press F2 while the tab is selected
Explanation: A worksheet tab can be renamed by right-clicking the tab and choosing Rename, or by going to Home > Cells > Format > Rename Sheet. Both methods are valid. Double-clicking the tab directly also activates rename mode. F2 activates cell edit mode in Excel, not tab rename mode.

About the MO-210 Exam

The MO-210 exam validates associate-level skills in Microsoft Excel for Microsoft 365 Apps. Candidates complete real-world tasks in a live Excel environment covering worksheet and workbook management, data cells and ranges, tables, formulas and functions, and charts. The performance-based format tests practical productivity skills used in business and academic settings.

Questions

35 scored questions

Time Limit

50 minutes

Passing Score

700/1000

Exam Fee

$100 (Certiport (Pearson VUE))

MO-210 Exam Content Outline

~20%

Manage Worksheets and Workbooks

Import data from delimited text files, navigate to named cells and ranges, configure rows and columns, customize worksheet tab color and order, freeze rows/columns, hide/unhide worksheets, configure print area and page layout

~25%

Manage Data Cells and Ranges

Fill cells using Flash Fill and AutoFill, merge cells, modify cell alignment and indentation, format cells using Format Painter, apply number formats, define and reference named ranges, summarize data with Sparklines and conditional formatting

~20%

Manage Tables and Table Data

Create Excel tables from cell ranges, apply table styles, add and remove table rows and columns, configure banded rows and columns, insert Total Row, filter and sort table data using AutoFilter and custom sorts, remove duplicate rows

~20%

Perform Operations by Using Formulas and Functions

Insert relative, absolute, and mixed references; use SUM, AVERAGE, MIN, MAX, COUNT, COUNTA, IF, IFS, SUMIF, COUNTIF, VLOOKUP, XLOOKUP, LEFT, RIGHT, MID, CONCAT, and date functions; perform conditional operations

~15%

Manage Charts

Create column, bar, pie, line, and combo charts; add and modify chart elements (titles, data labels, legends, axes); apply chart styles and colors; move charts to chart sheets; filter chart data

How to Pass the MO-210 Exam

What You Need to Know

  • Passing score: 700/1000
  • Exam length: 35 questions
  • Time limit: 50 minutes
  • Exam fee: $100

Keys to Passing

  • Complete 500+ practice questions
  • Score 80%+ consistently before scheduling
  • Focus on highest-weighted sections
  • Use our AI tutor for tough concepts

MO-210 Study Tips from Top Performers

1Practice formulas with keyboard shortcuts: press F2 to edit a cell, F4 to toggle absolute/relative references
2Know the difference between COUNT (numbers only) vs COUNTA (all non-empty cells) — a common exam trap
3Master VLOOKUP syntax: =VLOOKUP(lookup_value, table_array, col_index_num, [range_lookup])
4Practice creating and modifying Excel Tables (Ctrl+T) — know how structured references like [@Column] work
5Understand conditional formatting: highlight cells rules, data bars, color scales, and icon sets
6Know how to create and modify combo charts (two chart types on one chart with a secondary axis)
7Practice Flash Fill (Ctrl+E) — it's a quick and commonly tested data manipulation tool
8Know how to freeze panes: View tab > Freeze Panes > Freeze Top Row / Freeze First Column / Freeze Panes

Frequently Asked Questions

What is the MO-210 exam?

The MO-210 exam (Microsoft Excel Associate — Microsoft 365 Apps) is a performance-based certification that validates intermediate Excel skills. Candidates complete live in-application tasks in an Excel environment. It is administered by Certiport, a Pearson VUE business, at authorized testing centers.

What functions are tested on MO-210?

The MO-210 exam tests common Excel functions including SUM, AVERAGE, MIN, MAX, COUNT, COUNTA, IF, IFS, SUMIF, COUNTIF, VLOOKUP, XLOOKUP, LEFT, RIGHT, MID, CONCAT, and date functions. You must know function syntax, argument order, and when to use each function for specific business scenarios.

How hard is the MO-210 exam?

The MO-210 is an associate-level exam considered moderate difficulty. Candidates with regular Excel use and 15-25 hours of focused practice typically pass on the first attempt. The key challenge is working efficiently in a live Excel environment within 50 minutes. Formula knowledge and table manipulation are the most tested areas.

What is the difference between MO-210 and MO-211?

MO-210 (Excel Associate) tests core Excel skills: basic formulas, table management, chart creation, and worksheet formatting. MO-211 (Excel Expert) tests advanced skills: complex formulas (XLOOKUP, INDEX/MATCH, nested IF), Power Query, macros, advanced PivotTables, forecasting, and custom data validation. MO-211 is significantly harder.

Where can I take the MO-210 exam?

The MO-210 exam is available exclusively through Certiport authorized testing centers, which include many schools, colleges, libraries, and workforce centers. Visit certiport.pearsonvue.com to find a testing center. The exam is not available via remote online proctoring.

Does the MO-210 certification expire?

No — the MO-210 (MOS Excel) certification does not expire. Once you pass, the credential is permanent. Certiport may release new exam versions as Excel evolves, but your existing credential remains valid indefinitely.