Microsoft Office Specialist: Expert (Microsoft 365 Apps) — Practice Set 4

Question 1

You are working in Microsoft Word. You want to prevent users from printing a document while still allowing them to read it. Which protection option should you use?

Accepted Answer

File > Info > Protect Document > Restrict Permission uses Rights Management Services (RMS) to set granular permissions including disabling print. This requires Microsoft 365 subscription and is more powerful than standard protection, allowing specific permission restrictions like 'No printing'.

Question 2

An HR coordinator is preparing to share a Word document externally and needs to check for any personally identifiable information (PII) that might be embedded in the document before sharing it. What tool should she use?

Accepted Answer

File > Info > Check for Issues > Inspect Document scans for hidden metadata, personal information (author, company), comments, tracked changes, and other potentially sensitive data. It provides options to remove each category.

Question 3

You are working in Microsoft Word. You have a form document that was created in Word 2010 and opened in Word 2024. The form contains legacy form fields (not content controls). You want to convert this to use modern content controls instead. What should you do?

Accepted Answer

Word 2024 supports legacy form fields but does not automatically convert them to content controls. You must enable the Developer tab, identify legacy form fields (Form Controls, not Content Controls), and recreate them manually as content controls using Developer > Controls > Plain Text, Rich Text, or Date Picker.

Question 4

You are working in Microsoft Word. You need to find all text that appears between two specific patterns, such as all text between 'START' and 'END'. How should you use Find & Replace with wildcards?

Accepted Answer

In Word's Find & Replace with wildcards, the * wildcard matches zero or more characters, and () creates a group. The pattern 'START(*)END' finds text between START and END. .* is regex syntax, not wildcard syntax. Regular expressions use different syntax like [\s\S]*?.

Question 5

You are working in Microsoft Word. You have applied multiple character formatting (bold, red color, underline) to a word. You want to remove only the bold formatting but keep the red color and underline. What should you do?

Accepted Answer

Ctrl+B toggles bold on/off for the selection without affecting other formatting. Pressing Ctrl+B on bold text removes the bold while preserving red color and underline. Ctrl+Spacebar removes all direct formatting; Clear Formatting removes all. The Font dialog also works but is less efficient.

Question 6

A marketing assistant is working in Microsoft Word and wants to create an automatic numbered list (1, 2, 3) from a selection of paragraphs she just typed. What is the quickest way for her to do this?

Accepted Answer

Home > Numbering (Home tab, Paragraph group) applies automatic numbering to selected paragraphs. Clicking the dropdown allows you to choose numbering style. This is the quickest method. Format > Bullets and Numbering also works but requires more steps.

Question 7

You are working in Microsoft Word. You want to modify a paragraph style so that it automatically includes borders on all four sides with a specific color (blue). Which two settings should you configure in the Modify Style dialog? Choose 2.

Accepted Answer

Both Paragraph borders and Borders and Shading accomplish the same goal at the style level. When you click Format > Paragraph in Modify Style and set borders, or use Format > Borders and Shading, the border settings are embedded in the style definition.

Question 8

You are working in Microsoft Word. You need to create a repeating header row in a table so it appears at the top of the table on every page when the table spans multiple pages. What should you do?

Accepted Answer

Right-click the header row of the table and choose Table Properties. In the Row tab, check 'Repeat as header row'. This ensures the first row appears at the top of the table on every page the table spans.

Question 9

You are working in Microsoft Word. You need to create a field code that stores and displays the count of total words in the document. Which field code should you use?

Accepted Answer

{ DOCPROPERTY "Words" } retrieves the built-in document property for word count. WORDCOUNT, WORDS, and NUMWORDS are not valid field codes in Word. DOCPROPERTY can access any built-in property including Words, Characters, Pages, etc.

Question 10

You are working in Microsoft Word. You want to insert a field that displays the current time and updates every time the document is opened. Which two field code constructions correctly do this? Choose 2.

Accepted Answer

Both { TIME } and { TIME \@ "h:mm AM/PM" } are valid uses of Word's TIME field; the second simply adds a \@ switch to control the display format. CURRENTTIME and DATETIME are not valid Word field codes, and NOW is an Excel function, not a Word field code.

Question 11

You are working in Microsoft Word. You want to create a field code that inserts a prompt asking the user for input (e.g., 'Enter project name') and displays the user's response. Which field code should you use?

Accepted Answer

The ASK field code prompts the user for input and stores the response in a named variable. Syntax: { ASK fieldname "prompt text" }. You can later reference this value with { REF fieldname }. INPUT, PROMPT, and DIALOG are not standard Word field codes.

Question 12

You are working in Microsoft Word. You need to insert a table caption with a label 'Exhibit' and automatic numbering (Exhibit A, Exhibit B, etc.). Where should you go?

Accepted Answer

References > Captions in some versions allows creating custom labels. Alternatively, References > Insert Caption > Labels and you can create a new custom label 'Exhibit' instead of using 'Table'. Once created, captions use sequential numbering: Exhibit 1, Exhibit 2, etc.

Question 13

You are working in Microsoft Word. You need to create a mail merge where certain fields in the merge output are formatted based on their values (e.g., negative numbers in red). How should you format merge fields?

Accepted Answer

Formatting applied to a merge field or its surrounding text carries through to the merged output. Select the merge field placeholder and apply formatting directly (bold, color, font). This is simpler than using Rules and works for most formatting scenarios.

Question 14

You are working in Microsoft Word. You want to insert a merge field that displays the customer's last name in uppercase. Which feature should you use?

Accepted Answer

Merge field switches modify field output. The \* switch specifies text format. { MERGEFIELD LastName \* Upper } displays the field value in uppercase. Other switches include \* Lower, \* Capitalize, \* First capital.

Question 15

You are working in Microsoft Word. You need to create a table of authorities (legal citations) for a legal brief. Which two steps are required? Choose 2.

Accepted Answer

First, mark authorities/citations in your document using References > Mark Citation (or Alt+Shift+I). Then, place your cursor at the location for the TOA and use References > Insert Table of Authorities. This generates a formatted list of marked citations organized by category.

Question 16

You are working in Microsoft Word. You have a document with multiple captions and need to create a 'List of Tables' that shows only table captions (not figure captions). What should you do?

Accepted Answer

References > Insert Table of Figures (which actually inserts Table of Figures, Table of Tables, or any custom caption label) has a dropdown to select which caption label to use. Select 'Table' from the dropdown to create a list of only table captions.

Question 17

You are working in Microsoft Word. You want to insert a numbered list that continues from the previous section (e.g., previous section ended at number 5, next section starts at 6). How should you configure this?

Accepted Answer

Both options work. Right-click the list and choose 'Continue from previous list' or 'Restart numbering'. Alternatively, click the Numbering dropdown in Home tab and select 'Continue numbering'. Both achieve the same result of continuing the sequence.

Question 18

You are working in Microsoft Word. You need to convert a table of text data into a regular paragraph format with the table content flowing horizontally. What feature should you use?

Accepted Answer

Table Design > Convert > Convert Table to Text converts the table to text. You specify the separator (tabs, commas, paragraphs) between cells. This is the standard method for converting tables to text format.

Question 19

You are working in Microsoft Excel. You have a workbook that contains macros, but you want to restrict which worksheets users can access without a password. However, you need the macros to run. Which setting should you configure?

Accepted Answer

You can use Review > Protect Workbook > Structure to prevent adding/deleting/reordering sheets, then use Review > Protect Sheet on individual sheets to restrict content. Macros continue to run in protected sheets unless you've locked them in VBA Project properties.

Question 20

You are working in Microsoft Excel. You need to apply conditional formatting that changes cell color based on whether the value is the maximum or minimum in a range. What conditional formatting rule type should you use?

Accepted Answer

Home > Conditional Formatting > Top/Bottom Rules > Top 1 item highlights the maximum; Bottom 1 item highlights the minimum. This is simpler than using formulas and provides built-in formatting options.

Question 21

You are working in Microsoft Excel. You have sales data by quarter in separate worksheets (Q1, Q2, Q3, Q4). Each sheet has the same product list in column A and sales in column B. You need to consolidate all data into a summary sheet. Which tool handles data with different layout orders?

Accepted Answer

Data > Consolidate with 'Use labels' in top row and left column matches data by category labels even if worksheet row order differs. This is more robust than manual SUMIF formulas. PivotTable also works but is for analysis, not raw consolidation.

Question 22

You are working in Microsoft Excel. You have a column of dates in text format (e.g., '7/12/2026') that Excel is not recognizing as dates. You want to convert them to actual date values. What should you do?

Accepted Answer

Data > Text to Columns uses the Wizard. Even with no delimiter, the process recognizes text that looks like dates and converts it. Finish the wizard (no changes needed on delimiter step) and the text dates are converted to actual date values.

Question 23

You are working in Microsoft Excel. You need to calculate the average of values in column C, but only for rows where the corresponding value in column B is 'Active'. Which two formulas correctly achieve this? Choose 2.

Accepted Answer

AVERAGEIF(range, criteria, average_range) and AVERAGEIFS(average_range, criteria_range1, criteria1) both correctly calculate a conditional average; AVERAGEIF is the simpler single-criteria form, while AVERAGEIFS also supports multiple criteria. Option A requires array entry (Ctrl+Shift+Enter) to work and as written is incomplete. AVERAGE does not accept criteria arguments as shown in D, and IFAVERAGE is not a valid Excel function.

Question 24

You are working in Microsoft Excel. You need to create a formula that searches for a value across multiple columns and returns the position of the match in any column. Standard MATCH only searches within a single column. Which approach is best?

Accepted Answer

Nested IFERROR with multiple MATCH functions works by checking each column sequentially. The array formula approach uses (col1=value)+(col2=value) to create a multi-column match array. XMATCH (in Microsoft 365) is newer and simpler but not universally available.

Question 25

You are working in Microsoft Excel. You need to find the position of a text value within another text string (e.g., find 'cat' in 'concatenate'). Which two functions correctly return this position? Choose 2.

Accepted Answer

FIND and SEARCH both return the position of a substring within a text string, both returning 4 for 'cat' in 'concatenate'. FIND is case-sensitive and does not support wildcards; SEARCH is case-insensitive and supports wildcards. POSITION and LOCATE do not exist as Excel worksheet functions, and INSTR is a VBA function, not a worksheet formula.

MO-100/MO-110/MO-200/MO-210 — Microsoft Office Specialist: Expert (Microsoft 365 Apps)