MO-210 practice exam: Excel Associate exam simulator
A timed practice exam in the MO-210 format: hands-on tasks you solve in a spreadsheet inside your browser, like the real exam, which is taken inside Excel. Our practice exam is in Spanish, with the Spanish function names, because the course is taught in Spanish. Below: the skills measured, five sample tasks (in English) with solutions and answers to common questions.
- 📝 14 questions and tasks
- ⏱ 15 minutes
- 📊 Score from 100 to 900
- 💻 Nothing to install
Our MO-210 practice exam is in Spanish, with the Spanish Excel function names, because the course is taught in Spanish.
What the MO-210 exam covers
Exam facts published by Microsoft:
| Item | Detail |
|---|---|
| Exam code | MO-210 (Microsoft Office Specialist: Excel Associate) |
| Format | Hands-on tasks inside Excel, grouped into projects; no multiple-choice |
| Time | 50 minutes |
| Passing score | 700 on a scale of 1 to 1000 |
| Where | At an authorized Certiport test center, or online where available |
Skills measured and their weight
| Area | Weight |
|---|---|
| Manage worksheets and workbooks | 25–30% |
| Manage data cells and ranges | 25–30% |
| Manage tables and table data | 10–15% |
| Perform operations by using formulas and functions | 15–20% |
| Manage charts | 15–20% |
MO-210 sample questions with answers
Original questions written from the public exam objectives, like the ones in the practice exam. Try to answer before opening the explanation.
On the Sales sheet, calculate in E2 the commission on the sale in D2 using the rate in B1, so the formula can be copied down without the rate reference moving.
Show the answer and explanation
Solution:
=D2*$B$1The $ signs lock the column and row of B1 (absolute reference). When you copy the formula, D2 becomes D3, D4… but $B$1 stays put. Press F4 to add the $ signs.
In F2, show "Target" if the sale in D2 is 1000 or more, and "Pending" if it is less.
Show the answer and explanation
Solution:
=IF(D2>=1000,"Target","Pending")IF tests a condition and returns one value when it is true and another when it is false. Depending on regional settings, the argument separator is a comma or a semicolon.
In C2, join the first name in A2 and the last name in B2 with a space between them.
Show the answer and explanation
Solution:
=CONCAT(A2," ",B2)CONCAT joins text; the space goes in quotes as another piece of text. The & operator also works: =A2&" "&B2.
Highlight the amounts in column D that are less than 1000 with a light red fill.
Show the answer and explanation
Solution:
Select column D › Home › Conditional Formatting › Highlight Cells Rules › Less Than › 1000 › Light Red Fill.Conditional formatting changes the format based on the cell value and updates automatically when the data changes.
Convert the range A1:F200 into a table and add a total row.
Show the answer and explanation
Solution:
Select the range › Ctrl + T (Insert › Table) › Table Design › check Total Row.The table uses the first row as headers, grows automatically with new data, and the total row lets you pick sum, average or count for each column.
MO-210 practice test: frequently asked questions
No. Our practice exam is in Spanish, with the Spanish function names, because the course is taught in Spanish and the MO-210 can be taken in Spanish. The sample tasks on this page are in English.
MO-210 is not multiple-choice: you complete hands-on tasks inside Excel, grouped into projects, in 50 minutes. Microsoft does not publish the number of tasks. The passing score is 700 on a scale of 1 to 1000.
No. They are original questions written by HacksinCodigos from the public exam objectives. Real exam questions are confidential: Microsoft's rules prohibit using leaked questions ("dumps" or PDFs that claim to contain the exam), and candidates who do risk having their certification revoked and being banned from future exams. Memorized answers also won't help you with performance-based questions or on the job. Practice with original questions and read the explanation for every answer.
No. The tasks run in a spreadsheet inside your browser. For the real exam, also practice in Excel for Microsoft 365, because the exam is taken inside Excel.
A good sign is finishing full practice exams on time without hints, and knowing more than one way to do each task: from the ribbon, the right-click menu and keyboard shortcuts.
Want the full MO-210 practice exams?
The course includes 2 full practice exams, 16 lessons with hands-on labs and a per-domain report of what to review. It is taught in Spanish, online, and you can take it from any country. US$99, one payment for 12 months of access.
HacksinCodigos is not affiliated with, sponsored by or endorsed by Microsoft. Microsoft and Microsoft Office Specialist: Excel Associate are trademarks of their respective owners, used only to describe the exam this course prepares you for. All practice questions are original, written by HacksinCodigos from the public exam objectives; they are not questions from the real exam. The certification is granted only by its owner when you pass the official exam, and no course guarantees a passing result. Course terms · Privacy.