MO-201 sample questions

Question 1

When tracing precedents for a formula, what do a red tracer arrow and a dashed black tracer arrow indicate? (Select TWO) ```mermaid flowchart LR subgraph Worksheet1 A1(10) --> C1 B1(20) --> C1{=A1+B1} end subgraph Worksheet2 D5(5) -.-> C1 end subgraph ErrorSheet E1(#REF!) -- color:red --> C1 end ```

Accepted Answer

A red arrow indicates a precedent cell that contains an error.

Accepted Answer

A dashed black arrow indicates a link to a cell on a different worksheet or in a different workbook.

Answer

A red arrow indicates a circular reference.

Answer

A dashed black arrow indicates an indirect precedent.

Question 2

You are managing a workbook named 'Budget_Master.xlsx' that contains several macros in a standard module. You need to transfer the module named 'Q1_Processing' to another open workbook named 'Archive_2023.xlsm'. What is the most efficient method to accomplish this within the Visual Basic Editor (VBE)?

Accepted Answer

In the Project Explorer, drag the 'Q1_Processing' module from the 'Budget_Master.xlsx' VBAProject node and drop it onto the 'Archive_2023.xlsm' VBAProject node.

Answer

In the Project Explorer, right-click the 'Q1_Processing' module, select Export File, and then use Import File in the destination workbook.

Answer

Open the module code window, press Ctrl+A to select all code, copy it, create a new module in the destination workbook, and paste the code.

Answer

Use the 'Move or Copy' command from the worksheet tab context menu and select 'Create a copy' to move the sheet containing the macro.

Question 3

You are preparing a 'Q3_Financials.xlsx' workbook for distribution to department heads. The workbook contains proprietary formulas that you wish to remain hidden. However, users must be able to input data into cells B5:B20. Which sequence of actions must you take to achieve this?

Accepted Answer

Select B5:B20, unlock them; Select formula cells, check 'Hidden'; Protect the Worksheet.

Answer

Protect the Workbook structure; Select B5:B20 and use 'Allow Users to Edit Ranges'.

Answer

Select all cells, unlock them; Protect the Worksheet with the 'Select locked cells' option unchecked.

Answer

Hide the formula bar in Excel Options; Protect the Workbook with a password.

Question 4

A user reports that a specific workbook is calculating slowly. Upon investigation, you notice the status bar indicates 'Calculate' even after you press F9. You suspect circular references or iteration issues. Where should you navigate to check if 'Enable iterative calculation' is turned on?

Accepted Answer

File > Options > Formulas > Calculation options section.

Answer

Formulas Tab > Calculation Options dropdown menu.

Answer

Data Tab > Data Tools > Iteration Settings.

Answer

Formulas Tab > Formula Auditing > Error Checking.

Question 5

You are reviewing a workbook where threaded comments are used for collaboration. You need to ensure that a specific discussion is marked as resolved so that it no longer appears as an active conversation, but the history is preserved. What should you do?

Accepted Answer

Click the three dots (...) on the comment card and select 'Resolve Thread'.

Answer

Right-click the cell containing the comment and select 'Delete Comment'.

Answer

Reply to the comment with the text 'RESOLVED'.

Answer

Convert the Comment to a Note.

Question 6

You have a list of full names in Column A in the format 'Last, First Middle'. You want to extract just the First Name into Column B. You type the first desired result in cell B2. What is the most reliable way to fill the rest of the column using Flash Fill?

Accepted Answer

Select cell B3 and press Ctrl+E.

Answer

Double-click the fill handle in cell B2.

Answer

Right-click B2 and select 'Pick From Drop-down List'.

Answer

Use the Text to Columns wizard with a comma delimiter.

Question 7

You are creating a custom number format for a financial report. Positive numbers should be blue with two decimals, negative numbers should be red in parentheses, and zeros should be displayed as a dash '-'. Which format code is correct?

Accepted Answer

[Blue]#,##0.00;[Red](#,##0.00);-

Answer

#,##0.00[Blue];(#,##0.00)[Red];-

Answer

[Blue]#,##0.00;[Red]-#,##0.00;0

Answer

[Color1]#,##0.00;[Color3](#,##0.00);-

Question 8

You have a dataset of customer orders. You need to identify duplicate orders based on a combination of 'CustomerID' (Column A) and 'OrderDate' (Column C), ignoring other columns. What is the correct procedure?

Accepted Answer

Select the data range, click Remove Duplicates, click 'Unselect All', then check only 'CustomerID' and 'OrderDate'.

Answer

Sort by CustomerID, then manually scan for identical OrderDates.

Answer

Use Conditional Formatting > Highlight Cells Rules > Duplicate Values on Column A only.

Answer

Concatenate A and C in a helper column, then filter for unique values.

Microsoft Excel Expert (Office 2019) Free Sample Questions

Question 1

Question 2

Question 3

Question 4

Question 5

Question 6

Question 7

Question 8

Lifetime One

Two

Pro Four

Premium Twelve

MO-201 Sample Questions

Trusted by professionals at