The MOS Excel Associate Exam: What's Actually on It (and What Trips People Up)

The MOS Excel Associate exam covers five topic areas. Knowing what they are isn't enough, you need to know what's inside each one, which tasks are straightforward, and which ones catch people off guard.

This is a breakdown of all five domains, with the details that actually matter for exam day.

1. Managing worksheets and workbooks (10-15%)
2. Managing data cells and ranges (20-25%)
3. Managing tables and table data (15-20%)
4. Performing operations with formulas and functions (20-25%)
5. Managing charts (20-25%)

1. Manage worksheets and workbooks (10-15%)

2. Manage data cells and ranges (20-25%)

This is one of the heavier sections. It covers Paste Special (values, formats, transpose), Auto Fill, inserting and deleting rows, columns, and cells, and all the core formatting tools: merge and unmerge, alignment, orientation, indentation, Format Painter, wrap text, number formats, the Format Cells dialog, cell styles, and clearing formatting.

It also covers defining named ranges, naming tables, inserting Sparklines, and applying or removing conditional formatting.

What trips people up: Format Painter. Click once to apply it once, double-click to keep it active for multiple applications. The exam may test whether you know the difference. Also: clearing formatting removes styles but keeps content. The option is under Home → Clear → Clear Formats.

3. Manage tables and table data (15-20%)

This section focuses on Excel tables, not just data formatted to look like a table, but actual Excel table objects (created via Insert → Table or Ctrl+T). It covers creating tables from cell ranges, applying table styles, converting tables back to ranges, adding or removing rows and columns, configuring table style options, inserting total rows, filtering records, and sorting by multiple columns.

What trips people up: The total row. When you insert a total row via Table Design, the default function is SUM, but the dropdown in each cell lets you switch to AVERAGE, COUNT, MAX, and others. Know this exists and how to change it.

4. Formulas and functions (20-25%)

This is the section with the most specific knowledge requirements. You need to know the difference between relative references (=A1, shifts when copied), absolute references (=$A$1, locked press F4 to toggle), and mixed references (=$A1 or =A$1, locks either the row or column).

Functions tested include: AVERAGE, MAX, MIN, SUM, COUNT, COUNTA, COUNTBLANK, IF, RIGHT, LEFT, MID, UPPER, LOWER, LEN, CONCAT, and TEXTJOIN.

What trips people up: COUNT vs COUNTA vs COUNTBLANK. COUNT counts cells containing numbers only. COUNTA counts any non-empty cell. COUNTBLANK counts empty cells. These are tested separately and the distinction is specific.

Also: TEXTJOIN takes three arguments, the delimiter, whether to ignore empty cells (TRUE/FALSE), and the range. The argument order matters.

5. Manage charts (20–25%)

The final section covers creating charts from data, creating chart sheets (a chart on its own dedicated sheet, separate from the data), adding data series, switching between rows and columns in source data, adding and modifying chart elements (titles, axes, legends, data labels), applying chart layouts and styles, and adding alternative text to charts for accessibility.

What trips people up: Creating a chart sheet specifically. Most students know how to insert a chart into a worksheet. A chart sheet is different, right-click the chart → Move Chart → New Sheet. This comes up in the exam and catches people who haven't specifically practised it.

How to use this breakdown

Go through each domain and be honest about which tasks you'd struggle to do from memory in a timed environment. The exam doesn't give you time to explore menus, you need to know where things are before you sit down.

Practise in Excel itself. Study guides tell you what's on the exam. Only hands-on practice tells you whether you can actually do it.

How Spuddle helps you work through every domain