What does MO-210's Manage Data Cells and Ranges domain cover?
Tied for the heaviest domain on MO-210 at 25-30%, this one is about manipulating, formatting, naming, and visually summarizing data — everything short of building a formula. It covers four skill groups: manipulating data in the worksheet, formatting cells and ranges, defining and referencing named ranges, and summarizing data visually with sparklines and conditional formatting. The formatting group alone has nine distinct skills, which is where most of the domain's points live.
Checked against Microsoft’s own published pages on September 16, 2026.
The numbers
Manipulating data: special paste, Auto Fill, and two functions most people skip
This group covers pasting with special paste options (values only, formats only, transpose, and the rest of the Paste Special dialog), filling cells with Auto Fill, inserting and deleting multiple rows or columns or cells, and generating numeric data with RANDBETWEEN() and SEQUENCE().
RANDBETWEEN() and SEQUENCE() specifically are worth a deliberate look if you have not used them: RANDBETWEEN(bottom, top) returns a random integer in a range, and SEQUENCE() fills an array with a sequence of numbers without dragging a fill handle. Both are the kind of function a task can name directly, since the exam does sometimes ask for a specific function by name when there is no other reasonable way to phrase the outcome.
Formatting cells and ranges — the largest single skill group on the exam
Nine distinct skills live here: merging and unmerging cells, modifying alignment/orientation/indentation, using Format Painter, wrapping text, applying number formats, using the Format Cells dialog, applying cell styles, clearing formatting, and formatting multiple worksheets at once by grouping them.
Grouped-worksheet formatting is the one candidates most often miss, because it requires selecting multiple sheet tabs (Ctrl-click or Shift-click) before applying a format — miss that step and you format one sheet instead of several, and the task's check is looking for the change on every sheet in the group.
Named ranges: define once, use correctly
Only two skills, but they matter: defining a named range (Formulas > Define Name, or the Name Box) and referencing one in a formula. A task built around named ranges is checking that the name exists with the exact scope and range specified, and that a formula elsewhere actually uses the name rather than the raw cell reference.
Summarizing data visually: sparklines and conditional formatting
This group covers inserting Sparklines (tiny in-cell charts), applying built-in conditional formatting rules (color scales, data bars, icon sets, and the top/bottom and highlight-cells presets), and removing conditional formatting. All three live on the Insert and Home ribbon tabs respectively and are quick to rehearse.
The most common miss is applying a conditional-formatting preset that looks similar but is not the one requested — 'highlight cells greater than' and a color-scale rule produce visually different results even on the same data, and the check is looking for the specific rule type.
What costs people points
A task phrased for multiple worksheets requires grouping the sheet tabs first. Applying the format to the active sheet alone satisfies the letter of the task and fails the check, because the other sheets in scope were never touched.
A generic Ctrl+V after copying formatted or formula-driven cells can carry over more (or less) than a task wants. If a task says "paste values only" or "paste formats only," use Paste Special explicitly rather than trusting a default paste to happen to match.
Color scales, data bars, icon sets, and simple highlight rules all live under Conditional Formatting and can look superficially similar in the result. Match the rule type the task actually names, not just a formatting effect that resembles it.
Related questions
What are RANDBETWEEN() and SEQUENCE() used for on MO-210?
RANDBETWEEN(bottom, top) generates a random whole number in a range; SEQUENCE() fills a range of cells with a sequence of numbers automatically. Both are explicitly in scope under "generate numeric data," and worth practicing directly since a task can name them.
Do I need to know every option in the Format Cells dialog?
You need working familiarity with number formats, alignment, and cell styles — the dialog itself (Ctrl+1) is the fastest way to reach most of them, and "apply cell formats from the Format Cells dialog box" is one of the nine listed skills in this domain.
Is this domain about formulas?
No. Formulas and functions are their own separate domain, worth only 15-20%. This domain is about manipulating, formatting, naming, and visually summarizing data — everything except writing a calculation.
Sources
Read on September 16, 2026. Where this page says something is not published, that means we looked and did not find it — check for yourself.
Keep reading
Find out what you would actually score
Take a full, timed MO-210 practice exam, upload the workbook you built, and get a score out of 1000 with a per-task breakdown of where the points went. Your first one is free.
No credit card needed.