Microsoft Office Specialist: Excel Exam Preparation: final exam 2026
A new random set of 35 questions from the course every time. Score 80% or more to download your certificate. You see your answers at the end.
- 35 questions
- Score 80% or more to download your certificate.
- 50 minutes
How this mock exam works
Each attempt draws 35 questions at random from all 90 questions for this test, so no two attempts are the same.
The official test has these parts:
- 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%)
At the end you see your score, every answer and its explanation. Your best score is saved in this browser, so you can try again until you pass comfortably.
What you will learn
- Describe the MO-210 exam format, timing, scoring and five skill areas
- Import data, navigate workbooks, and set views, print settings, headers and footers
- Prepare a workbook for sharing with the right file format, the Document Inspector, comments and notes
- Fill and format cells with Paste Special, Auto Fill, SEQUENCE, named ranges, sparklines and conditional formatting
- Create, change, sort and filter Excel tables with a total row
- Write formulas with relative, absolute, mixed and structured references and the functions on the skills list
- Create and format charts and chart sheets, including alt text
Score 80% or more to download your certificate.