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

Question 1

You are working in Microsoft Word. Your document contains sensitive information and you want to encrypt it with a password so only authorized users can open it. Where should you go to set this protection?

Accepted Answer

File > Info > Protect Document > Encrypt with Password allows you to set a password for opening the document. The password is saved as encryption metadata; without it, the file cannot be opened. This is different from restrict editing, which allows opening but limits editing.

Question 2

You are working in Microsoft Word. You need to check what personal information is stored in the document properties (author, company, subject, comments). Where should you look?

Accepted Answer

File > Info displays the Info pane on the right, which shows document properties including Title, Subject, Author, Tags, and Categories. You can also access the full Properties dialog from this pane to view and edit all metadata fields.

Question 3

You are working in Microsoft Word. You have a document that was created in an older version of Word (2010). You open it in Word 365 and notice 'Compatibility Mode' is shown in the title bar. You need to upgrade this document to the current format to use all modern Word features. What should you do?

Accepted Answer

File > Info > Convert button converts a document from an older format or compatibility mode to the current Word format. This removes compatibility mode restrictions and enables all modern features. Simply saving as .docx does not remove compatibility mode.

Question 4

You are working in Microsoft Word. You need to find all text that starts with the pattern 'Section' followed by a space and a digit (e.g., 'Section 1', 'Section 9'). You want to use Find & Replace with a pattern. Which wildcard pattern should you use in the Find field?

Accepted Answer

In Word's Find & Replace with wildcards enabled, the ? character matches any single character. The pattern 'Section ?' matches 'Section' followed by a space and exactly one character. The @ symbol matches one or more of the preceding character; [0-9] is regex, not wildcard syntax.

Question 5

You are working in Microsoft Word. You need to remove all direct formatting (bold, italic, color) from a paragraph while keeping the named style applied. What keyboard shortcut achieves this?

Accepted Answer

Ctrl+M removes direct formatting and resets text to only the applied named style. Ctrl+Space removes only font formatting (bold/italic) but keeps paragraph-level direct formatting. Ctrl+D opens Font dialog; Ctrl+Shift+Z is redo.

Question 6

You are working in Microsoft Word. You are creating a multilevel outline with automatic numbering. You want level 1 to be '1.', level 2 to be 'a.', and level 3 to be 'i.'. Which two steps are required? Choose 2.

Accepted Answer

Start with a built-in multilevel list style from the Multilevel List gallery. Then customize it further by modifying the associated list style in the Styles pane (right-click > Modify) to fine-tune the numbering format for each level.

Question 7

You are working in Microsoft Word. You want to apply the same character formatting (blue color, bold, small caps) to several non-adjacent words throughout the document. What is the most efficient method?

Accepted Answer

Creating a character style and applying it to all instances is the most efficient approach. A single style edit cascades to all instances, and applying styles to multiple non-adjacent selections is quick (Ctrl+click to select multiple, then apply style).

Question 8

You are working in Microsoft Word. You want to create a set of Quick Parts (building blocks) that are only available within the current document, not shared globally with every other document. Which two save locations restrict a building block to this scope? Choose 2.

Accepted Answer

Selecting the current document as the 'Save in' target in the Create New Building Block dialog restricts the block to that single file. Likewise, saving to a custom template that is attached only to this document (rather than Normal.dotm or Building Blocks.dotx, both of which are globally available to every document) also limits the block's scope. The Quick Part Gallery category is just a display grouping, not a storage location, so it does not affect availability scope.

Question 9

You are working in Microsoft Word. You want to insert a field code that displays the total number of pages in the document (e.g., 'Page 3 of 12'). You've already inserted 'Page' and the current page number. Which field code should you use for the total page count?

Accepted Answer

The NUMPAGES field code returns the total number of pages in the document. The full construction is often 'Page { PAGE } of { NUMPAGES }'. TOTALPAGE, PAGECOUNT, and PAGE-COUNT are not valid field codes in Word.

Question 10

You are working in Microsoft Word. You need to create a form that has a text input field where users can enter their name. You want the field to have a label and a light gray background color. What control should you use?

Accepted Answer

Both Plain Text content control and Rich Text content control can serve as form input fields. You can add a label in adjacent text, set placeholder text, assign a title, and apply styling including background color via the content control properties dialog.

Question 11

You are working in Microsoft Word. You need to insert a page number in the footer of your document, and it should be formatted to start from 'i' (Roman numeral lowercase) on the introduction pages, then switch to Arabic numbers '1' on the first chapter. How do you achieve different page number formats in sections?

Accepted Answer

Insert section breaks (Layout > Breaks > Section Breaks) to divide the document into sections. In each section's footer, insert a page number and right-click it to set its number format independently. You can also set 'Start at' to restart numbering per section.

Question 12

You are working in Microsoft Word. You need to insert citations from your organization's reference library and create a bibliography automatically. What feature should you use?

Accepted Answer

References > Insert Citation allows you to insert citations from existing sources or create new ones. You can manage your source library with References > Manage Sources. Once citations are inserted, References > Bibliography generates a formatted bibliography based on your selected citation style (APA, MLA, Chicago, etc.).

Question 13

You are working in Microsoft Word. You are performing a mail merge where you want to include headers/footers in the merged output, and also apply conditional logic to certain merge fields. Which two steps should you take? Choose 2.

Accepted Answer

Headers and footers defined in the main document are automatically included in each merged document. Use Mailings > Rules to insert conditional fields like IF (for conditional text) and SKIPIF (to skip records). These rules work anywhere in the document, including headers/footers.

Question 14

You are working in Microsoft Word. You want to create an index at the end of your document that lists all marked terms and their page numbers, formatted as a two-column layout. What steps should you take?

Accepted Answer

References > Index and Tables > Index tab allows you to mark terms for the index (References > Index > Mark Entry sets index markers on selected text). Once terms are marked throughout the document, insert the index at the desired location. The index dialog offers formatting options including columns.

Question 15

You are working in Microsoft Word. You need to insert an endnote that appears at the end of the document instead of at the bottom of the page. What is the quickest way?

Accepted Answer

References > Insert Endnote inserts an endnote that appears at the end of the document. The keyboard shortcut Alt+Ctrl+F inserts a footnote (at page bottom); Alt+Ctrl+D inserts an endnote. Both B and the D shortcut work, but References > Insert Endnote is more intuitive.

Question 16

You are working in Microsoft Excel. You have a complex workbook with formulas that recalculate frequently, causing performance issues. You need to switch the workbook to manual calculation mode so recalculation only happens when you press F9. Where should you go?

Accepted Answer

Both methods work. The Formulas tab (or Data tab in some versions) has Calculation Options, or you can go File > Options > Formulas and change the Calculation option to Manual. Setting to Manual stops automatic recalculation; use F9 to manually recalculate or F9+Shift to recalculate all sheets.

Question 17

You are working in Microsoft Excel. You have a dataset with duplicate rows. Which two approaches can effectively remove or filter out duplicate rows while keeping the first occurrence of each unique combination? Choose 2.

Accepted Answer

Data > Remove Duplicates (Data Tools group) removes duplicate rows based on all columns or a subset you specify, keeping the first occurrence and deleting the rest. Advanced Filter with 'Unique records only' checked can filter the list in place to show only unique rows, achieving a similar result non-destructively. There is no 'unique option' in Standard Filter and no 'unique flag' in Data > Consolidate — neither exists in Excel — and manually deleting duplicates row by row is error-prone and inefficient for large datasets.

Question 18

You are working in Microsoft Excel. You have sales data from three regions (North, South, East) in separate worksheets. You need to consolidate the data to show total sales by product across all regions. The source data has the same column headers but different row orders. Which tool is best suited for this task?

Accepted Answer

Data > Consolidate is designed for this scenario. It can consolidate ranges from multiple sheets, and by using category labels (top row and left column as identifiers), it matches products even if row order differs between sheets. This creates a summary with SUM by default.

Question 19

You are working in Microsoft Excel. You need to convert a column of text entries into separate columns (e.g., 'John Smith' into 'John' and 'Smith'). Which feature should you use?

Accepted Answer

Data > Text to Columns (Delimited or Fixed Width option) splits text in one column into multiple columns based on a delimiter (space, comma, tab) or fixed position. This is faster than using formulas for bulk conversion.

Question 20

You are working in Microsoft Excel. You need a formula that looks up a customer ID in column A and returns the customer's email from column C. If the ID is not found, it should return 'Not Found'. Which formula is best?

Accepted Answer

XLOOKUP is the modern function that handles the 'Not Found' case natively via its if_not_found parameter. VLOOKUP with IFERROR and INDEX/MATCH with IFERROR also work, but XLOOKUP is cleaner and bidirectional. All three are technically correct, but XLOOKUP is the best practice.

Question 21

You are working in Microsoft Excel. You need to create a formula that returns the sum of sales only for rows where the date is between January 1, 2026 and June 30, 2026. Sales are in column C, dates in column A. Which function should you use?

Accepted Answer

SUMIFS is the standard approach for multi-criteria summation with date ranges. SUMPRODUCT with date comparisons and multiplication also works. Option D is an incomplete array formula syntax. Both A and B are valid, with SUMIFS being simpler and more efficient.

Question 22

You are working in Microsoft Excel. You have a list of employee names in column A and need to capitalize the first letter of each name properly (e.g., 'john smith' becomes 'John Smith'). Which function should you use?

Accepted Answer

PROPER() capitalizes the first letter of each word and lowercases the rest. UPPER() makes all letters uppercase; TRIM() removes leading/trailing spaces; CAPITALIZE does not exist in Excel.

Question 23

You are working in Microsoft Word. You want to create a master document that includes multiple chapter files as subdocuments. Which two elements can you do with master documents? Choose 2.

Accepted Answer

Master documents allow you to insert subdocuments and generate a unified TOC, index, and bibliography across all of them. Cross-references and numbering update across subdocuments automatically. Subdocuments can still be edited independently; locking is a separate protection.

Question 24

You are working in Microsoft Word. You have created a custom paragraph style called 'Body Text - Special' with specific spacing and alignment. You want to modify the style so that all paragraphs using it update. When you modify the style, should you click 'Update style to match selection' or 'Modify style'?

Accepted Answer

'Modify style' opens the Modify Style dialog where you change the style definition; all paragraphs using that style update to the new definition. 'Update style to match selection' only works if the current paragraph has direct formatting applied that you want to merge into the style definition.

Question 25

You are working in Microsoft Excel. You need to create a formula that concatenates multiple text values with a separator and returns them as a single text string. You have product names in A2:A10 and want them joined with a comma and space. Which function is best?

Accepted Answer

TEXTJOIN (available in Microsoft 365) concatenates a range with a delimiter and can skip empty cells (second parameter). It's more flexible than CONCATENATE for ranges. CONCAT is similar to CONCATENATE; JOIN does not exist in Excel.

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