Preparing for the MO-210 Excel exam

MO-210 is the Microsoft exam for Excel Associate (Microsoft 365 Apps). You get 50 minutes and work on practical tasks under supervision. Here you practise every part and test yourself with a practice exam. LearnExcel is not official training and does not award a Microsoft certification.

🔒 The MO-210 practice exam is part of the Advanced module. With that module you practise every part and take the practice exam as often as you like.

See the modules

Take the practice exam See the lessons

Every part, and how you practise it

With Worksheet you actually do it and it gets checked. With Menu you find the right button in a practice ribbon that works and looks like the Excel menu, with tabs and lists that drop down. Afterwards, try those steps in your own Excel too.

Try it yourself

Clipboard

Font

Alignment

Number

Styles

Cells

Editing

Managing worksheets and workbooks

Managing cells and ranges

Filling cellsWorksheet
Paste Special, inserting and deleting rows and cellsMenu
RANDBETWEEN and SEQUENCEWorksheet
Merging, alignment, wrap text, Format Painter, number formatsMenu
Named rangesWorksheet
Applying sparklines and conditional formattingMenu

Managing tables and table data

Performing operations with formulas and functions

Relative, absolute and mixed referencesWorksheet
Structured references in tablesWorksheet
AVERAGE, MAX, MIN and SUMWorksheet
COUNT, COUNTA and COUNTBLANKWorksheet
IFWorksheet
SORT and UNIQUEWorksheet
LEFT, RIGHT, MID, UPPER, LOWER and LENWorksheet
CONCAT and TEXTJOINWorksheet

Managing charts

Creating chartsWorksheet
Chart sheetsMenu
Adding series, switching rows and columnsMenu
Chart elements, layouts and stylesMenu
Alt textMenu

Based on the Certiport overview of exam objectives. Check the current objectives with Microsoft or Certiport before you book your exam.

Frequently asked questions

Will this get me ready for the exam?

We can't promise that. You practise every part here, but the real exam takes place in real Excel and against the clock. So try the menu exercises in your own Excel as well.

Is MO-210 the same as MO-200?

Both are Excel Associate exams. MO-200 covers Office 2019, MO-210 covers Microsoft 365 Apps and also asks about newer functions such as SORT and UNIQUE.

Can I take the official exam with LearnExcel?

No. The official exam runs through Certiport and a test centre. Microsoft lists the current conditions and prices on its own website.

Which language is the exam in?

Microsoft offers Excel Associate in several languages, English among them. Check with your test centre before you book.