What does MO-210's Manage Tables and Table Data domain test?

The skills here are creating an Excel table from a cell range (Ctrl+T or Insert > Table), applying a table style, and converting a table back to a plain cell range. The distinction that matters: a range with borders and shading looks like a table but is not one, and a task asking you to create a table is checking for the actual Table object — which brings structured references, an automatic header row, and banded formatting with it.

Converting a table back to a range (Table Design > Convert to Range) removes that special behavior while keeping the formatting, which is its own distinct, checkable action if a task specifically asks for it.

This group covers adding or removing table rows and columns, configuring table style options (banded rows, banded columns, first/last column emphasis, the header row toggle, and the filter-button toggle), and inserting or configuring a total row.

The total row specifically is worth rehearsing: Table Design > Total Row adds a row that defaults to a sum on the last numeric column, and each cell in that row is a dropdown you can change to average, count, max, min, or another summary function — a task can ask for a specific summary, not just "a total row."

The final group is filtering records and sorting by multiple columns, both native to a table's built-in filter dropdowns rather than the separate Data > Sort & Filter tools. Sorting by multiple columns specifically means using the Sort dialog to add more than one level, not just clicking a single column's sort arrow twice.

Because this is scoped to table data specifically, a task built around this domain expects you to use the table's own filter/sort controls — using the ribbon's general Data > Filter on a plain range instead of the table's dropdowns produces a similar-looking result that a table-specific check may not recognize.