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

Question 1

You are working in Microsoft Word. You need to apply a built-in heading style to a paragraph so it appears in the document's navigation pane and table of contents. Where do you apply the heading style?

Accepted Answer

Heading styles (Heading 1, Heading 2, etc.) are applied from the Styles gallery on the Home tab. When applied, paragraphs appear in the Navigation Pane and can be picked up automatically by a table of contents. The Insert > Header command inserts a page header/footer area. Layout > Paragraph spacing affects spacing only. View > Navigation Pane opens the pane but does not apply styles.

Question 2

You are working in Microsoft Word. A document contains several tracked changes from different reviewers. You need to accept only the changes made by a specific reviewer named 'Alex Chen' and reject all others. What is the most efficient way to do this?

Accepted Answer

The Review tab's Show Markup menu allows you to filter tracked changes by specific reviewer. Once filtered to show only Alex Chen's changes, clicking Accept All Changes in Document will accept only the visible (filtered) changes. Option A accepts everyone's changes without filtering. Option C destroys the document. Find & Replace (D) does not operate on tracked change metadata.

Question 3

You are working in Microsoft Word. A colleague has sent you a document with multiple sections. You need to insert a table of contents that only includes headings from the second section onward, using custom styles named 'ChapterTitle' and 'SubSection'. Which approach should you use?

Accepted Answer

Custom Table of Contents (References > Table of Contents > Custom Table of Contents > Options) allows you to specify which styles to include and assign them outline levels. This is the correct approach when using non-standard style names like 'ChapterTitle' and 'SubSection'. The standard automatic TOC only looks for built-in Heading styles. Manually typing defeats the purpose of a dynamic TOC. TC fields are used for individual entries and require more manual work.

Question 4

You are working in Microsoft Word. You need to restrict editing in a document so that reviewers can only insert comments and cannot modify the body text. Which TWO steps are required to accomplish this? Choose 2.

Accepted Answer

To restrict editing to comments only, you must (A) open the Restrict Editing pane via Review > Restrict Editing, choose 'Filling in forms' or set editing restrictions to 'Comments' only, and then (B) click 'Yes, Start Enforcing Protection' and optionally set a password. Without enforcing protection (B), the restriction is not applied. Applying a Protected style (C) does not restrict editing in Word's protection model. Saving as PDF (D) creates a different format, not a protected Word document. The Insert Comments tab option (E) does not apply document-level restrictions.

Question 5

You are working in Microsoft Word. You want to view two pages of a long document side by side on screen at the same time without opening a second window. Which view should you use?

Accepted Answer

In Print Layout view, using View > Zoom > Two Pages displays two pages side by side in a single Word window without requiring a second window. Read Mode also shows pages but is optimized for reading and removes editing controls. Draft view shows a continuous single-column scrollable view without page breaks between pages. Outline view shows the document as a hierarchical outline, not as formatted pages.

Question 6

You are working in Microsoft Word. You need to create a mail merge to send personalized letters to 500 customers using a data source in an Excel file. After completing the merge, you need to save individual personalized letters as separate Word documents, one per customer. Which feature should you use?

Accepted Answer

Finish & Merge > Edit Individual Documents creates a new single merged document with all 500 personalized letters separated by section breaks. From there you can manually split or use macros to save individual sections. While option B (a macro) can automate per-record saving, the MOS exam focuses on the built-in Finish & Merge workflow. Option C sends emails and doesn't create documents. Option D prints but doesn't create saved files.

Question 7

You are working in Microsoft Excel. You need to freeze the first row and the first two columns so that they remain visible when scrolling through a large dataset. What is the correct approach?

Accepted Answer

To freeze rows above and columns to the left of the active cell simultaneously, you select the cell that is one row below and one column to the right of what you want frozen, then click View > Freeze Panes > Freeze Panes. To freeze row 1 and columns A and B, you select cell C2 (row 2, column C), then Freeze Panes. Selecting B2 would only freeze row 1 and column A. Using 'Freeze Top Row' and 'Freeze First Column' separately does not allow freezing multiple columns and a row together. Split creates resizable panes but does not lock headers.

Question 8

You are working in Microsoft Excel. You have a dataset in the range A1:D100 with a header row. You need to display only rows where the 'Region' column (column C) equals 'North' AND the 'Sales' column (column D) is greater than 5000. Which feature should you use?

Accepted Answer

AutoFilter (Data > Filter) allows you to apply multiple filter criteria across different columns simultaneously using the dropdown arrows. Filtering column C to 'North' and column D to values greater than 5000 achieves the AND condition directly. Advanced Filter (B) is used for more complex criteria or to copy results to another location, but AutoFilter is the simpler and more direct approach for this scenario. Conditional Formatting (C) highlights cells but does not hide non-matching rows. The FILTER function (D) is dynamic array functionality for extracting data, not filtering the original dataset in place.

Question 9

You are working in Microsoft Excel. A formula in cell B5 references cell A1 using =A1*10. When you copy the formula from B5 to C6, the reference changes to =B2*10. What type of cell reference is being used in the original formula?

Accepted Answer

A relative reference (written as =A1 without $ signs) adjusts automatically when the formula is copied to another cell. When copied from B5 to C6 (one column right, one row down), the reference A1 shifts to B2 (one column right, one row down). An absolute reference ($A$1) would not change. A mixed reference locks either the row ($A1 or A$1) but not both. A named range reference uses a defined name and does not shift when copied.

Question 10

You are working in Microsoft Excel. You need to look up an employee's department from a table where employee IDs in column A are not sorted. The table has employee IDs in column A and departments in column D. Which formula returns the department for employee ID in cell G2?

Accepted Answer

VLOOKUP(G2,A:D,4,FALSE) searches column A for an exact match of the value in G2 (FALSE = exact match), then returns the value from the 4th column of the range A:D, which is column D (department). Using TRUE (approximate match) requires the data to be sorted ascending, which this scenario says it is not — making TRUE incorrect here. HLOOKUP searches horizontally across rows, not vertically down columns. INDEX(A:A,MATCH(G2,D:D,0)) searches column D but returns from A, which is backwards.

Question 11

You are working in Microsoft Excel. You have a table named 'SalesData' with columns: SalesRep, Region, Quarter, Amount. You need to calculate the total Amount for the 'North' region in 'Q1' only. Which formula is most appropriate?

Accepted Answer

SUMIFS is the correct function when you need to sum a range based on multiple criteria (Region = 'North' AND Quarter = 'Q1'). The syntax is =SUMIFS(sum_range, criteria_range1, criteria1, criteria_range2, criteria2). SUMIF (A) only supports a single condition. The SUM(IF(...)) array formula (C) would work but is less clean and requires Ctrl+Shift+Enter in older Excel. COUNTIFS (D) counts records rather than summing the Amount values.

Question 12

You are working in Microsoft Excel. You need to convert a range of data (A1:C50) into an Excel table. What is the primary benefit of converting the range to a table?

Accepted Answer

A key benefit of Excel tables is that formulas using structured references (e.g., =[@Amount]*0.1) automatically expand to include new rows added to the table, and structured references make formulas more readable and self-documenting. Tables do not save to a separate file (A). They do not apply editing protection by default (C). While charts do update when data changes regardless of whether it's a table, automatic chart refresh is not exclusive to tables (D).

Question 13

You are working in Microsoft Excel. You need to create a chart that shows both the monthly Sales totals (as bars) and the running cumulative total (as a line) on the same chart. Which TWO steps are required to display both series with different chart types? Choose 2.

Accepted Answer

The correct approach for a combination chart is to (B) use Insert > Charts > Combo Chart, which lets you assign different chart types to each series in one dialog. Optionally (D) add the cumulative total to a secondary axis when the value scales differ significantly. Option A works if you already have a chart and right-click to change a single series type — this is also valid but less direct than starting with a Combo chart. C (two overlaid charts) is manual and impractical. E (Switch Row/Column) changes how series are grouped, not their chart type.

Question 14

You are working in Microsoft PowerPoint. You need to apply the same background color and font settings to every new slide you add to the presentation. Which feature allows you to set these defaults for all slides at once?

Accepted Answer

Themes (Design tab) apply a coordinated set of colors, fonts, effects, and background styles to all slides in the presentation at once. New slides added to the presentation automatically inherit the theme. Formatting each slide individually (B) is time-consuming and inconsistent. Copying text boxes (C) addresses only text content, not slide background or fonts. Transitions (D) control slide-to-slide animation effects, not visual design.

Question 15

You are working in Microsoft PowerPoint. You need to add the company logo to every slide in the presentation, including new slides added in the future, without inserting it on each slide individually. What is the correct approach?

Accepted Answer

The Slide Master (View > Slide Master) controls the layout and design of all slides. Any element placed on the Slide Master automatically appears on all existing and future slides that use that master. Format Painter (A) copies formatting, not images, across slides and must be applied individually. PowerPoint does not have a watermark feature equivalent to Word's (C). The Header and Footer dialog (D) inserts text in designated footer areas, not images in arbitrary positions.

Question 16

You are working in Microsoft PowerPoint. You have created a presentation with 20 slides. You need to rearrange several slides by dragging them into a new order. Which view is best suited for this task?

Accepted Answer

Slide Sorter view (View > Slide Sorter) displays all slides as thumbnails in a grid layout, making it easy to drag and drop slides into a new order efficiently. Normal view (A) with the slide panel shows a vertical list of thumbnails and allows reordering but is less efficient for many slides. Reading view (C) is for previewing the presentation and does not allow editing. Notes Page view (D) focuses on speaker notes, not slide arrangement.

Question 17

You are working in Microsoft PowerPoint. A user needs to set up a kiosk presentation that loops continuously and advances slides automatically every 10 seconds without any keyboard or mouse input. Which combination of settings achieves this?

Accepted Answer

For a kiosk presentation, you must (1) go to Slide Show > Set Up Slide Show and choose 'Browsed at a kiosk (full screen)' which enables continuous looping automatically, and (2) set the transition timing on the Transitions tab to advance slides 'After' a specific number of seconds (10 seconds) applied to all slides. This combination creates a self-running, looping presentation. Option A uses presenter mode which requires manual advancement. Option C uses animations not transitions, which would not advance the slide itself. There is no loop time field in Slide Show settings (D).

Question 18

You are working in Microsoft PowerPoint. You need to insert a SmartArt graphic that shows a hierarchical relationship between a manager and their three direct reports. Which SmartArt layout type should you choose?

Accepted Answer

Hierarchy layouts in SmartArt are specifically designed to show reporting relationships and organizational structures, with a parent node and subordinate child nodes below it. Cycle layouts show circular processes. Relationship layouts show connections between elements (like Venn diagrams or balance diagrams). Matrix layouts show how components relate to a whole, typically in a 2x2 grid.

Question 19

You are working in Microsoft PowerPoint. You need to export the final presentation so that it can be viewed without PowerPoint installed, and also export the speaker notes as a separate printable document. Which TWO actions accomplish these goals? Choose 2.

Accepted Answer

To share a presentation without requiring PowerPoint: (C) File > Export > Create PDF/XPS creates a portable document viewable in any PDF reader. To export speaker notes: (D) File > Print > select 'Notes Pages' as the layout and then save as PDF or print — this generates a printable document showing each slide with its notes below. Option A requires PowerPoint to open. Option B creates a video (valid but loses interactivity and notes). Option E is manual and inefficient.

Question 20

You are working in Microsoft Outlook. You need to automatically move all incoming emails from a specific sender (boss@contoso.com) to a folder named 'Priority'. Which feature should you use?

Accepted Answer

Rules (Home > Rules > Create Rule or Manage Rules & Alerts) automate actions on incoming messages based on conditions such as the sender's email address. You can set a condition 'From boss@contoso.com' and an action 'Move to folder: Priority'. Quick Steps (A) are manual one-click actions applied by the user, not automatic. Blocking a sender (C) moves messages to Junk, not a custom folder, and blocks further messages. Categories (D) add color labels but do not move messages.

Question 21

You are working in Microsoft Outlook. You are going on vacation for two weeks and need to send automatic replies to anyone who emails you during that time. The reply should only go to people inside your organization. Which feature should you configure?

Accepted Answer

Automatic Replies (File > Automatic Replies) is the built-in feature for out-of-office responses. It allows you to configure separate messages for inside and outside your organization, and to set a date range so it activates and deactivates automatically. Option A (rules) can send auto-replies but would reply to all senders including external ones and cannot be limited to internal only as cleanly. A signature (C) appears on every outgoing email you send but does not reply to incoming messages. Calendar events (D) show you as 'Out of Office' but do not send automatic email replies.

Question 22

You are working in Microsoft Outlook. You need to schedule a meeting with five colleagues and want to find a time slot when all of them are available without emailing back and forth. Which Outlook feature should you use?

Accepted Answer

The Scheduling Assistant (available on the Meeting ribbon when you create a new meeting) displays a grid of all invited attendees' free/busy times overlaid together, allowing you to find a time slot when everyone is available. It is the most efficient tool for this task. Sending an email (A) requires manual coordination. Creating a Group (C) is for communication channels, not scheduling. Viewing individual calendars (D) achieves the same information but requires switching between views manually.

Question 23

You are working in Microsoft Outlook. A user receives a phishing email and accidentally forwards it to the company distribution list before realizing the mistake. They need to recall the email from recipients' inboxes immediately. What is the correct action to attempt the recall?

Accepted Answer

The Recall This Message feature (open the sent message > Message tab > Actions > Recall This Message) attempts to delete unread copies from recipients' mailboxes or replace them with a corrected message. This works for recipients on the same Exchange organization who have not yet read the message. Deleting from Sent Items (A) only removes it from your own folder and has no effect on recipients. Phone calls (C) are manual and impractical for a distribution list. A [RECALL] subject line (D) is informal and has no technical effect.

Question 24

You are working in Microsoft Outlook. You need to import a list of 200 business contacts from a CSV file exported from another application. Which method should you use?

Accepted Answer

Outlook's Import/Export wizard (File > Open & Export > Import/Export) supports importing from CSV (Comma Separated Values) files and maps CSV column headers to Outlook contact fields. This is the designed mechanism for bulk contact import. Manual creation (A) is impractical for 200 contacts. Drag-and-drop (C) of a CSV file into Contacts does not work for importing contact data. Paste from clipboard (D) is not supported for bulk contact creation.

Question 25

You are working in Microsoft Outlook. You want to flag an email message for follow-up by next Friday. When you flag the message, you also want it to appear as a task in your Tasks list with the Friday due date. Which action achieves this?

Accepted Answer

Right-clicking the flag icon and choosing 'Add Reminder' (or using 'Custom...' flag option) allows you to set a specific due date and reminder time. Flagged messages with due dates appear in the Task List (To-Do List) in Outlook with the assigned date, linking email and tasks. Categorizing (A) adds a color label but does not create a task. 'Set Quick Click' (C) sets what the single-click flag does by default but does not set an individual due date. Dragging to Calendar (D) creates an appointment, not a flagged task tied to the email.

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