Microsoft Excel Expert - Microsoft 365 Apps - MO-211 Exam Questions [2026]

QUESTION NO: 1
Which of the following is not a way to enable macros in a workbook?

A. Setting macros to run automatically upon opening B. Enabling all macros in Trust Center Settings C. Using a password-protected section in the workbook D. Using a digital signature

Correct Answer: C

QUESTION NO: 2
What is the purpose of the 'Track Changes' feature in Excel?

A. To automatically save periodic copies of the workbook B. To compare two different workbooks C. To revert the workbook to a previous version D. To monitor and list changes made by different users

Correct Answer: D

QUESTION NO: 3
Which chart type would be most appropriate for showing how data values contribute to the overall total?

A. Histogram B. Line Chart C. Waterfall Chart D. Sunburst Chart

Correct Answer: D

QUESTION NO: 4
Which Excel feature would you use to automatically change the background color of cells based on their values?

A. Format Cells B. Cell Styles C. Conditional Formatting D. Themes

Correct Answer: C

QUESTION NO: 5
Which tool in Excel is used to quickly remove all duplicate records from a dataset?

A. Flash Fill B. Data Validation C. Conditional Formatting D. Remove Duplicates

Correct Answer: D

QUESTION NO: 6
Which chart type allows simultaneous display of different data types, like revenue vs. units sold?

A. Scatter B. Waterfall C. Pie D. Combo

Correct Answer: D

QUESTION NO: 7
What does configuring formula calculation options allow you to manage?

A. The order of operations in formulas B. When and how formulas are recalculated C. The security settings for external links in formulas D. The precision of calculations

Correct Answer: B

QUESTION NO: 8
To find the sum of values based on multiple conditions, which function is most appropriate?

A. AVERAGEIF() B. SUMIF() C. COUNTIF() D. SUMIFS()

Correct Answer: D

QUESTION NO: 9
Which lookup functions can be used to find data horizontally and vertically in a table?
(Choose two)

A. VLOOKUP() B. SUMIF() C. HLOOKUP() D. XLOOKUP()

Correct Answer: C,D

QUESTION NO: 10
Which features can you add to a PivotTable for enhanced data analysis?
(Choose two)

A. Data Validation B. Conditional Formatting C. Calculated Fields D. Slicers

Correct Answer: C,D

QUESTION NO: 11
Which Excel feature allows you to drill down into the details of a PivotChart?

A. Drill Down B. Filter C. Slicer D. Expand Field

Correct Answer: A

QUESTION NO: 12
You need to group data in a PivotTable by quarter and year. What is the most efficient way to do this?

A. Add a calculated field B. Right-click on a date field and select Group C. Create a new PivotTable D. Use Conditional Formatting

Correct Answer: B