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

Full question text, answer options, and explanations for this practice set — a spoiler-free alternative is the interactive quiz above for scored, shuffled practice.

1. 1. You need to create a bulleted list with different bullet styles for different levels. Which method allows you to customize bullets for outline levels?

   • A. Home tab > Bullets dropdown and select custom bullets
   • B. Home tab > Multilevel List > Define New List Style(correct)
   • C. Insert tab > Bullet options
   • D. Bullets cannot be customized by level

   Explanation: Multilevel List > Define New List Style allows you to set different bullet styles for each outline level. The Bullets dropdown (A) applies the same style. Insert tab (C) is for inserting objects. Bullets are customizable (D is false).

2. 2. Your document has inconsistent spacing between paragraphs. You need to apply uniform spacing to all body text. What is the most efficient approach?

   • A. Manually adjust each paragraph's spacing individually
   • B. Modify the style definition for the body text paragraph style(correct)
   • C. Use Find & Replace to find all paragraphs
   • D. Use the Format Painter on each paragraph

   Explanation: Modifying a paragraph style definition applies changes to all text using that style. This is more efficient than manual adjustments (A), Format Painter (D), or Find & Replace (C). Modifying styles is the professional approach.

3. 3. You need to create footnotes in a document, and they should restart numbering on each page. Which setting should you configure?

   • A. References > Footnotes > Options > Restart numbering at each page(correct)
   • B. Page Layout > Footnotes > Numbering Options
   • C. Footer settings cannot control footnote numbering
   • D. Insert > Special Character > Footnote numbering

   Explanation: The Footnotes options (References tab) include numbering behavior including restarting at each page. Page Layout (B) doesn't control footnotes. Footnotes are configurable (C is false). Special Characters (D) doesn't manage footnotes.

4. 4. You need to add a watermark to your document that says 'CONFIDENTIAL'. Where is this option located?

   • A. Design tab > Watermark(correct)
   • B. Insert tab > Watermark
   • C. View tab > Watermark
   • D. Format tab > Background

   Explanation: The Design tab contains the Watermark option. While Insert (B) has many options, Watermark is specifically under Design. View (C) and Format (D) don't contain watermark settings.

5. 5. Which TWO features can help you maintain document consistency when multiple people contribute? Choose 2.

   • A. Use a master template with predefined styles(correct)
   • B. Enable Track Changes to monitor all edits
   • C. Lock the document to prevent all editing
   • D. Create a style guide and share the template(correct)
   • E. Convert the document to PDF format

   Explanation: Master templates and shared style guides ensure consistency across contributors. Track Changes (B) monitors but doesn't enforce consistency. Locking (C) prevents collaboration. PDF (E) restricts editing entirely.

6. 6. You need to insert a field that automatically updates to show the current date each time the document is opened. Which type of field should you use?

   • A. Date field with 'Update automatically' enabled(correct)
   • B. Static text that you update manually
   • C. Formfield object
   • D. Field code with SAVEDATE function

   Explanation: A Date field with automatic update setting refreshes whenever the document opens. Static text (B) doesn't update. Formfields (C) are for forms. SAVEDATE (D) shows last save date, not current date.

7. 7. You need to create a quick calculation of sales totals. Which function will sum only the visible (filtered) cells in a range?

   • A. =SUM()
   • B. =SUBTOTAL()(correct)
   • C. =AGGREGATE()
   • D. =FILTER()

   Explanation: SUBTOTAL() function respects filtered rows and ignores hidden data. SUM() (A) includes all cells. AGGREGATE() (C) ignores errors but also counts hidden rows. FILTER() (D) filters data but doesn't sum.

8. 8. You have a large dataset and need to identify duplicate entries. Which feature helps you find and manage duplicates?

   • A. Data > Remove Duplicates(correct)
   • B. Find & Replace > Select All Duplicates
   • C. Format > Conditional Formatting > Duplicate Values
   • D. Use a COUNTIF formula to manually identify duplicates

   Explanation: Data > Remove Duplicates (A) specifically identifies and removes or manages duplicate rows. Conditional Formatting (C) highlights duplicates for manual review. COUNTIF (D) requires manual work. Find & Replace (B) doesn't handle duplicates.

9. 9. You need to consolidate data from multiple worksheets into a summary sheet. The worksheets have the same structure but different data. Which feature or method is most appropriate?

   • A. Use Data > Consolidate to combine data from multiple ranges(correct)
   • B. Manually copy and paste data from each sheet
   • C. Use VLOOKUP to reference data from other sheets
   • D. Data consolidation cannot be automated in Excel

   Explanation: Data > Consolidate (A) is specifically designed for combining data from multiple ranges with the same structure. Manual copy-paste (B) is inefficient. VLOOKUP (C) looks up values, not consolidates. Data consolidation is possible (D is false).

10. 10. You want to prevent users from accidentally modifying certain formulas in your worksheet. What should you do?

    • A. Place formulas in a separate hidden sheet
    • B. Lock formula cells and protect the worksheet(correct)
    • C. Convert formulas to values
    • D. Formulas cannot be protected

    Explanation: Lock cells containing formulas (Format > Cells > Protection) then protect the worksheet (Review > Protect Sheet). Hidden sheets (A) don't prevent access if someone unhides them. Converting to values (C) loses formula functionality. Formulas can be protected (D is false).

11. 11. Which TWO chart types are best for showing trends over time? Choose 2.

    • A. Line chart(correct)
    • B. Pie chart
    • C. Area chart(correct)
    • D. Scatter plot
    • E. Doughnut chart

    Explanation: Line (A) and Area (C) charts effectively show trends over time. Pie charts (B) show composition. Scatter plots (D) show correlation. Doughnuts (E) are compositional like pie charts. For trends, line and area are best.

12. 12. You need to track changes made to a shared workbook. How should you enable change tracking?

    • A. Review > Track Changes > Highlight Changes(correct)
    • B. File > Properties > Track Changes
    • C. Data > Track Changes
    • D. Excel doesn't support change tracking

    Explanation: Review > Track Changes (A) enables change tracking and highlighting in Excel. File > Properties (B) manages document info. Data (C) doesn't have tracking. Change tracking is supported (D is false).

13. 13. You have a workbook with sensitive data and want to restrict certain ranges to allow editing by only specific users. What is the best approach?

    • A. Use Format > Cells > Protection on selected ranges, then use Review > Allow Users to Edit Ranges(correct)
    • B. Protect the entire sheet with a password
    • C. Move sensitive data to a hidden sheet
    • D. Save the file in a read-only format

    Explanation: Allow Users to Edit Ranges (A) lets you specify which ranges different users can modify while protecting the rest. Full sheet protection (B) restricts all editing. Hidden sheets (C) don't provide granular control. Read-only (D) prevents all editing.

14. 14. You need to add a company logo to every slide in your presentation. What is the most efficient way to accomplish this?

    • A. Paste the logo on each individual slide
    • B. Add the logo to the slide master so it appears on all slides(correct)
    • C. Use Insert > Header & Footer to add the logo
    • D. Create a new slide layout with the logo

    Explanation: Slide Master (View > Slide Master) is the most efficient way to add elements to all slides at once. Individual pasting (A) is time-consuming. Headers/Footers (C) are for text. Custom layouts (D) work but master is more efficient.

15. 15. You want to print handouts showing 6 slides per page with space for notes. Which print setting should you adjust?

    • A. File > Print > Settings > Print Layout > Handouts(correct)
    • B. Design tab > Handout settings
    • C. View tab > Handout Master
    • D. Handouts can only show 4 or 9 slides per page

    Explanation: File > Print settings allow you to select Handouts and specify the number of slides per page (1, 2, 3, 4, 6, or 9). Handout Master (C) designs the layout but not the print quantity. Option D is false regarding available options.

16. 16. You need to create an interactive presentation where clicking on an image opens a different slide. Which feature should you use?

    • A. Action button with hyperlink or slide navigation(correct)
    • B. Animation pane to trigger slide changes
    • C. Video or audio to control navigation
    • D. PowerPoint doesn't support interactive navigation between slides on click

    Explanation: Action buttons (right-click object > Add Action or Insert > Action Button) allow you to link to other slides when clicked. Animation (B) creates visual effects, not navigation. Media (C) doesn't control slide navigation. Interactive navigation is supported (D is false).

17. 17. You need to export your presentation as a video file so it can be shared with people who don't have PowerPoint installed. How should you do this?

    • A. File > Export > Create a Video(correct)
    • B. File > Save As > Video format
    • C. Design tab > Export options
    • D. PowerPoint presentations cannot be converted to video

    Explanation: File > Export > Create a Video (A) exports the presentation as an MP4 or WMV video file. Save As (B) doesn't offer video formats. Design (C) doesn't have export options. Video conversion is supported (D is false).

18. 18. Your slides use embedded fonts that may not display correctly on other computers. How can you ensure your presentation displays the same fonts everywhere?

    • A. Embed fonts in the PowerPoint file using File > Options > Save(correct)
    • B. Convert all text to images
    • C. Save as PDF instead
    • D. Fonts cannot be embedded in presentations

    Explanation: File > Options > Save has a checkbox to embed fonts in the presentation file. Converting to images (B) reduces quality. PDF (C) changes format entirely. Font embedding is supported (D is false).

19. 19. Which TWO features help you deliver an effective presentation? Choose 2.

    • A. Use Presenter Speaker Notes to guide your talk(correct)
    • B. Include large blocks of text on every slide
    • C. Use the Slide Show menu to set up presentation options(correct)
    • D. Minimize use of visuals to reduce clutter
    • E. Use transitions and animations sparingly and purposefully

    Explanation: Speaker notes (A) and presentation setup (C) support effective delivery. Large text blocks (B) distract from presenting. Minimizing visuals (D) reduces engagement. Sparing animation (E) is wise but presentation options (C) is more directly helpful.

20. 20. You want to flag important emails for follow-up. Which Outlook feature allows you to mark and track flagged emails?

    • A. Click the flag icon next to the email or set a flag from the Home tab(correct)
    • B. Create a rule to automatically flag emails
    • C. Categories are the only way to mark emails
    • D. Outlook doesn't support email flagging

    Explanation: The flag icon (A) is visible in the message list and email itself. Rules (B) automate flagging but aren't necessary to flag manually. Categories (C) are different from flags. Flagging is supported (D is false).

21. 21. You receive recurring meeting invitations but want to stop attending one specific instance without affecting the series. What should you do?

    • A. Decline only the specific instance while keeping the series(correct)
    • B. Delete the entire series and recreate it without that date
    • C. Accept the meeting but mark it as free time
    • D. You must decline or accept the entire series

    Explanation: When declining or accepting a recurring meeting instance, Outlook allows you to respond to just that occurrence or the entire series. Deleting (B) removes all instances. Marking free (C) doesn't communicate your non-attendance. You can act on individual instances (D is false).

22. 22. You want to delegate your calendar access to an assistant so they can schedule meetings on your behalf. What is the proper way to configure this in Outlook?

    • A. Share your calendar and grant Calendar Editor permissions to the assistant(correct)
    • B. Give your assistant your Outlook password
    • C. Calendar delegation is not supported in Outlook
    • D. Use File > Account Settings > Delegate

    Explanation: Right-click calendar > Share Calendar or Calendar Properties > Permissions to grant edit access. Sharing calendar (A) is correct. Passwords (B) are insecure. Delegation is supported (C is false). Account settings (D) are for managing the account, not delegation.

23. 23. You need to create a contact distribution list (group) so you can email multiple people at once. How is this created in Outlook?

    • A. Home tab > New Contact Group, add members, and save
    • B. File > New > Distribution List
    • C. People tab > Create Group or Home tab > New Items > New Contact Group(correct)
    • D. Distribution lists must be created in Active Directory

    Explanation: In Outlook, contact groups (distribution lists) are created from the People tab or via New Items > New Contact Group. Option A is partially correct but not complete. File (B) doesn't have this option. Active Directory (D) is an option but not the only one.

24. 24. You want to automatically respond to emails while you're out of the office. Which Outlook feature enables this?

    • A. Out of Office Assistant or AutoReply(correct)
    • B. Create an email rule to forward emails automatically
    • C. Unsubscribe from all mailing lists before leaving
    • D. Out of office responses cannot be automated

    Explanation: Out of Office Assistant (File > Automatic Replies in newer versions) sends automatic responses to incoming email. Email rules (B) forward or organize but don't send replies. Unsubscribing (C) doesn't send responses. Auto-reply is supported (D is false).

25. 25. Which TWO actions help keep your contact list organized and up-to-date? Choose 2.

    • A. Regularly delete old or duplicate contacts
    • B. Store all contact details in email subject lines
    • C. Add custom fields or notes to contact records for additional information(correct)
    • D. Create contact groups for frequently emailed recipients(correct)
    • E. Never update existing contacts, only add new ones

    Explanation: Custom fields (C) add context, and contact groups (D) organize communication. Deleting duplicates (A) helps but isn't as proactive. Email subjects (B) are impractical. Never updating (E) creates outdated records.