# Free MO-210 practice questions

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

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

### Question 1 of 10

A colleague emails you a comma-delimited file named orders.csv. You must bring its contents into a new worksheet in your open workbook so that you can preview the columns and adjust data types before loading. Which command should you use?

- A. Home > Paste > Paste Special > Text
- B. Insert > Object > Create from File
- C. Data > Get Data group > From Text/CSV
- D. File > Open > Browse, then open the file directly

**Answer:** C

**Explanation:** From Text/CSV (Data tab, Get & Transform Data group) opens a preview where you can check the delimiter and data types and then Load or Transform the data into the current workbook. Insert Object embeds the file as an icon or object rather than importing rows. Paste Special > Text needs the data already on the Clipboard and offers no data-type preview. Opening the file through File > Open creates a separate workbook rather than importing into the open one.

### Question 2 of 10

A workbook contains hundreds of rows. You need to locate every cell that contains the text "Overdue" and see a list of their addresses at once. What should you do?

- A. Press Ctrl+G, type Overdue in the Reference box, and press Enter
- B. Apply a Text Filter to the active column for Overdue
- C. Press Ctrl+F, type Overdue, and select Find All
- D. Use Home > Find & Select > Go To Special > Constants

**Answer:** C

**Explanation:** Find All in the Find and Replace dialog lists every matching cell with its sheet, cell address and value, and you can select them from the list. The Go To Reference box expects a cell address or name, not a text value. A filter works on one column of a range and hides rows rather than listing addresses. Go To Special > Constants selects all typed values, not only cells containing Overdue.

### Question 3 of 10

You need every order value above 1,000 in C2:C200 to show with a light red fill automatically. Which feature should you use?

- A. Cell Styles > Bad
- B. Data Validation with a decimal minimum of 1,000
- C. Conditional Formatting > Highlight Cells Rules > Greater Than
- D. Sort C2:C200 largest to smallest, then apply a light red fill with Format Cells

**Answer:** C

**Explanation:** Highlight Cells Rules > Greater Than applies a format only to cells that meet the condition and updates as values change. A manually applied fill after sorting is static and does not update when values change. The Bad cell style is static formatting. Data Validation restricts entries but does not format them.

### Question 4 of 10

A name TaxRate must be usable only on the Invoices sheet, while another sheet uses its own TaxRate value. When creating the name, which setting should you change?

- A. Comment: describe it as the Invoices rate
- B. Refers to: use a relative reference
- C. Scope: set to Invoices instead of Workbook
- D. Name: add the prefix Invoices_ to the name

**Answer:** C

**Explanation:** Scope controls where a name is recognized; a sheet-level scope allows the same name on different sheets. A comment documents the name but does not limit it. A relative reference changes what cell is referred to. Adding a prefix creates a different name, which defeats using TaxRate on both sheets.

### Question 5 of 10

You need to show a row at the bottom of a table that totals the Amount column and updates when you filter the table. What should you do?

- A. Select Data > Outline > Subtotal, using Sum at each change in Amount
- B. Type =SUM(B2:B500) below the last table row
- C. Insert > Sparklines > Column under the Amount column
- D. Select Table Design > Total Row and choose Sum for Amount

**Answer:** D

**Explanation:** The Total Row uses SUBTOTAL with function 109, which totals only visible rows, so it updates when filters are applied. A SUM formula below the table includes hidden rows and does not move with the table. Sparklines are mini charts, not totals. The Subtotal command is not available for a table without converting it to a range.

### Question 6 of 10

You want to change the look of an existing table to a different predefined design with banded rows in green. What should you do?

- A. Select the table and apply a Cell Style from the Home tab
- B. Choose a style from the Table Design > Table Styles gallery
- C. Select the table and apply Conditional Formatting > Color Scales
- D. Select the table and apply a theme from Page Layout > Themes

**Answer:** B

**Explanation:** The Table Styles gallery on the Table Design tab replaces the table formatting with a predefined style. Cell Styles format individual cells and do not change banding that follows the table. Color scales shade values by magnitude. Changing the workbook theme changes colors everywhere and does not select a specific table design.

### Question 7 of 10

Row 1 contains quantities in B1:K1 and column A contains unit prices in A2:A11. You enter one formula in B2 and fill it across to K2 and down to K11 to build a price-by-quantity grid. Which formula produces correct results everywhere?

- A. =$A$2*$B$1
- B. =$A2*B$1
- C. =A$2*$B1
- D. =A2*B1

**Answer:** B

**Explanation:** $A2 keeps the column fixed on the price column while letting the row change, and B$1 keeps the row fixed on the quantity row while letting the column change, which is the mixed-reference pattern for a two-way grid. Fully relative references drift away from both header rows. Fully absolute references return the same product in every cell. A$2*$B1 locks the wrong parts, pointing to the first price and to column B quantities only.

### Question 8 of 10

The January total is in cell C10 of a worksheet named Jan Sales. Which formula on the Summary sheet returns that value?

- A. =[Jan Sales]C10, with the sheet name in square brackets
- B. =Jan Sales!C10, with the sheet name typed without quotes
- C. ='Jan Sales'!C10, with the sheet name in single quotes
- D. =Jan_Sales!C10, with an underscore in place of the space

**Answer:** C

**Explanation:** A sheet name that contains a space must be wrapped in single quotation marks before the exclamation point. Without quotes Excel cannot parse the reference. Square brackets identify a workbook in an external reference, not a sheet. An underscore refers to a different sheet name that does not exist, so the formula returns #REF! or prompts to update values.

### Question 9 of 10

In a horizontal bar chart, categories appear in reverse order from the worksheet: the first row is at the bottom. You want the first row at the top and the horizontal axis to stay at the bottom. What should you configure on the vertical (category) axis?

- A. Categories in reverse order, axis crosses At maximum category
- B. Values in reverse order on the horizontal axis
- C. Categories in reverse order only
- D. Switch Row/Column on the Chart Design tab, then sort the data descending

**Answer:** A

**Explanation:** Reversing the category order puts the first row at the top, and setting the crossing to the maximum category keeps the value axis at the bottom. Reversing alone moves the value axis to the top. Reversing values flips the bars right to left. Switching rows and columns and sorting the data changes the layout rather than fixing the axis order.

### Question 10 of 10

The title of a chart must always show the text currently in cell A1 on the Report sheet. What should you do?

- A. Select cell A1 and choose Insert > Text > Header & Footer
- B. Select the title, type =Report!A1 in the formula bar, press Enter
- C. Select the chart title and type Report!A1 directly into the title box
- D. Select the chart, choose Chart Design > Select Data > Edit, and point the series name to Report!A1

**Answer:** B

**Explanation:** Typing an equal sign and a cell reference in the formula bar while the title is selected links the title to that cell. Typing into the title box stores literal text. Headers and footers are unrelated to chart titles. Editing a series name in Select Data changes the legend entry, not the chart title.

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

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