Loading…
Loading…
Certification prep
The MO-200 exam (Microsoft Office Specialist: Excel Associate) is project-based: you complete tasks in a live copy of Excel rather than answering multiple-choice questions. This practice test works the same way, with timed hands-on tasks across the five exam skill areas, graded instantly.
Microsoft groups the exam into five areas. Each row below is one task in the practice test, with the lessons that teach it.
Fill series
Fill formulas and series down and across with the fill handle or Ctrl+D / Ctrl+R.
Number formats
Apply currency, percentage and date formats, bold and other cell formatting.
Excel Tables
Turn a range into a Table, add a total row and use structured references.
SUM / AVERAGE / MIN / MAX
The core summary functions.
COUNT / COUNTA / COUNTBLANK
Count numbers, non-empty cells and blanks.
Text functions
LEFT, RIGHT, MID, UPPER, LOWER, PROPER, LEN, CONCAT and TEXTJOIN.
LEN, LEFT, RIGHT, MID Practice · UPPER, LOWER, and PROPER Functions
Charts
Create and change charts, add series and set chart elements.
MO-200 is taken at a test centre or online with a proctor. You get a series of small projects, each a workbook with several tasks, and you complete them in Excel itself. You are marked on the end result, so any correct method counts.
Microsoft updates the objectives from time to time, so check the official exam page for the current skills outline, timing and pass mark before you book.
Take the practice test once to find your weak areas. Work through the linked lessons for anything you missed, then take another version. The exam rewards speed as well as accuracy, so do the shortcut speed drill a few times as well, and practise tables, charts and conditional formatting until you can do them without thinking.
No. It is independent practice that covers the same skill areas. It is not affiliated with or endorsed by Microsoft, and passing it does not give you a certification.
Yes, all three versions. Some table, chart and formatting tasks are premium lessons; without Premium those slots use the free preview tasks of the lesson instead.
MO-200 is the Associate level: everyday worksheets, tables, formulas and charts. MO-201 is the Expert level, adding advanced formulas, macros, data analysis and advanced charts.
No. Everything runs in a live spreadsheet in your browser.
Ready to see where you stand?
Take the practice testMicrosoft, Excel and Microsoft Office Specialist are trademarks of the Microsoft group of companies. FluentExcel is not affiliated with or endorsed by Microsoft.