MICROSOFT CERTIFICATION
MO-210 Excel Associate (Microsoft 365 Apps) Practice Exam
Exam Number: 3142 | Last updated 16-Apr-26 | 824+ questions across 4 vendor-aligned objectives
The MO-210 Excel Associate (Microsoft 365 Apps) certification validates the skills of users who demonstrate foundational competency in Microsoft Excel within Microsoft 365 Apps. This exam measures your ability to work with Microsoft Excel (Microsoft 365), Formulas, Charts, Tables, Data Validation, Dynamic Arrays, demonstrating both conceptual understanding and practical implementation skills required in today’s enterprise environments.
The heaviest exam domains include Perform Operations by Using Formulas and Functions (25–30%), Manage Data Cells and Ranges (20–25%), and Manage Worksheets and Workbooks (15–20%). These areas collectively represent the majority of exam content and require focused preparation across their respective subtopics.
Additional domains tested include Manage Tables and Table Data (15–20%), and Manage Charts (15–20%). Together, these areas round out the full exam blueprint and ensure candidates possess well-rounded expertise across the certification scope.
Every answer links to the source. Each explanation below includes a hyperlink to the exact Microsoft documentation page the question was derived from. PowerKram is the only practice platform with source-verified explanations. Learn about our methodology →
779
practice exam users
91.4%
satisfied users
90.1%
passed the exam
4.8/5
quality rating
Test your MO-210 Excel Associate knowledge
10 of 824+ questions
Question #1 - Manage Worksheets and Workbooks
A team collaborates on a budget in Excel for Microsoft 365. Multiple users need to edit the workbook simultaneously with changes synced in real time.
Which feature enables this concurrent editing?
A) Protect the workbook
B) Use Track Changes
C) Co-authoring when the workbook is saved to OneDrive or SharePoint
D) Email the file back and forth
Show solution
Correct answers: D – Explanation:
Co-authoring in M365 allows simultaneous editing when the file is stored in a cloud location. Emailing creates separate copies. Track Changes records edits but does not enable concurrent access. Workbook protection restricts changes. Source: Check Source
Question #2 - Manage Worksheets and Workbooks
A team collaborates on a budget in Excel for M365. Multiple users need to edit the workbook simultaneously with real-time sync.
Which feature enables this concurrent editing?
A) Protecting the workbook with a password to restrict structural changes by multiple users
B) Co-authoring when the workbook is saved to OneDrive or SharePoint for cloud collaboration
C) Emailing the file back and forth between team members creating separate diverging copies
D) Enabling Track Changes to record modifications without allowing simultaneous editing
Show solution
Correct answers: B – Explanation:
Co-authoring in M365 allows simultaneous editing with real-time sync when the file is stored in a cloud location accessible to all team members. Emailing creates independent copies that diverge with each round of edits between team members. Track Changes records modifications sequentially but does not enable multiple people to edit the same file simultaneously. Workbook protection restricts structural changes and does not facilitate concurrent multi-user editing. Source: Check Source
Question #3 - Manage Worksheets and Workbooks
Sheet1 calculations reference cells in Sheet2 and Sheet3. The analyst needs to verify all cross-sheet references are intact.
Which tool traces cell dependencies across sheets?
A) Review every formula by reading through the worksheet without any visual mapping assistance
B) Trace Dependents and Trace Precedents from the Formulas tab mapping cell relationships visually
C) Search for sheet names manually in the formula bar examining each cell formula individually
D) Print all three sheets and compare the printouts visually side by side looking for references
Show solution
Correct answers: B – Explanation:
Trace Dependents and Precedents visually map cell relationships including cross-sheet references with directional arrows showing data flow between cells. Manual formula bar searching requires examining cells one at a time without visual context of the overall dependency graph. Reading through formulas without mapping is slow and misses complex multi-level dependency chains across sheets. Printed sheets show static content without revealing the dynamic formula relationships between cells. Source: Check Source
Question #4 - Manage Data Cells and Ranges
A data entry clerk enters dates but Excel sometimes interprets entries as text rather than dates, causing sort errors.
Which approach ensures consistent date entry?
A) Type dates in any freestyle format and trust Excel to interpret them correctly every time
B) Apply Date format to the column and use Data Validation accepting only valid date entries
C) Use a text format for all date cells which prevents Excel from performing date calculations
D) Enter all dates as pure numeric values without any date formatting applied to the cells
Show solution
Correct answers: B – Explanation:
Pre-formatting columns as Date and applying date-only validation ensures consistent entry, proper chronological sorting, and correct date arithmetic calculations. Freestyle entry leads to inconsistent interpretation where some entries become text and others become dates. Pure numbers without date formatting lose the human-readable date context making data interpretation difficult. Text formatting prevents all date-based calculations, sorting, and time intelligence functions from working correctly. Source: Check Source
Question #5 - Manage Data Cells and Ranges
Employee certifications with expiry dates need yellow highlighting within 30 days of expiry and red when expired.
Which feature creates this multi-condition visual alert?
A) Manual cell coloring applied by hand which does not automatically update when dates change
B) Data bars showing the relative magnitude of date values without threshold-based color changes
C) Two Conditional Formatting rules using TODAY-based formulas for within-30-days and past-due
D) Icon sets displaying fixed symbols without the custom date-aware condition logic required
Show solution
Correct answers: C – Explanation:
Multiple Conditional Formatting rules with formula-based conditions referencing TODAY() create dynamic, date-aware color coding that updates automatically each day. Manual coloring requires daily review and recoloring as dates pass thresholds which is not sustainable. Data bars display relative magnitude visually but cannot distinguish between specific threshold-based date categories. Icon sets provide predefined symbol options but lack the custom date-aware formula evaluation needed for expiry-based logic. Source: Check Source
Question #6 - Manage Tables and Table Data
An Excel Table named Sales needs a calculated column multiplying Quantity by Unit_Price, auto-extending to new rows.
Which formula approach works best within an Excel Table?
A) Write a VBA macro that loops through rows and inserts multiplication formulas programmatically
B) Type a standard cell reference formula like =C2*D2 and manually copy it down for each new row
C) Use a separate SUMPRODUCT formula that aggregates all rows rather than calculating per row
D) Enter a structured reference formula like [@Quantity]*[@Unit_Price] which auto-fills the column
Show solution
Correct answers: D – Explanation:
Structured references in Tables using the [@Column] syntax auto-fill the entire column and automatically extend to new rows added to the table. Standard cell references like =C2*D2 require manual copying down and do not auto-extend when new table rows are added. VBA macros add programming complexity for what is a native table formula feature available without any code. SUMPRODUCT aggregates across rows producing a single total rather than the per-row calculation needed for each line. Source: Check Source
Question #7 - Manage Tables and Table Data
An analyst has 50,000 rows and needs to remove all rows where Status is “Cancelled” in one efficient operation.
Which method efficiently removes these rows?
A) Filter the table by Status equals Cancelled, select all visible filtered rows, then delete them
B) Use Find and Replace to blank the Status cells which leaves empty rows without removing them
C) Scroll through all 50,000 rows individually deleting each Cancelled row encountered one at a time
D) Sort by Status column and hope the Cancelled rows group together for easier visual identification
Show solution
Correct answers: A – Explanation:
Filtering isolates the target rows displaying only Cancelled entries, and deleting visible rows removes only the filtered set in one efficient bulk operation. Row-by-row deletion through 50,000 entries is impractical and extremely time-consuming. Find and Replace blanking leaves empty rows in the dataset without actually removing them from the table. Sorting groups Cancelled rows together but still requires manual selection and deletion after the sort completes. Source: Check Source
Question #8 - Perform Operations by Using Formulas and Functions
M365 Excel introduces dynamic arrays. An analyst needs all unique values from a column containing duplicates without helper columns.
Which M365 function returns unique values as a spilled array?
A) #NAME?
B) #NAME?
C) #NAME?
D) #NAME?
Show solution
Correct answers: C – Explanation:
UNIQUE returns distinct values from a range as a dynamic spilled array, eliminating duplicates without helper columns or complex formula construction. VLOOKUP retrieves a single matching value per lookup call and cannot extract all unique values from a list. COUNTIF counts how many times each value appears but does not extract or return the distinct values themselves. SORT reorders all values including duplicates in the specified order without removing any repeated entries. Source: Check Source
Question #9 - Perform Operations by Using Formulas and Functions
An analyst needs only rows where Region is “West” returned as a dynamic array without manual filtering.
Which M365 dynamic array function accomplishes this?
A) #NAME?
B) #NAME?
C) #NAME?
D)
Show solution
Correct answers: D – Explanation:
FILTER returns all rows matching the specified condition as a dynamic spilled array, creating a filtered subset without modifying the original data. SUMIFS aggregates qualifying values into a single sum total rather than returning the individual matching rows. IF evaluates one condition per cell and cannot return multiple filtered rows from a table as a dynamic array. XLOOKUP retrieves a single match per lookup and cannot return all rows that match the filter criteria. Source: Check Source
Question #10 - Perform Operations by Using Formulas and Functions
A teacher wants student names sorted alphabetically via formula that auto-updates when new names are added.
Which dynamic array function sorts values automatically?
A)
B) #NAME?
C) #NAME?
D) #NAME?
Show solution
Correct answers: A – Explanation:
SORT returns the specified range in sorted order as a dynamic spilled array that automatically updates when source data changes or new entries are added. RANK assigns numerical rank positions to values but does not physically reorder or output them in sorted sequence. INDEX retrieves a value at a specific row-column intersection without any sorting or ordering functionality. LARGE returns the nth largest single numeric value rather than sorting an entire range of text names. Source: Check Source
Get 824+ more questions with source-linked explanations
Every answer traces to the exact Microsoft documentation page — so you learn from the source, not just memorize answers.
Exam mode & learn mode · Score by objective · Updated 16-Apr-26
Learn more...
What the MO-210 Excel Associate exam measures
- Manage Worksheets and Workbooks (15–20%) — Evaluate your ability to implement and manage tasks within this domain, including real-world job skills and scenario-based problem solving.
- Manage Data Cells and Ranges (20–25%) — Evaluate your ability to implement and manage tasks within this domain, including real-world job skills and scenario-based problem solving.
- Manage Tables and Table Data (15–20%) — Evaluate your ability to implement and manage tasks within this domain, including real-world job skills and scenario-based problem solving.
- Perform Operations by Using Formulas and Functions (25–30%) — Evaluate your ability to implement and manage tasks within this domain, including real-world job skills and scenario-based problem solving.
- Manage Charts (15–20%) — Evaluate your ability to implement and manage tasks within this domain, including real-world job skills and scenario-based problem solving.
How to prepare for this exam
- Review the official exam guide to understand every objective and domain weight before you begin studying
- Complete the relevant Microsoft Learn learning path to build a structured foundation across all exam topics
- Get hands-on practice in an Azure free-tier sandbox or trial environment to reinforce what you have studied with real configurations
- Apply your knowledge through real-world project experience — whether at work, in volunteer roles, or contributing to open-source initiatives
- Master one objective at a time, starting with the highest-weighted domain to maximize your score potential early
- Use PowerKram learn mode to study by individual objective and review detailed explanations for every question
- Switch to PowerKram exam mode to simulate the real test experience with randomized questions and timed conditions
Career paths and salary outlook
Earning this certification can open doors to several in-demand roles:
- Data Entry Specialist: $45,000–$60,000 per year (based on Glassdoor and ZipRecruiter data)
- Office Administrator: $50,000–$65,000 per year (based on Glassdoor and ZipRecruiter data)
- Junior Data Analyst: $55,000–$75,000 per year (based on Glassdoor and ZipRecruiter data)
Official resources
Microsoft provides comprehensive free training to prepare for the MO-210 Excel Associate (Microsoft 365 Apps) exam. Start with the official Microsoft Learn learning path for structured, self-paced modules covering every exam domain. Review the exam study guide for the complete skills outline and recent updates.