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

Question 1

You are working in Microsoft Word. You want to enable a pane that shows a summary of your document's structure (headings, bookmarks) for quick navigation. Which two menu paths open this functionality? Choose 2.

Accepted Answer

View > Navigation Pane (View tab > Show group) and the legacy 'Show Document Map' checkbox both open the same structural navigation pane showing headings, sections, and bookmarks, letting you click to jump to a location. File > Options > Display has no such toggle, and neither the Review tab nor Insert > Links contains a Navigation command.

Question 2

You are working in Microsoft Word. You need to change the default location where AutoRecover files are saved. Where should you configure this?

Accepted Answer

File > Options > Save contains the 'AutoRecover file location' field where you can specify a custom folder for automatic backup files. By default, AutoRecover files are stored in a system temp folder; changing this location gives you more control.

Question 3

You are working in Microsoft Word. You have a document that is opened by multiple users simultaneously for collaborative editing. You want to see who is currently viewing or editing the document and what changes they have made. Which feature should you use?

Accepted Answer

File > Info displays an 'Editorial activity' section showing current co-authors/editors and their presence. This feature (available for cloud-synced documents) shows real-time editing activity. Track Changes shows modifications; Version History shows snapshots of saved versions.

Question 4

You are working in Microsoft Word. You want to increase the spacing between specific letters in a word (kerning) to improve readability of a heading. Which two paths let you access the Character Spacing controls? Choose 2.

Accepted Answer

Both the Home tab's Font dialog launcher and the right-click > Font context menu open the same Font dialog, whose Advanced tab contains Character Spacing (Scale, Spacing, Position, Kerning). Layout > Paragraph > Spacing controls paragraph line/space-before/after, not letter spacing, and there is no Character Spacing command under Insert > Text or Review > Proofing.

Question 5

You are working in Microsoft Word. You want to create a paragraph indent where the first line is indented less than the rest of the paragraph (reverse of a hanging indent). What is this called and how do you create it?

Accepted Answer

A first-line indent set to a negative value creates an 'outdent' where the first line extends further left than subsequent lines. In Paragraph > Special, set 'First line' to a negative value (e.g., -0.5").

Question 6

A newsletter editor is working in Microsoft Word on a multi-column layout, and notices text is not flowing evenly between columns on the last page. She wants the text to end at the same height in all columns. What setting should she use?

Accepted Answer

Layout > Columns > More Columns has a checkbox for 'Balance columns' which automatically adjusts text flow so all columns end at approximately the same height. This creates a more visually balanced multi-column layout.

Question 7

You are working in Microsoft Word. You want to set text direction to vertical (so text reads top-to-bottom) for a table header. Which two approaches can achieve this? Choose 2.

Accepted Answer

Both right-clicking the table cell and using Table > Layout > Text Direction (appears when editing within a table) allow you to rotate text. The text direction rotates the entire cell content 90° clockwise or counterclockwise, not individual characters.

Question 8

You are working in Microsoft Word. You want to create a style based on another existing style, inheriting its formatting but with some modifications. What is this called and how should you do it?

Accepted Answer

When creating or modifying a style, the 'Style based on' field in the Modify Style dialog specifies a parent style. The new style inherits all formatting from the parent and can override specific properties. This creates a style hierarchy.

Question 9

You are working in Microsoft Word. You need to insert a field that displays the date when the document was last printed. Which field code should you use?

Accepted Answer

The PRINTDATE field displays the date when the document was last printed and updates on each print. The \@ switch specifies the date format. LASTPRINT, PRINTTIME, and the DOCPROPERTY for 'LastPrintDate' are not valid field codes.

Question 10

You are working in Microsoft Word. You want to create a field code that stores a variable value (e.g., setting a project code that can be referenced throughout the document). Which field code should you use?

Accepted Answer

The SET field code creates a variable that can be referenced later with { REF fieldname }. Syntax: { SET projectCode "ABC123" }. Later, { REF projectCode } displays the stored value. This is useful for centralized placeholders.

Question 11

You are working in Microsoft Word. You want to insert an Excel spreadsheet object into your Word document so that it displays as an embedded table. Which two methods achieve this? Choose 2.

Accepted Answer

Insert > Object offers a Create New tab, which embeds a blank Microsoft Excel Worksheet object, and a Create from File tab, which embeds an existing Excel file as an object. Both produce an embedded, editable spreadsheet. Convert Text to Table only converts existing delimited text to a Word table (not an Excel object); Insert > Chart inserts a chart backed by an editable datasheet, not an embedded worksheet table; and Paste Special > Unformatted Text pastes plain text, not an embedded object.

Question 12

You are working in Microsoft Word. You need to insert a shape (rectangle, star, etc.) and add text inside it. How should you do this?

Accepted Answer

Insert > Shapes shows shape options. After drawing the shape on the page, double-click it to add text inside. The text becomes part of the shape. This is simpler than using a text box with a border.

Question 13

You are working in Microsoft Word. You need to insert a text box that automatically wraps text when it reaches the right edge, and you want to link multiple text boxes so text flows from one to the next. Where should you manage text box linking?

Accepted Answer

When a text box is selected, Drawing Tools > Format tab (or right-click > Format Shape) contains text linking options. You can click 'Create Link' to connect to another empty text box, causing text to flow from one to the next.

Question 14

You are working in Microsoft Word. You want to configure a shape so that text wraps tightly around its border (contour wrapping) rather than in a rectangular box. What setting should you use?

Accepted Answer

Layout (or Format in Drawing Tools) > Wrap Text > Tight makes text wrap closely to the shape's border. You can further customize by choosing Edit Wrap Points to define exactly how text flows around the shape.

Question 15

You are working in Microsoft Word. You need to view previous versions of a cloud-stored document that Word automatically saved. Where should you look?

Accepted Answer

File > Info (for OneDrive/SharePoint files) displays Version History, showing a timeline of auto-saved versions. You can click any version to open it or restore it. This is only available for cloud-stored documents.

Question 16

You are working in Microsoft Word. You need to set up a document information panel that displays custom properties (Author, Project ID, Review Date) on the right side of the document while editing. Which two steps should you take? Choose 2.

Accepted Answer

First, define custom properties in File > Properties > Custom tab. Then, File > Info displays these properties in a pane on the right. You can keep this pane open while editing to see and modify properties. Leaving File > Info open is equivalent to displaying the info panel.

Question 17

You are working in Microsoft Word. You want to create a hyperlink that opens a bookmark within the same document (e.g., jump to a section). How should you do this?

Accepted Answer

First, create a bookmark at the destination (Insert > Bookmark). Then, select text for the link and use Insert > Link (or Ctrl+K) > Place in This Document tab > select the bookmark. This creates an internal hyperlink.

Question 18

A training coordinator is building a Word-based course handout and wants to embed a YouTube video or other online media directly into the document. What feature should she use?

Accepted Answer

Insert > Video > Online Video (or Insert > Media > Online Video in some versions) allows you to insert a video by URL or search for it. The video embeds as a thumbnail that plays when clicked in Word 365.

Question 19

You are working in Microsoft Excel. You have a VBA macro that references external data, and you want to enable Trust Center settings so the macro runs without security warnings. Where should you configure trusted locations?

Accepted Answer

File > Options > Trust Center > Trust Center Settings > Trusted Locations allows you to add folders that contain trusted workbooks and macros. Files in these locations run without macro security prompts.

Question 20

You are working in Microsoft Excel. You need to create a subtotal that calculates the sum of sales by product category. The data has category breaks (hidden rows). Which feature should you use?

Accepted Answer

Data > Subtotals (Outline group) automatically inserts subtotal formulas at category break points. It also creates an outline structure allowing you to collapse/expand groups. You specify the column to subtotal and the function (Sum, Count, Average, etc.).

Question 21

You are working in Microsoft Excel. You need to apply advanced filtering that shows only rows matching complex criteria (e.g., show items where (Category='Office' AND Cost>100) OR (Status='Active')). Where should you go?

Accepted Answer

Standard Filter (Data > Filter > Standard Filter) provides a dialog for multiple criteria with AND/OR logic. Advanced Filter (Data > Filter > Advanced Filter) uses a separate criteria range for more complex filtering. Both handle complex logic; Standard Filter is simpler.

Question 22

You are working in Microsoft Excel. You have a dataset sorted by sales values. You want to reorder rows by cell color (showing red values first, then blue, then green). What feature allows sorting by color?

Accepted Answer

Data > Sort opens a dialog. When you click the Options or add a level, you can specify 'Sort by' column and choose to sort by 'Cell Color' instead of values. This reorders rows based on cell background color.

Question 23

You are working in Microsoft Excel. You need to create a formula that references a cell using a variable row number. For example, you want to reference row 5 but get the row number from a cell. Which function should you use?

Accepted Answer

INDIRECT("A" & rowNum) builds a cell reference string dynamically. OFFSET(A$1, rowNum, 0) returns a cell offset from A1. INDEX(A:A, rowNum) returns a value from column A at position rowNum. All three can dynamically reference cells based on variable row numbers.

Question 24

You are working in Microsoft Excel. You create a named range called 'SalesData' that references A1:F100. You want to create a formula that counts non-empty cells within this named range. Which formula should you use?

Accepted Answer

COUNTA counts non-empty cells in a range, including text and numbers. Using a named range like COUNTA(SalesData) counts all non-empty cells in the defined range. COUNTBLANK counts empty cells; COUNT counts only numeric values.

Question 25

You are working in Microsoft Excel. You need to extract a substring from a text value. For example, you want the first 3 characters of 'Microsoft' ('Mic'). Which function should you use?

Accepted Answer

LEFT(text, num_chars) extracts the first num_chars characters. MID(text, start_num, num_chars) extracts num_chars starting at position start_num. Both =LEFT("Microsoft", 3) and =MID("Microsoft", 1, 3) return 'Mic'. SUBSTRING does not exist in Excel.

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