MO-211: Manage and Format Data

Flash Fill recognizes a pattern from an example you type (splitting a full name into first and last, or extracting a domain from an email address) and fills the rest of the column to match — without a formula. It's triggered from Data > Flash Fill or Ctrl+E, and it only works reliably when your example is unambiguous; a messy or inconsistent source column can make Flash Fill guess wrong, so check the result rather than trusting it blindly.

Advanced Fill Series options go beyond the basic drag-to-fill: a linear or growth trend, a specific step value, or filling by weekdays only instead of every calendar day, all live under Home > Fill > Series.

RANDARRAY() generates an array of random numbers across a size and range you specify, and — unlike the older RAND()/RANDBETWEEN() single-cell functions — spills its results across multiple cells from one formula. It's a newer dynamic-array function, so if your prior Excel experience predates dynamic arrays, this is worth deliberately practicing rather than assuming familiarity.

Custom number formats use format codes (like #,##0.00 or a placeholder syntax with semicolons for positive;negative;zero;text sections) rather than the built-in presets — this is where MO-211 goes beyond MO-210's basic 'apply a number format' skill into building your own display pattern.

Data validation restricts what can be entered into a cell — a list of allowed values, a number range, a date range, or a custom formula-based rule — and is commonly tested by asking you to build a dropdown list or restrict entries to a range.

Group and ungroup data (Data > Group, with the +/- outline controls), Subtotals (Data > Subtotal, which requires sorted data first), and Remove Duplicates round out this group — all data-organization tools rather than formula tools, and all reversible if you check the wrong option, so it's worth confirming the result matches what was asked before moving on.

MO-210 tests applying a built-in conditional-formatting rule. MO-211 goes further: creating a custom rule from scratch, and — the part that trips people up — creating a conditional-formatting rule driven by a formula rather than one of the built-in comparisons.

A formula-based conditional-formatting rule needs the formula to evaluate to TRUE or FALSE for the active cell of the selected range, and it is easy to get the relative/absolute referencing wrong so the rule applies to the wrong cells or doesn't fire at all — this is one of the more finicky skills on the whole exam and worth deliberate practice, not just reading about.

Managing conditional formatting rules — viewing, editing, reordering, and deleting existing rules via Conditional Formatting > Manage Rules — matters when a task asks you to fix or remove a rule rather than create one; check the Applies To range as well as the rule logic, since a correct rule on the wrong range still fails.