MO-201 Excel Expert practice questionsMicrosoft certification practice
← Interview & exam prep
Microsoft certification practice

MO-201 Excel Expert practice questions

12 exam-style questions for MO-201 — Microsoft Excel Expert, each with the correct answer and why. Then take a timed practice test that also draws on the related skill banks.

12 questionsBeginner 6 · Intermediate 6Answers + explanations
Take it as a timed test
Free PDF
All 389 questions & answers, in one file

DAX, Excel, Power BI, Fabric, certification practice and analyst interviews — every answer with the reason behind it. Print it, study it offline.

Instant download, plus the free Tuesday briefing. Unsubscribe in one click.

Skills measured

  • Manage workbook options and settings
  • Manage and format data
  • Create advanced formulas and macros
  • Manage advanced charts and tables
Official MO-201 exam page ↗

Beginner 6 questions

1To stop users from changing the sheet layout (insert/delete/rename), you use…

  1. Hide the sheet
  2. Conditional formatting
  3. Data validation
  4. Protect Workbook / Protect Sheet
  5. A macro
Show answerHide answer

D · Protect Workbook / Protect Sheet Workbook/sheet protection locks structure and content from edits.

2Which formula-auditing tool shows the cells that FEED a formula?

  1. Evaluate Formula only
  2. Error Checking
  3. Trace Dependents
  4. Trace Precedents
  5. Watch Window
Show answerHide answer

D · Trace Precedents Trace Precedents highlights the cells a formula depends on.

3A one-variable Data Table (What-If) is used to…

  1. Remove duplicates
  2. Sort data
  3. Protect cells
  4. See how changing one input changes a formula's results
  5. Record a macro
Show answerHide answer

D · See how changing one input changes a formula's results Data Tables show many outcomes as one input varies.

4To record a repeated task as reusable steps, you create a…

  1. Slicer
  2. Chart
  3. Macro
  4. Name
  5. PivotTable
Show answerHide answer

C · Macro Macros record and replay a sequence of actions.

5A PivotTable 'calculated field' lets you…

  1. Sort the pivot
  2. Add a formula-based field computed from other fields
  3. Change the theme
  4. Protect the sheet
  5. Freeze panes
Show answerHide answer

B · Add a formula-based field computed from other fields Calculated fields add custom formulas inside a PivotTable.

6To apply formatting based on your own logic, you use conditional formatting with a…

  1. Filter rule
  2. Pivot rule
  3. Macro rule
  4. Chart rule
  5. Formula rule
Show answerHide answer

E · Formula rule A formula-based conditional format applies your custom condition.

Intermediate 6 questions

7Goal Seek is used to…

  1. Create a chart
  2. Protect a workbook
  3. Find the input that produces a desired formula result
  4. Remove duplicates
  5. Sort a range
Show answerHide answer

C · Find the input that produces a desired formula result Goal Seek back-solves for the input that hits a target output.

8To allow only values from a predefined list in a cell, you use…

  1. A macro
  2. Freeze Panes
  3. Data Validation (list)
  4. Protect Sheet
  5. Conditional formatting
Show answerHide answer

C · Data Validation (list) Data Validation restricts entries to an allowed list.

9The LAMBDA function lets you…

  1. Record a macro
  2. Sort data
  3. Protect cells
  4. Define a reusable custom function without VBA
  5. Create a chart
Show answerHide answer

D · Define a reusable custom function without VBA LAMBDA creates named, reusable functions in the grid.

10A macro that should run automatically when the workbook opens is placed in the…

  1. A cell formula
  2. A PivotTable
  3. A chart
  4. Worksheet_Change event
  5. Workbook_Open event
Show answerHide answer

E · Workbook_Open event Workbook_Open runs code as the file opens.

11To display 1500000 as '1.5M' without changing the value, you apply a…

  1. Formula
  2. Data Validation
  3. Macro
  4. Filter
  5. Custom number format
Show answerHide answer

E · Custom number format A custom number format changes display only, not the stored value.

12To summarize data from several ranges into one table, you can use…

  1. Freeze Panes
  2. Consolidate (or a PivotTable)
  3. Trace Precedents
  4. Goal Seek
  5. Protect Sheet
Show answerHide answer

B · Consolidate (or a PivotTable) Consolidate (or a PivotTable) combines multiple ranges into a summary.

What changed lately? Latest Formulas & Functions news, releases & questions →

Coming soon $19 one-time · early-access price
Prep Pro: full mock exams
  • Full-length, timed mock exams in the real PL-300, DP-600 and MO-201 format
  • Score breakdown by skill, with a study plan for your weak spots
  • New questions every month, written against the current exam outline

No payment now. We'll email you once, when it opens.

More microsoft certification practice