MO-210
Free MO-210 practice questions
10 questions from our MO-210 practice tests, each with the correct answer and a written explanation. Read them with the answers shown, or switch to quiz mode and answer first.
Question 1 of 10, Manage worksheets and workbooks
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?
- AHome > Paste > Paste Special > Text
- BInsert > Object > Create from File
- CData > Get Data group > From Text/CSV Correct answer
- DFile > Open > Browse, then open the file directly
Answer and 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, Manage worksheets and workbooks
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?
- APress Ctrl+G, type Overdue in the Reference box, and press Enter
- BApply a Text Filter to the active column for Overdue
- CPress Ctrl+F, type Overdue, and select Find All Correct answer
- DUse Home > Find & Select > Go To Special > Constants
Answer and 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, Manage data cells and ranges
You need every order value above 1,000 in C2:C200 to show with a light red fill automatically. Which feature should you use?
- ACell Styles > Bad
- BData Validation with a decimal minimum of 1,000
- CConditional Formatting > Highlight Cells Rules > Greater Than Correct answer
- DSort C2:C200 largest to smallest, then apply a light red fill with Format Cells
Answer and 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, Manage data cells and ranges
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?
- AComment: describe it as the Invoices rate
- BRefers to: use a relative reference
- CScope: set to Invoices instead of Workbook Correct answer
- DName: add the prefix Invoices_ to the name
Answer and 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, Manage tables and table data
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?
- ASelect Data > Outline > Subtotal, using Sum at each change in Amount
- BType =SUM(B2:B500) below the last table row
- CInsert > Sparklines > Column under the Amount column
- DSelect Table Design > Total Row and choose Sum for Amount Correct answer
Answer and 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, Manage tables and table data
You want to change the look of an existing table to a different predefined design with banded rows in green. What should you do?
- ASelect the table and apply a Cell Style from the Home tab
- BChoose a style from the Table Design > Table Styles gallery Correct answer
- CSelect the table and apply Conditional Formatting > Color Scales
- DSelect the table and apply a theme from Page Layout > Themes
Answer and 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, Perform operations by using formulas and functions
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 Correct answer
- C=A$2*$B1
- D=A2*B1
Answer and 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, Perform operations by using formulas and functions
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 Correct answer
- D=Jan_Sales!C10, with an underscore in place of the space
Answer and 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, Manage charts
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?
- ACategories in reverse order, axis crosses At maximum category Correct answer
- BValues in reverse order on the horizontal axis
- CCategories in reverse order only
- DSwitch Row/Column on the Chart Design tab, then sort the data descending
Answer and 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, Manage charts
The title of a chart must always show the text currently in cell A1 on the Report sheet. What should you do?
- ASelect cell A1 and choose Insert > Text > Header & Footer
- BSelect the title, type =Report!A1 in the formula bar, press Enter Correct answer
- CSelect the chart title and type Report!A1 directly into the title box
- DSelect the chart, choose Chart Design > Select Data > Edit, and point the series name to Report!A1
Answer and 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.