← 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
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…
- Hide the sheet
- Conditional formatting
- Data validation
- Protect Workbook / Protect Sheet
- 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?
- Evaluate Formula only
- Error Checking
- Trace Dependents
- Trace Precedents
- 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…
- Remove duplicates
- Sort data
- Protect cells
- See how changing one input changes a formula's results
- 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…
- Slicer
- Chart
- Macro
- Name
- PivotTable
Show answerHide answer
C · Macro Macros record and replay a sequence of actions.
5A PivotTable 'calculated field' lets you…
- Sort the pivot
- Add a formula-based field computed from other fields
- Change the theme
- Protect the sheet
- 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…
- Filter rule
- Pivot rule
- Macro rule
- Chart rule
- 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…
- Create a chart
- Protect a workbook
- Find the input that produces a desired formula result
- Remove duplicates
- 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…
- A macro
- Freeze Panes
- Data Validation (list)
- Protect Sheet
- Conditional formatting
Show answerHide answer
C · Data Validation (list) Data Validation restricts entries to an allowed list.
9The LAMBDA function lets you…
- Record a macro
- Sort data
- Protect cells
- Define a reusable custom function without VBA
- 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…
- A cell formula
- A PivotTable
- A chart
- Worksheet_Change event
- 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…
- Formula
- Data Validation
- Macro
- Filter
- 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…
- Freeze Panes
- Consolidate (or a PivotTable)
- Trace Precedents
- Goal Seek
- 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 →
More microsoft certification practice