# Free MO-211 practice questions

> 10 free MO-211 practice questions with the correct answer and an explanation.

Page: https://devopscodelab.com/exams/microsoft-mo-211/free-practice-questions/
Practice exams: https://devopscodelab.com/exams/microsoft-mo-211/

### Question 1 of 10

You recorded a macro named FormatHeaders in Report.xlsm and now need the same macro inside Budget.xlsm so that it travels with that file. Both workbooks are open. What is the most direct way to copy it?

- A. In the Visual Basic Editor, drag the module that contains FormatHeaders from the Report.xlsm project onto the Budget.xlsm project in Project Explorer
- B. Copy the worksheet that ran the macro from Report.xlsm into Budget.xlsm by right-clicking its tab and using Move or Copy with Create a copy selected
- C. In the Macros dialog box, select FormatHeaders, choose Options, and change the Macros in list to Budget.xlsm
- D. Save Report.xlsm as an Excel Macro-Enabled Template and then create Budget.xlsm again from that template

**Answer:** A

**Explanation:** Macros live in VBA modules, so dragging the module between projects in the Visual Basic Editor's Project Explorer copies the code into the other workbook. The Macros dialog's Options button only sets a shortcut key and description; it cannot relocate code. Rebuilding Budget.xlsm from a template would discard its existing content. Copying a worksheet copies only that sheet's own code module, not a standard module where recorded macros are stored.

### Question 2 of 10

You need to display cell values as positive numbers with a thousands separator, negative numbers in parentheses, zeros as a dash, and any text with the prefix Note: in front. How many sections must your custom format contain?

- A. One section with conditions written in square brackets for each case
- B. Four sections separated by semicolons: positive, negative, zero, and text
- C. Two sections separated by commas, the first for all numbers and the second for any text entries
- D. Three sections separated by semicolons: positive, negative, and text

**Answer:** B

**Explanation:** Custom number formats support up to four sections separated by semicolons, applied in the order positive, negative, zero and text, so all four requirements need four sections. Three sections apply to positive, negative and zero, leaving no text section. Commas act as thousands separators or scaling characters, not section separators. Conditional brackets allow only a limited number of conditions and cannot handle text formatting.

### Question 3 of 10

Cells in column E contain values such as 0.25 and -0.1. They must display as 25% Increase in green for positive values, 10% Decrease in red for negative values, and the word Flat for zero. Which custom number format meets the requirement?

- A. [Green]0% "Increase";"Flat";[Red]0% "Decrease"
- B. [Red]0% "Decrease";[Green]0% "Increase";"Flat"
- C. [Green]0% "Increase";[Red]-0% "Decrease";0% "Flat"
- D. [Green]0% "Increase";[Red]0% "Decrease";"Flat"

**Answer:** D

**Explanation:** Custom formats use the section order positive;negative;zero, and the negative section shows the absolute value unless a minus sign is added, so 0% Decrease displays 10% Decrease. Adding a minus sign to the negative section shows -10% Decrease, and 0% Flat shows 0% before the word. Swapping the first two sections labels positive numbers as decreases. Putting Flat in the second section applies it to negative numbers.

### Question 4 of 10

Column A lists full names such as Maria Lopez. You type Lopez in B2 and want Excel to fill the remaining surnames in column B based on that example, without writing a formula. Which feature should you use?

- A. Data validation with a List source
- B. Flash Fill
- C. AutoFill with the Fill Series option
- D. Text to Columns with the Delimited option and a space delimiter

**Answer:** B

**Explanation:** Flash Fill (Ctrl+E) detects the pattern from the example typed next to the source data and fills the rest of the column with static values. Text to Columns would also split the names, but it overwrites or spreads data across columns rather than learning from your typed example. Fill Series creates incrementing sequences, not extracted text. Data validation restricts entries and does not fill any values.

### Question 5 of 10

A formula repeats the expression VLOOKUP(A2,Rates,2,FALSE) three times, which makes it slow and hard to read. Which function lets you calculate that lookup once, assign it a name inside the formula, and reuse the name?

- A. LET
- B. LAMBDA
- C. INDIRECT
- D. CHOOSE

**Answer:** A

**Explanation:** LET assigns names to calculation results inside a formula, so the lookup runs once and the name can be reused in the final expression. LAMBDA defines a reusable custom function with parameters; by itself it does not name an intermediate result inside the current formula. CHOOSE picks a value from a list by index position. INDIRECT converts text into a reference and does not store intermediate results.

### Question 6 of 10

Table Prices has product IDs in column A and prices in column D. In another sheet, B2 must return the price for the ID in A2, show Not listed if the ID is missing, and keep working if columns are inserted between A and D. Which formula fits best?

- A. =XLOOKUP(A2,Prices[ID],Prices[Price],"Not listed")
- B. =XLOOKUP(A2,Prices[Price],Prices[ID],"Not listed")
- C. =VLOOKUP(A2,Prices,4,FALSE)
- D. =HLOOKUP(A2,Prices,4,FALSE)

**Answer:** A

**Explanation:** XLOOKUP searches the ID column, returns the matching price, uses its fourth argument for the not-found text, and references columns directly so inserted columns do not break it. VLOOKUP with a hard-coded column index of 4 returns the wrong column once a column is inserted and shows #N/A for missing IDs. Reversing the lookup and return arrays searches prices for an ID. HLOOKUP searches across the first row, not down a column.

### Question 7 of 10

You are editing a large model on Sheet1 and need to keep an eye on the totals in cells on Sheet7 and in another open workbook without switching sheets. Which feature should you use?

- A. Trace Dependents on each total so arrows show changes
- B. Freeze Panes on Sheet1 so the totals remain visible
- C. New Window and Arrange All to tile every sheet side by side
- D. Watch Window, adding each total cell with Add Watch

**Answer:** D

**Explanation:** The Watch Window is a floating pane that shows the book, sheet, value and formula of watched cells, even when they are on other sheets or open workbooks. Freeze Panes keeps rows or columns of the current sheet visible but cannot show other sheets. Tiling windows works but consumes screen space and is not designed for monitoring specific cells. Trace Dependents draws arrows and does not display values.

### Question 8 of 10

A dual-axis chart plots Units Ordered on a secondary axis, but after a data change both series are now counted in units of similar size, so the second scale only confuses readers. You want both series measured against one vertical axis. What should you do?

- A. Format the Units series and select Primary Axis under Series Options
- B. Format the secondary vertical axis and type the primary axis bounds as fixed values
- C. Change Chart Type and set both series to Clustered Column on the secondary axis
- D. Use Chart Elements > Axes to clear the Primary Vertical axis

**Answer:** A

**Explanation:** Moving the Units series back to the primary axis in Format Data Series removes the need for the secondary scale, and Excel drops the secondary axis. Setting both series to the secondary axis just moves the problem to the other side. Clearing the primary vertical axis hides a scale while the series remain on separate axes. Typing matching fixed bounds makes the scales look alike but they drift apart when the data changes.

### Question 9 of 10 (choose 2)

A dashboard has two PivotTables built from the same source data. You inserted a Region slicer for the first PivotTable and need it to filter both. Which two actions are valid ways to achieve this? (Choose two.)

- A. Insert a second Region slicer for the second PivotTable and group the two slicer shapes
- B. Add Region to the Filters area of both PivotTables and set them to the same item
- C. Select the slicer and use Slicer > Report Connections to check the second PivotTable
- D. Copy the slicer and paste it into the second PivotTable's Filters area
- E. Select the second PivotTable and use PivotTable Analyze > Filter Connections to check the Region slicer

**Answer:** C, E

**Explanation:** Report Connections on the slicer and Filter Connections on the PivotTable both link one slicer to multiple PivotTables that share a data source. Grouping two separate slicer shapes only moves them together; selections stay independent. A slicer cannot be pasted into a field area. Matching report filters works once but requires manual changes in both places each time, so a single slicer does not control both.

### Question 10 of 10

A Box & Whisker chart shows delivery times per carrier. Managers want to see the average as well as the median, and want extreme values plotted as separate dots. Which Format Data Series options should be selected?

- A. Show mean line and Inclusive median quartile calculation
- B. Show inner points and Exclusive median quartile calculation
- C. Show mean markers and Show outlier points
- D. Gap width set to 0% and Show inner points

**Answer:** C

**Explanation:** Mean markers display the average as an X in each box, and outlier points show values beyond the whiskers as separate dots. Inner points plot all values inside the whiskers, which is not requested, and quartile method only changes how quartiles are computed. A mean line connects averages across categories and does not show outliers. Gap width affects spacing between boxes.

Ready for a timed run? Take the free 15-question MO-211 mini exam: https://devopscodelab.com/app/exams/microsoft-mo-211/mini/

DevOpsCode Lab is not affiliated with Microsoft. MO-211 and related names are trademarks of their owners. We write every question ourselves; these are not real exam questions.
