MO-210 common mistakes
MO-210 · Understand the traps and how to avoid them.
Building a 'table' by selecting a range and applying banded fill colours and outer borders by hand, instead of using Insert > Table (Ctrl+T).
The result looks identical on screen, so candidates assume the objective 'create and format a table' is satisfied and never notice the range is still a plain range with no name, no structured references, and no filter buttons.
What to do instead
Convert the range with Insert > Table (confirm 'My data has headers'), then set the name in Table Design > Table Name and apply a Table Style. Verify by clicking any cell - the Table Design tab must appear on the ribbon.
Selecting a single cell in one column and clicking Data > Sort A to Z, which reorders that column alone and detaches the values from their row labels.
Excel shows a 'Expand the selection' prompt and candidates dismiss it, or they highlight one column first because the task text mentions only that column.
What to do instead
Click any cell inside the table/range (or select the whole range including headers) and sort from the header dropdown, or use Data > Sort and tick 'My data has headers'. Always check that the adjacent columns moved with the sorted one.
Filling a formula across or down without anchoring the fixed reference (typing =B2*C2 style formulas that shift), so later columns return zeros, wrong values, or #REF!.
Candidates type the formula once, drag the fill handle, and only inspect the first cell, where the result still looks correct.
What to do instead
Press F4 while the reference is selected to cycle to $C$2 (or C$2/$C2 as required) before filling, then click 2-3 of the filled cells to confirm the reference stayed put. Ctrl+` toggles Show Formulas for a quick audit.
Leaving a cell in edit mode or entering a formula preceded by an apostrophe, a space, or no '=' sign, so Excel stores the calculation as literal text.
The text appears plausible in the cell and the formula bar looks almost right; also happens after pasting formula text from the task description or an imported file.
What to do instead
Check alignment - text sits left, real formulas/numbers sit right. Re-enter with F2 and confirm the leading '='. If a whole column of pasted formulas is text, use Data > Text to Columns > Finish, or Find & Replace '=' with '=' on the selection.
Creating a named range by memorising the address and typing it into formulas, or naming it with spaces/special characters, rather than defining a real workbook name.
Named ranges feel optional when the reference is short, and the Name Box accepts almost anything typed into it, so invalid or sheet-scoped names go unnoticed.
What to do instead
Select the range and use Formulas > Define Name (or type in the Name Box and press Enter), using no spaces - underscores only. Confirm scope (Workbook vs the specific sheet) in Formulas > Name Manager, and use F3 to insert the name into a formula.
Using plain Ctrl+V to move data, which overwrites destination number formats, borders, conditional formatting or the formulas already there.
Regular paste is the default reflex, and the damage is only visible if you inspect the destination cell's formatting and formula bar afterwards.
What to do instead
Use Paste Special: Ctrl+Alt+V (or right-click > Paste Options) and choose Values, Formats, or Formulas & number formats to match the task. For alignment of imported text, use Paste Special > Transpose deliberately rather than retyping.
Importing a .csv/.txt file by double-clicking or by dragging it in, so all fields land in column A (or dates import as text) instead of splitting into columns.
Excel's automatic open depends on the file's locale and delimiter, so a semicolon- or tab-delimited file silently collapses into one column.
What to do instead
Use Data > Get Data > From Text/CSV (or From Text) and set the Delimiter and 'Data Type Detection' in the preview before clicking Load; alternatively Data > Text to Columns with the correct delimiter. Check that imported dates and numbers are right-aligned, not text.
Freezing panes after selecting cell A1, or using View > Split, so either nothing stays visible or a movable grey divider appears instead of locked rows and columns.
Freeze Panes freezes everything above and left of the active cell, and A1 has nothing above or to its left; Split looks similar enough that candidates don't notice the difference.
What to do instead
Select the cell immediately below the row and immediately to the right of the column you want to keep on screen (e.g. B2 to freeze row 1 and column A), then View > Freeze Panes > Freeze Panes. Remove any stray Split with View > Split.
Inserting a chart from whole columns (e.g. A:E) or from a range that includes total rows and blank separator rows, producing extra series, empty categories, or a flat-looking bar.
Clicking the column letters is faster than dragging, and Excel accepts the selection without complaint, plotting totals as if they were data points.
What to do instead
Select only the header row plus data rows (or click one cell inside a real table and use Insert > Chart), then verify with Chart Design > Select Data and remove unwanted series. Check the axis range by right-clicking the value axis > Format Axis.
Trying to change a gridline, data label, legend or axis by clicking it once and applying formatting, which actually formats the chart area/plot area instead of the intended element.
A single click selects the outer chart object; the small handles around the plot area are easy to mistake for the chart itself, and the change appears to 'not take' or affects the whole background.
What to do instead
Use the Chart Elements dropdown at the top-left of the chart (or press Tab / arrow keys to cycle elements until the name shows in the tooltip), or open the Format pane, pick the element from its dropdown list, and apply the setting there.