MO-210 study plan

Create a workbook with four worksheets, then rename, reorder, color-code the tabs, and group two sheets to enter shared headers.

Configure three print setups: set a print area, scale a sheet to one page, repeat a header row across pages, and insert a header/footer with page numbers.

Freeze panes at a chosen cell and save two custom views for a 200-row dataset so the top rows stay visible while scrolling.

Restructure a messy imported list using Paste Special (values, transpose, multiply) and Flash Fill, then hide and unhide rows and columns to display only the needed fields.

Apply number, currency, date, and one custom format to at least 50 cells, then write a short audit list confirming each value displays as intended.

Build five conditional formatting rule types (highlight cells, top/bottom, data bars, icon sets, formula-based) across three separate ranges and confirm each rule fires on test data.

Insert sparklines next to a row of monthly totals and add a summary block that uses AGGREGATE and SUBTOTAL to hide filtered rows.

Define five named ranges, use each one inside a formula, and then insert, delete, merge, and transpose cell ranges to verify the names still resolve.

Convert a flat data range into a table, apply a banded-row table style, and enable a total row that sums and averages two columns.

Write four calculated columns that use structured references (table and column names only, no A1 addresses) so they auto-fill to new rows.

Sort the table on two levels, apply a custom filter plus a slicer, and confirm the visible row count matches the expected result.

Remove duplicate records on a copy of the table and convert that copy back to a plain range without breaking its formulas.

Build a second table that pulls its values from the first table using structured references and confirm it expands correctly when a new row is typed.

Add data validation lists and a custom validation rule to two columns, then circle invalid data to prove the rule blocks bad entries.

Write and copy formulas that use relative, absolute, and mixed references across a grid, verifying each column points at the intended cell.

Complete a 25-question timed drill covering Domains 1 through 3 and record the score per objective.

Write IF, nested IF, AND, OR, NOT, and IFERROR formulas in ten cells and verify each result against a manually calculated expected value.

Build SUMIF, SUMIFS, COUNTIF, COUNTIFS, and AVERAGEIFS formulas that summarize a criteria table by region and month.

Use LEFT, RIGHT, MID, TRIM, PROPER, TEXTJOIN, and TEXT to split and recombine a full-name and date column into clean output columns.

Return values across worksheets with VLOOKUP, XLOOKUP, and INDEX combined with MATCH, and set an exact-match argument on each.

Use TODAY, NETWORKDAYS, EOMONTH, and EDATE to calculate due dates, business days between dates, and month-end cutoffs in a schedule.

Round and truncate calculated amounts with ROUND, ROUNDUP, and INT, then reconcile a totals row to the source figures.

Trace precedents and dependents, open the Evaluate Formula dialog, and add two cells to the Watch Window to debug a deliberately broken formula.

Create column, line, bar, pie, scatter, and combo charts from table data on two sheets, choosing a chart type that suits each data shape.

Add and reposition titles, legends, axis titles, data labels, gridlines, and a trendline on at least three of the charts.

Switch rows and columns, change a chart type in place, move one chart to its own chart sheet, and apply a chart style and color scheme.

Format a value axis with fixed minimum and maximum bounds and a number format, and add a secondary axis to the combo chart.

Rebuild the two lowest-scoring objectives from memory with no notes and confirm each step works on a fresh workbook.

Complete two full timed practice assessments of 50 minutes each and log the score for every domain.

Re-drill every missed item until the same question type is answered correctly twice in a row.