233+ Free MO-210 Practice Questions

Prepare for the Microsoft Excel (Microsoft 365 Apps) (MO-210) exam with instant access — no signup required.

✓ No registration✓ No credit card✓ No hidden fees✓ Start practicing immediately

233+ Questions

100% Free

Loading practice questions...

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.

More From This Family

Videos and articles for deeper review.

VideoFREE DP-600 Exam Guide 2026: Pass Microsoft Fabric Analytics Engineer (Direct Lake, DAX, Semantic Models)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)VideoIs PL-300 Worth It in 2026? Power BI Salary & Career Reality ArticlePL-200 Exam Guide 2026: Skills, Retirement, and Renewal12 min read ArticlePL-400 Exam Guide 2026: Skills, Format, and Renewal12 min read ArticlePL-900 Exam Guide 2026: Current Outline and Free Prep19 min read ArticleMS-900 Retired 2026: FREE Guide + AB-900 Pivot17 min read

2026 Statistics

Key Facts: MO-210 Exam

Published Sub-Objectives

Certiport MO-210 objective domain

700/1000

Passing Score

Certiport

50 min

Exam Duration

Certiport

Regional

Testing-Center Pricing

Microsoft Learn

Exam Domains

MO-210 Objectives

5 years

Validity (MOS on/after Sep 23, 2025)

Certiport certification expiration policy

The MO-210 Microsoft Excel exam is performance-based, delivered live in Excel in 50 minutes with a passing scaled score of 700/1000; Microsoft and Certiport do not publish a fixed task count. The five official skill ranges are 25-30%, 25-30%, 10-15%, 15-20%, and 15-20%. No prerequisites. Administered through Certiport authorized centers, which can also deliver it remotely via Certiport Exams from Home. MOS credentials earned on or after September 23, 2025 are valid for five years from issue.

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 233+ 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.

Assessment

Performance-based assessment

Time Limit

50 minutes

Passing Score

700/1000

Exam Fee

Varies by country/region and Certiport Authorized Testing Center (Certiport (Pearson VUE))

MO-210 Exam Content Outline

25-30%

Manage Worksheets and Workbooks

Import data from text files and online sources; navigate workbooks; manage hyperlinks, page setup, dimensions, headers, views, properties, printing, inspection, comments, and notes

25-30%

Manage Data Cells and Ranges

Paste and fill data; insert and delete cells; generate sequences; format cells and ranges; group worksheets; define named ranges; insert sparklines; apply conditional formatting

10-15%

Manage Tables and Table Data

Create and style tables, convert tables to ranges, modify rows and columns, configure style options and total rows, and filter and sort records

15-20%

Perform Operations by Using Formulas and Functions

Use relative, absolute, mixed, and structured references; calculate with core functions; transform lists with SORT and UNIQUE; and modify text with named functions

15-20%

Manage Charts

Create charts and chart sheets, add series, switch rows and columns, modify elements, apply layouts and styles, and add alternative text

How to Pass the MO-210 Exam

What You Need to Know

Passing score: 700/1000
Assessment: Performance-based assessment
Time limit: 50 minutes
Exam fee: Varies by country/region and Certiport Authorized Testing Center

Keys to Passing

Work through all 233 available questions
Review every answer and explanation
Track weak areas and revisit them
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

3Practice absolute references with F4 while editing — tax rates and constants must stay fixed when you fill formulas down

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

6Practice the eight listed chart skills: create charts, create chart sheets, add data series, switch rows/columns, add and modify chart elements, apply layouts, apply styles, and add alternative text

7Auto Fill — not Flash Fill — is the fill skill the objective domain names; know the fill handle, Fill Series, and the right-click fill menu

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 Associate exam focuses on core Excel functions including SUM, AVERAGE, MIN, MAX, COUNT, COUNTA, COUNTBLANK, IF, SORT, UNIQUE, LEFT, RIGHT, MID, UPPER, LOWER, LEN, CONCAT, and TEXTJOIN, plus relative, absolute, mixed, and structured references. Advanced lookups such as VLOOKUP and XLOOKUP belong to the Expert exam (MO-211), not the Associate blueprint.

How hard is the MO-210 exam?

MO-210 is an associate-level, 50-minute performance exam. Microsoft recommends approximately 150 hours of instruction and hands-on Excel experience; it does not publish a pass rate or a universal preparation duration that guarantees success.

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 delivered through Certiport authorized testing centers, which include many schools, colleges, libraries, and workforce centers. Visit certiport.pearsonvue.com to find a testing center. Centers can also administer it remotely through Certiport's Exams from Home solution, which streams the live Excel environment via a secure browser with a center proctor supervising — Certiport still encourages onsite testing when possible, and you schedule through a center either way rather than booking an at-home slot yourself.

Does the MO-210 certification expire?

Under Certiport’s current policy, Microsoft Office Specialist credentials earned on or after September 23, 2025 are valid for five years from the issue date. MOS credentials earned before that date remain non-expiring. When a MOS credential expires, you recertify by passing the current exam version.

233+ Free MO-210 Practice Questions

Microsoft Excel (Microsoft 365 Apps) (MO-210)

Explore More Microsoft Certifications

Microsoft Power BI Data Analyst

Microsoft 365 Administrator Expert (MS-102)

Microsoft 365 Endpoint Administrator (MD-102)

Microsoft Certified: Information Security Administrator Associate (SC-401)

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

Microsoft Power Platform Developer (PL-400)