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

Question 1

You are working in Microsoft Word and frequently insert the same closing paragraph, including a signature block and legal disclaimer, at the end of many different letters. You want to save this block of formatted text and reuse it with a couple of clicks in any document. Which feature should you use?

Accepted Answer

Selecting the text and choosing Insert > Quick Parts > Save Selection to Quick Part Gallery stores it as a reusable Building Block that can be inserted into any document from the Quick Parts gallery in a couple of clicks, preserving all formatting. Retyping (B) is slow and inconsistent. Keeping a separate reference document open (C) works but requires switching windows and manual copy-paste every time. A macro (D) could work but is a more complex solution than the built-in Quick Parts feature designed for exactly this purpose.

Question 2

You are working in Microsoft Word. You have inserted a small image into the middle of a paragraph, but you want the surrounding text to flow around the image's outline on both sides rather than stopping above and below it. Which text wrapping option should you apply?

Accepted Answer

The Tight wrapping option (Picture Format > Wrap Text > Tight) flows surrounding text closely around the actual visible edges/outline of the image on both sides, rather than a rectangular bounding box. In Line with Text (A) treats the image as a single large character, pushing text above and below it without wrapping alongside. Top and Bottom (C) keeps text entirely above and below the image with no side wrapping. Behind Text (D) places the image behind the text layer so it does not affect text flow at all.

Question 3

You are working in Microsoft Word and need to print 150 mailing labels, one for each customer listed in an Excel spreadsheet, with each label showing the customer's name and address in the correct position on a standard sheet of label stock. What is the correct workflow?

Accepted Answer

Mailings > Start Mail Merge > Labels lets you pick the exact label sheet product number so Word lays out the correct grid, then Select Recipients connects to the Excel list, Insert Merge Field places the name/address fields, and Finish & Merge produces all 150 personalized labels correctly positioned. Manually typing each label (B) is impractical at this scale and error-prone. Pasting Excel data as a picture (C) produces a static, unformatted image that won't align to label boundaries. Find & Replace one at a time (D) is not how mail merge works and would be extremely slow for 150 records.

Question 4

You are working in Microsoft Word on a legal document that currently uses footnotes, but your firm's style guide requires endnotes instead, gathered at the very end of the document. Which TWO actions are part of correctly making this change? Choose 2.

Accepted Answer

The Footnote & Endnote dialog (launched from the small arrow in the References > Footnotes group) includes a Convert button that switches all footnotes to endnotes (or vice versa) automatically, preserving the note text and reference marks. After converting, it's good practice to check the numbering format and starting number (B) against the required style guide, since endnotes often use a different numbering convention (such as lowercase roman numerals) than footnotes. Manually retyping every note (C) is unnecessary and error-prone given the built-in Convert function. Deleting footnotes (D) destroys citation information. Theme colors (E) are unrelated to note type or placement.

Question 5

You are working in Microsoft Word finalizing a report template. You want the author's name to be automatically pulled from the document's properties and displayed in the footer, so it stays consistent even if someone edits the footer text separately. What should you insert?

Accepted Answer

Insert > Quick Parts > Document Property inserts a field, such as Author, that is linked directly to the file's metadata (File > Info), so it always reflects the current property value and updates automatically if the metadata changes. Typing plain text (B) creates a static string with no link to the document properties. A text box with manually typed text (C) behaves the same as plain text and has no dynamic link. There is no 'Author Signature' object in Word (D); digital signatures are a separate, unrelated feature.

Question 6

You are working in Microsoft Word designing the opening page of a magazine-style article. You want the first letter of the first paragraph to appear as a large, decorative capital letter that spans several lines of text, with the rest of the paragraph wrapping around it. Which feature should you use?

Accepted Answer

Insert > Drop Cap > Dropped formats the first letter of a paragraph as a large character that spans multiple lines while the rest of the paragraph text wraps around it automatically — a purpose-built typographic feature. Simply increasing the font size of the letter (B) enlarges it inline but does not create the wrap-around, multi-line drop effect. A WordArt object (C) can look decorative but is a separate floating object, not a properly integrated drop cap with text wrap. Applying Heading 1 (D) changes paragraph-level style formatting, not a single character's drop-cap behavior.

Question 7

You are working in Microsoft Excel with a row of 12 monthly sales values. You want a tiny inline chart inside a single cell next to the data, showing the overall trend at a glance without taking up a large chart area. Which feature should you use?

Accepted Answer

Sparklines (Insert tab > Sparklines) are miniature charts drawn directly inside a single cell, ideal for showing a compact trend line next to a row of data without the space a full chart object requires. A regular Line Chart (B) is a full-sized floating chart object, much larger than a single cell. Icon Sets (C) show a small icon per cell based on value thresholds, not a continuous trend line. 3D Map (D) is a geographic/3D data visualization tool unrelated to compact in-cell trends.

Question 8

You are working in Microsoft Excel with sales data laid out with months across columns and products down rows. You need to paste this data into a new location with months down rows and products across columns, swapping the orientation entirely. Which paste option should you use?

Accepted Answer

Paste Special > Transpose (or the Transpose icon in the Paste dropdown) swaps rows and columns when pasting, so data originally arranged in columns appears in rows and vice versa, in a single operation. Regular Paste (B) reproduces the exact same row/column layout without transposing. Format Painter (C) copies cell formatting only, not the data values or arrangement. Manually retyping (D) achieves the same visual result but is slow and error-prone compared to the built-in Transpose option.

Question 9

You are working in Microsoft Excel with an expense list containing multiple rows for each department (Marketing, Sales, IT) sorted together by department. You want to collapse each department's rows into a single subtotal line that can be expanded or collapsed with a click, showing a running total per department. Which feature should you use?

Accepted Answer

Data > Subtotal, after sorting by the grouping column, automatically inserts a subtotal row for each group (department) and creates outline/grouping controls (the small plus/minus buttons in the margin) letting you collapse or expand each group's detail rows with a single click. Manually inserting rows and formulas (B) achieves similar totals but does not create the collapsible outline structure automatically. Conditional Formatting (C) only changes cell appearance, not grouping or totals. Sorting alone (D) organizes the data but adds no subtotal or collapsible structure.

Question 10

You are working in Microsoft Excel with a column listing days of the week (Monday, Tuesday, Wednesday, ...) that were entered in random order. A standard alphabetical sort would list Friday before Monday, which is not what you want. You need them sorted in true weekday order. What should you do?

Accepted Answer

Data > Sort lets you choose 'Custom List' as the sort order, and Excel includes a built-in weekday list (Sunday, Monday, Tuesday, ...) that sorts text values in true calendar order rather than alphabetically. A standard A-to-Z sort (B) is alphabetical and does not understand weekday sequence on its own — this is exactly the problem described. Manually dragging rows (C) is slow and error-prone for larger datasets. Converting to numbers first (D) would work but requires extra formula columns and cleanup that the built-in Custom List sort avoids entirely.

Question 11

You are working in Microsoft Excel and need to look up a customer's phone number from a table where the phone number column is located to the LEFT of the customer name column that you are searching by. VLOOKUP cannot look backward to a column left of the lookup column. Which newer function directly supports this kind of lookup in either direction?

Accepted Answer

XLOOKUP separates the lookup array and return array as independent arguments, so the return column can be positioned anywhere relative to the lookup column, including to its left — something classic VLOOKUP cannot do directly. VLOOKUP (B) always searches the leftmost column of its table array and returns from columns to the right, so it cannot look backward without rearranging the data or using a workaround like INDEX/MATCH. HLOOKUP (C) performs the equivalent lookup for horizontally arranged data by row, not solving the left-lookup problem for column data. SUMPRODUCT (D) is an aggregation function, not a lookup function.

Question 12

You are working in Microsoft Excel and need to combine a customer's first name, last name, and city from three separate cells into one cell, with each part separated by a comma and space, skipping any of the three cells that happen to be empty. Which function is best suited for this?

Accepted Answer

TEXTJOIN lets you specify a delimiter (", ") once and set ignore_empty to TRUE, so it automatically inserts the separator between non-empty values only and skips blank cells without leaving stray commas. CONCATENATE (B) joins the values directly with no delimiter and no automatic empty-cell handling, requiring manual delimiter insertion between every argument. The ampersand operator (C) behaves the same as CONCATENATE — no built-in delimiter or empty handling. SUM (D) is a numeric aggregation function and would produce an error or 0 with text values.

Question 13

You are working in Microsoft Excel and have been given a CSV export from a different system containing 5,000 rows. You need to bring that external data into your workbook as a properly formatted Excel Table that you can refresh later if the CSV is updated. Which TWO steps should you take using Get & Transform (Power Query)? Choose 2.

Accepted Answer

Data > Get Data > From File > From Text/CSV (A) opens the Power Query import wizard for the external file, and after previewing or transforming the data in the Power Query Editor, Close & Load (B) brings the cleaned data into the workbook as a connected Table that can be refreshed later if the source CSV changes. Copy-pasting from Notepad (C) creates a static, unformatted block of text with no refresh connection. Manual Find & Replace across 5,000 rows (D) is impractical and error-prone. Inserting a picture (E) is not usable data at all.

Question 14

You are working in Microsoft PowerPoint and want every slide, except the title slide, to display the current slide number in the bottom-right corner automatically. Which feature should you use?

Accepted Answer

Insert > Header & Footer includes a 'Slide number' checkbox that places an automatically updating page-number placeholder on slides, and the 'Don't show on title slide' checkbox excludes just the title slide when you click Apply to All. Manually typing numbers (B) requires updating every slide by hand whenever slides are added, reordered, or removed. WordArt (C) is decorative text styling with no automatic numbering logic. There is no 'Show Numbers' option under Slide Size (D); that menu only controls slide dimensions.

Question 15

You are working in Microsoft PowerPoint on a presentation containing several high-resolution photographs that have made the file size very large, and you need to email it. You want to reduce the file size while keeping the images looking acceptable on screen. What should you do?

Accepted Answer

Compress Pictures (Picture Format tab, available when an image is selected) reduces the resolution and/or removes cropped-out image data across the presentation, shrinking overall file size while keeping images visibly acceptable for screen viewing. Deleting all images (B) removes needed visual content entirely, which is not the goal. Saving as PDF (C) changes the file format and may not be usable if the recipient needs an editable presentation. Zoom level (D) is only a display setting in the editing window and has no effect on the saved file's size.

Question 16

You are working in Microsoft PowerPoint on a master 40-slide deck covering your company's full product line. For an upcoming meeting with one specific client, you only need to present 12 of those slides, in a different order than they appear in the master deck, without duplicating the file or deleting slides from the master. What should you create?

Accepted Answer

Slide Show tab > Custom Slide Show > Custom Shows lets you define a named subset of slides from the master deck, in any order, that can be started as its own show — all without touching, duplicating, or deleting anything in the original 40-slide file. Duplicating the file and deleting slides (B) creates a separate file to maintain and risks version drift from the master deck. Manually hiding 28 slides before every meeting (C) is tedious to repeat and easy to get wrong, especially since order can't be changed by hiding. Printing only the needed slides (D) does not solve on-screen presenting.

Question 17

You are working in Microsoft PowerPoint moving several shapes around a slide freehand. As you drag a shape near another one, PowerPoint displays temporary dashed lines showing when the shape's edge or center aligns with a nearby object. What is this feature called, and how do you ensure it is active?

Accepted Answer

Smart Guides are the dashed alignment lines that appear dynamically while dragging an object near others, showing edge or center alignment and equal spacing; the option to display them is under File > Options > Advanced > Display > 'Display smart guides when shapes are aligned'. Track Changes (B) is a document/content review feature unrelated to object alignment. Static Grid and Guides (C) show a fixed reference grid but do not dynamically react to nearby shapes the way Smart Guides do. AutoCorrect (D) is a text-correction feature, not a drawing alignment aid.

Question 18

You are working in Microsoft PowerPoint and need to present a small comparison of four products across three specifications directly on a slide, with clean rows and columns rather than plain text lines. What should you insert?

Accepted Answer

Insert > Table lets you specify exact column and row counts, then type content into a properly structured grid with built-in table styling options, ideal for a clean product comparison. Separate text boxes arranged to resemble a grid (B) require painstaking manual alignment and don't behave as a true table if content changes. A SmartArt Cycle diagram (C) illustrates circular/repeating processes, not tabular comparisons. Typing an Excel formula into a text placeholder (D) would not calculate anything in PowerPoint and does not create a structured comparison layout.

Question 19

You are working in Microsoft PowerPoint co-authoring a presentation stored on OneDrive with a colleague. You want to leave feedback on a specific slide without changing its content directly, and you want your colleague to be able to respond to your feedback in place. Which TWO actions should you take? Choose 2.

Accepted Answer

Review > New Comment (A) attaches feedback to a specific slide or object without altering its actual content, and the Comments pane supports threaded replies (B) so a colleague can respond directly beneath the original comment, keeping the conversation attached to the relevant slide. Directly editing the text (C) changes content rather than leaving reviewable feedback, which bypasses the collaborative review process. Deleting and recreating the slide (D) is destructive and loses the original for comparison. Emailing a separate document (E) disconnects the feedback from the actual slide it refers to.

Question 20

You are working in Microsoft Outlook and want every new email you compose to automatically include your name, job title, phone number, and company logo at the bottom, without typing it manually each time. What should you set up?

Accepted Answer

File > Options > Mail > Signatures lets you create one or more signature blocks including text, images like a logo, and formatting, and you can designate a default signature that Outlook inserts automatically into new messages (and optionally replies/forwards). Manually typing it every time (B) defeats the purpose of automation and risks inconsistency. Quick Steps (C) automate multi-step actions like moving or categorizing messages, not signature insertion. Adding details to the Subject line (D) is not where signature information belongs and would clutter every subject line.

Question 21

You are working in Microsoft Outlook with an Inbox containing a long back-and-forth email thread with 15 replies scattered among other unrelated messages. You want related messages in the thread grouped together as a single expandable entry instead of appearing individually throughout the message list. Which view setting should you enable?

Accepted Answer

View > Messages > Show as Conversations groups all messages that belong to the same email thread (by subject and reply chain) into a single expandable entry in the message list, decluttering the Inbox and letting you expand it to see all 15 related messages together. Reading Pane position (B) only changes where the currently selected message preview displays, not grouping. Rules & Alerts (C) automate incoming mail handling, not message list grouping. Plain text composition (D) affects message formatting, not how the list is organized.

Question 22

You are working in Microsoft Outlook and have noticed too many legitimate client emails from the domain 'partnerfirm.com' are being sent to the Junk Email folder because the filter is set very strictly. You need to keep the strict filtering for everything else but ensure emails from that specific domain are never treated as junk. What should you do?

Accepted Answer

Home tab > Junk > Junk Email Options > Safe Senders lets you add a specific domain (such as @partnerfirm.com) so mail from that domain always bypasses the junk filter, while the overall protection level (e.g., High) remains unchanged for everything else. Lowering protection to 'No Automatic Filtering' entirely (B) removes junk filtering mailbox-wide, letting through unrelated spam as well, which is more than what's needed. Manually rescuing each message (C) is a repetitive workaround rather than a fix. Deleting the Junk Email folder (D) does not stop future messages from being filtered as junk and is a destructive, ineffective action.

Question 23

You are working in Microsoft Outlook and your mailbox is approaching its storage limit because of years of accumulated email. You want Outlook to automatically move items older than 6 months into a separate archive data file on an ongoing basis, without you having to remember to do it manually. Which feature should you configure?

Accepted Answer

AutoArchive (File > Options > Advanced > AutoArchive Settings) can be configured to run automatically at a set interval and move items older than a specified age into a separate .pst archive file, freeing up space in the active mailbox while preserving the older messages for later reference. Manually deleting old emails once a year (B) is not automatic and permanently removes messages rather than archiving them. A Rule that deletes emails (C) permanently destroys data rather than preserving it in an archive. Reducing the mailbox quota (D) does not free existing space or address the accumulation problem; it could actually cause the mailbox to exceed its limit sooner.

Question 24

You are working in Microsoft Outlook and need to quickly poll ten colleagues on whether they can attend an event, letting each simply click a button to respond Yes, No, or Maybe, with responses automatically tallied. Which TWO steps should you take? Choose 2.

Accepted Answer

Options > Use Voting Buttons (A) lets you define a custom button set like 'Yes;No;Maybe' that recipients click to respond with a single action, and after sending, opening the original message and viewing Tracking (B) shows a tallied summary of everyone's responses automatically. Asking for free-text replies (C) requires you to manually read and tally each response yourself. A rule that auto-replies Yes (D) does not solicit or record the recipients' actual choices at all. Attaching a paper survey as a Word document (E) is not a mechanism Outlook can tally and requires manual data collection.

Question 25

You are working in Microsoft Outlook and have flagged an email for follow-up, but you decide you want it to become a proper Task item with its own due date and reminder, rather than just a flagged message in your Inbox. Which TWO actions correctly accomplish this? Choose 2.

Accepted Answer

Dragging a flagged (or any) email onto the Tasks icon or the Tasks section of the To-Do Bar (A) creates a new Task item with the email's content attached/linked, and opening that task to set a specific due date and reminder (B) completes the conversion into a fully actionable task. Deleting the original email (C) is unnecessary — the task can reference the email without requiring its deletion, and deleting it may remove useful context. Changing the category color (D) organizes visually but does not create a task with a due date and reminder. Printing and handwriting a date (E) is a manual, non-digital workaround that does not use Outlook's task/reminder system at all.

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