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

Question 1

You are working in Microsoft Word on a report where most pages are portrait, but one page containing a wide table needs to be landscape. Which technique lets a single page use a different orientation from the rest of the document?

Accepted Answer

Section breaks allow different page setup properties, including orientation, margins, and paper size, to apply only within a specific section. Inserting Next Page section breaks around the page and changing Orientation while the cursor is in that section isolates the landscape formatting to just that page. Ctrl+L is not a rotation shortcut. Changing the whole document's orientation and reverting other pages manually is inefficient and error-prone. Converting the table to a picture avoids the orientation problem but sacrifices editability and accessibility.

Question 2

You are working in Microsoft Word on a technical manual. You need the text "see Figure 3" to automatically update if the figure is renumbered later, rather than typing the number manually. What should you insert?

Accepted Answer

References > Cross-reference lets you insert a field that points to a captioned figure, heading, or bookmark. When the target is renumbered (for example, a figure is inserted earlier in the document), updating fields (Ctrl+A, F9) refreshes the cross-reference automatically. Typing the number manually (A) will not update. A bookmark alone (C) marks a location but does not display or update a number unless referenced. A hyperlink to an external file (D) is unrelated to in-document figure numbering.

Question 3

You are working in Microsoft Word reviewing a contract. A colleague left a comment on a clause asking for clarification. You want to reply directly within that comment thread to answer their question, and then mark the comment as resolved once the discussion is settled. What is the correct workflow?

Accepted Answer

Word's modern commenting supports threaded replies: clicking Reply within an existing comment keeps the conversation together, and clicking Resolve greys out the thread to indicate it's settled without deleting the history. Deleting and re-adding (A) loses context and thread continuity. Track Changes (C) manages text edits, not comment threads. Copying comment text into the body (D) clutters the document and is not how Word's review tools are designed to be used.

Question 4

You are working in Microsoft Word preparing a document for public distribution. You need to make sure it is accessible to people using screen readers. Which TWO actions should you take using the Accessibility Checker? Choose 2.

Accepted Answer

The Accessibility Checker (Review tab) flags missing alt text and reading order problems as common issues affecting screen reader users. Adding meaningful alt text (A) lets screen readers describe images, and correcting reading order (B) ensures content, including text boxes and tables, is announced in a sensible order. Bolding all text (C) does not address accessibility and reduces readability. Removing all images (D) is unnecessary and destroys content; alt text is the correct fix. Margin size (E) is a layout preference unrelated to accessibility checker findings.

Question 5

You are working in Microsoft Word. You have two versions of the same contract and need Word to show you exactly what text was added, deleted, or changed between them in a single merged view. Which feature should you use?

Accepted Answer

Review > Compare generates a new document that marks insertions, deletions, and formatting changes between two versions as if tracked changes had been recorded, giving a precise legal-style redline. Viewing documents side by side (B) requires manually scanning for differences and is error-prone for long documents. Find & Replace (C) searches for specific text, not structural differences. Manual printed comparison (D) is slow and unreliable for detailed contract review.

Question 6

You are working in Microsoft Word on a 40-page policy document. You want readers to be able to click a phrase in the introduction, such as 'see the Definitions section', and jump directly to a bookmark you placed at that heading further down in the same document. What should you insert?

Accepted Answer

Insert > Link (or Ctrl+K) with 'Place in This Document' selected lets you link directly to an existing bookmark or heading, creating a clickable jump within the same file. A footnote (B) adds a citation-style note at the bottom of the page, not a clickable jump. A text box with matching text (C) is not interactive and does not navigate anywhere. Applying a heading style to the introduction text (D) changes formatting but creates no link to the Definitions section.

Question 7

You are working in Microsoft Excel. You want to restrict entries in a column so users can only choose 'Open', 'In Progress', or 'Closed' from a dropdown list, preventing free-text typos. Which feature should you use?

Accepted Answer

Data Validation (Data tab > Data Validation) with the 'List' option lets you define a fixed set of allowed values, which appear as a dropdown in the cell and reject anything not on the list. Conditional Formatting (A) only changes appearance based on the entered value; it does not prevent invalid entries. AutoCorrect (C) fixes typing patterns generally but is not scoped to a specific list of valid statuses. Custom number formats (D) control display formatting, not which values can be entered.

Question 8

You are working in Microsoft Excel with a column of 200 quarterly sales figures. You want a quick visual cue showing lower values in red shading and higher values in green shading, with a gradient between them. Which feature is best suited to this?

Accepted Answer

Color Scales apply a graduated, two- or three-color gradient across a range based on each cell's relative value, making it easy to spot lows and highs at a glance without reading numbers. Data Bars (B) show relative magnitude with in-cell bars rather than color gradients. A fixed fill color (C) cannot vary by value. A separate column chart (D) visualizes the data but does not shade the cells themselves as requested.

Question 9

You are working in Microsoft Excel with a raw data table containing thousands of sales transactions with columns for Region, Quarter, SalesRep, and Amount. You need to quickly summarize total Amount by Region and Quarter, and allow easy rearranging of that summary without writing formulas. What should you create?

Accepted Answer

A PivotTable (Insert > PivotTable) is designed exactly for this: dragging Region to Rows, Quarter to Columns, and Amount to Values instantly aggregates the data, and fields can be dragged to different areas to re-slice the summary without rewriting any formulas. SUMIFS formulas (A) would work but require one formula per combination and don't offer the same drag-and-drop flexibility. Manual subtotals (C) are slow and error-prone at this scale. A chart without aggregation (D) would plot raw transactions rather than summarized totals.

Question 10

You are working in Microsoft Excel with a workbook containing a tax rate value in cell B2 that is used in formulas throughout many sheets. You want formulas to read =Amount*TaxRate instead of =Amount*Sheet1!$B$2 so the intent is clearer and the reference is easier to maintain. What should you do?

Accepted Answer

Formulas > Define Name (or typing a name directly into the Name Box) creates a named range that can be referenced in formulas by its name instead of its cell address, making formulas self-documenting and easier to update if the underlying cell moves. Typing text into the cell itself (B) would overwrite the tax rate value with a label, breaking the formulas. A comment (C) is only a note visible on hover and has no effect on formulas. Merging cells (D) changes layout, not how the value is referenced.

Question 11

You are working in Microsoft Excel building a loan calculator. You know the target monthly payment you want to achieve and need Excel to determine what loan amount produces that payment, given a fixed interest rate and term. Which feature should you use?

Accepted Answer

Goal Seek (Data > What-If Analysis > Goal Seek) lets you specify a target value for a formula cell (the payment) and have Excel automatically solve for the input cell (the loan amount) that produces it. Scenario Manager (B) is used to compare multiple predefined sets of inputs, not to solve backward for a single unknown. A SUM formula (C) does not perform reverse calculation. Manual trial and error (D) is inefficient compared to the built-in solver.

Question 12

You are working in Microsoft Excel using =VLOOKUP(G2,A:D,4,FALSE) to retrieve a department name. When the employee ID in G2 is not found in the table, the formula displays #N/A, which looks unprofessional in a printed report. What should you do to display 'Not Found' instead?

Accepted Answer

IFERROR() catches any error result (including #N/A from an unmatched VLOOKUP) and substitutes a custom value or message in its place, without altering the lookup's exact-match behavior. Changing FALSE to TRUE (B) switches to approximate match, which requires sorted data and would return incorrect results rather than an error message, masking a real data problem. Custom number formats (C) affect how numbers display but cannot replace error text with a different string. Deleting the row (D) removes needed data rather than solving the display issue.

Question 13

You are working in Microsoft Excel preparing a 10-page report for printing. You need every printed page to repeat the column headers from row 1, and you want only a specific range to print rather than the entire sheet. Which TWO settings should you configure on the Page Layout tab? Choose 2.

Accepted Answer

Print Titles (A) lets you designate row 1 to repeat automatically at the top of every printed page, and Print Area (B) restricts printing to only the selected range rather than the whole sheet. Themes (C) affect color and font styling, not print scope. Manually inserting page breaks after row 1 on every page (D) would break the layout rather than repeat headers correctly. Bolding cell A1 (E) is cosmetic and has no effect on what prints or repeats.

Question 14

You are working in Microsoft PowerPoint on a presentation originally created for a 4:3 projector. You need to update it to widescreen 16:9 format for a modern display without recreating every slide. What should you do?

Accepted Answer

Design > Slide Size > Widescreen (16:9) changes the aspect ratio for the entire presentation at once, and PowerPoint offers a choice to Maximize or Ensure Fit so existing content scales appropriately. Manually resizing every placeholder (B) is time-consuming and inconsistent across slides. Recreating slides in a new size and deleting old ones (C) discards existing formatting and content unnecessarily. Changing only the display resolution (D) does not affect the presentation file's internal slide dimensions.

Question 15

You are working in Microsoft PowerPoint. Two consecutive slides show the same photograph, but one slide has text captions added and a slightly rotated version of the image. You want the objects to smoothly move, rotate, and fade into their new positions as the slide changes, rather than a hard cut. Which transition should you apply?

Accepted Answer

The Morph transition (Transitions tab) analyzes matching objects between two similar slides and smoothly animates their position, size, rotation, and other properties as it moves from one slide to the next, creating fluid motion effects. A basic Fade (B) simply crossfades the entire slide without recognizing individual objects. Cut (C) is an instant, abrupt slide change. Push (D) slides the entire new slide in over the old one without object-level animation. Morph requires the objects to exist on both slides to animate them individually.

Question 16

You are working in Microsoft PowerPoint on a 60-slide deck that covers three distinct topics for three different departments. You want to organize the slides into labeled groups in the Slide panel so you can collapse, expand, and quickly jump to each topic while editing, without creating separate files. What should you do?

Accepted Answer

Sections (right-click in the Slide panel or thumbnail pane > Add Section) let you name and group consecutive slides, and each section can be collapsed or expanded, which is ideal for navigating a long single-file presentation by topic. Splitting into three files (B) fragments a presentation that needs to remain a single deck. A labeled divider slide (C) provides a visual marker but no collapsible organization in the editing panel. Indenting titles in Outline view (D) affects only the text hierarchy, not slide grouping.

Question 17

You are working in Microsoft PowerPoint preparing a self-running presentation for a trade show booth. You want each slide to advance automatically after the same amount of time you actually spent viewing it during a live practice run, rather than guessing seconds manually. Which feature should you use?

Accepted Answer

Rehearse Timings (Slide Show tab) runs the presentation while recording exactly how long you spend on each slide, then offers to save those actual durations as each slide's automatic advance time. Manually typing durations in Transitions (B) requires guessing or measuring time separately rather than recording it live. Screen Recording (C) captures video/audio of screen activity, not slide timing. Loop continuously (D) makes the show repeat but does not record or set individual slide durations.

Question 18

You are working in Microsoft PowerPoint with five shapes scattered unevenly across a slide. You need them evenly spaced horizontally and aligned along their top edges with a single command, rather than dragging each one individually. Which feature should you use?

Accepted Answer

The Align commands (Shape Format or Drawing Tools > Arrange > Align) include Align Top to line up the top edges of selected objects and Distribute Horizontally to space them evenly, both applied instantly to all selected shapes at once. Grouping and resizing (B) changes overall size and position together but does not align edges or equalize spacing. Animation (C) affects motion during playback, not static positioning. Format Painter (D) copies formatting attributes like color and fill, not position or spacing.

Question 19

You are working in Microsoft PowerPoint and need to insert a chart that displays quarterly revenue values which are still being finalized in a companion Excel workbook, so the chart should update automatically whenever the source workbook changes. Which TWO actions accomplish this? Choose 2.

Accepted Answer

Copying a chart from Excel and using Paste Special > Paste Link (B) embeds a live link back to the source workbook so the slide chart refreshes when the Excel file changes. Similarly, inserting a chart and choosing 'Edit Data in Excel' while pointing to the external workbook (D) maintains a linked connection rather than embedding a static copy. Building the chart with PowerPoint's own embedded worksheet (A) creates an independent copy disconnected from the companion file. A screenshot (C) is a static image that never updates. Converting to SmartArt (E) is not a valid chart-to-SmartArt operation and would lose the chart data entirely.

Question 20

You are working in Microsoft Outlook and receive many emails related to three active projects. You want to visually distinguish emails belonging to 'Project Atlas' with a color label you can filter and search by, without moving them to a different folder. Which feature should you use?

Accepted Answer

Categories (Home tab > Categorize) let you tag messages with a named, color-coded label that stays with the message regardless of its folder, and you can filter or search by category across the whole mailbox. Flags (B) indicate follow-up urgency rather than project grouping. Creating a folder (C) physically relocates messages rather than labeling them in place, which the scenario says to avoid. High Importance (D) is a priority marker unrelated to project categorization.

Question 21

You are working in Microsoft Outlook and repeatedly perform the same three actions on certain emails: mark as read, categorize as 'Billing', and move to the Billing folder. You want to perform all three actions with a single click instead of doing each one manually every time. Which feature should you configure?

Accepted Answer

Quick Steps (Home tab > Quick Steps) let you define a custom, one-click action that combines multiple steps — such as marking as read, applying a category, and moving to a folder — into a single button you apply manually to selected messages. Rules (B) automate actions on incoming mail without a click but are triggered automatically on arrival, which is a different use case from an on-demand single-click action; you also would not need three separate rules for one combined action set. Categorizing alone (C) does not mark as read or move the message. Repeating the three manual actions (D) is exactly what Quick Steps is designed to eliminate.

Question 22

You are working in Microsoft Outlook and need a single view that shows every unread message across your Inbox, Billing, and Projects folders combined, without moving or copying any messages between folders. What should you create?

Accepted Answer

Search Folders (right-click Search Folders > New Search Folder > 'Unread mail', customized to search specific folders) create a virtual, always-current view that aggregates messages matching criteria like 'unread' from multiple real folders, without physically moving or duplicating any mail. A manually maintained 'Unread' folder (B) requires ongoing manual effort and the messages would no longer be unread in their original location. A Rule that copies messages (C) creates duplicate copies, cluttering the mailbox and violating the 'without moving or copying' requirement. Focused Inbox (D) splits the Inbox itself into Focused/Other tabs and does not combine multiple folders.

Question 23

You are working in Microsoft Outlook and are composing an email at 11 PM, but you don't want it to actually leave your Outbox and reach the recipient until 8 AM the next business day. Which feature should you use?

Accepted Answer

Options tab > Delay Delivery lets you set a specific date and time before which the message will not leave the Outbox, so it is composed now but transmitted automatically at the specified later time — provided Outlook remains running or connected to Exchange to process the send. Saving as a draft and sending manually (B) requires you to remember and be available at 8 AM. Message importance (C) only affects how the message is flagged for the recipient, not when it sends. A calendar reminder (D) can prompt you to send it but does not automate the sending itself.

Question 24

You are working in Microsoft Outlook composing an important email and want to be notified both when it arrives in the recipient's mailbox and when the recipient actually opens it. Which TWO options should you enable from the message's Options > Tracking group? Choose 2.

Accepted Answer

Request a Delivery Receipt (A) notifies you when the message has been delivered to the recipient's mail server/mailbox, and Request a Read Receipt (B) notifies you when the recipient opens the message (subject to their client honoring the request). High Importance (C) only adds a visual priority flag and has no tracking function. Track Changes (D) is a Word/document review feature, not an email tracking option. Voting Buttons (E) let recipients click a response option like Yes/No but do not report delivery or read status.

Question 25

You are working in Microsoft Outlook and need to send a 25 MB video file as an email attachment to a client whose mail server rejects attachments over 20 MB. Which TWO approaches would successfully deliver the file to the client? Choose 2.

Accepted Answer

Inserting a OneDrive link (A) avoids sending the large file through email entirely, since only a link travels through the mail system, bypassing server attachment limits. Compressing the file (B) may reduce it below the 20 MB threshold, allowing a direct attachment to succeed. Asking the client to change their own server's configuration (C) is outside your control and not a reliable solution. Splitting into a hundred tiny emails (D) is impractical and does not reconstruct a usable video file. Changing importance level (E) has no effect on server-enforced size limits.

MO-100/MO-200/MO-300/MO-400 — Microsoft Office Specialist: Associate (Microsoft 365 Apps)