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

Question 1

You are creating a formal document in Microsoft Word. You need to insert page numbers in the footer, starting from page 2. Which tab contains the option to modify page number settings?

Accepted Answer

The Insert tab contains the Header & Footer options. From there, you can insert page numbers and configure them to start from a specific page number. The Design tab appears when headers/footers are active but doesn't contain the main insertion options. Layout and View tabs serve different purposes.

Question 2

You have a document with a two-column layout. You need to apply a border only to the first column without affecting the second column. What is the best approach?

Accepted Answer

To apply formatting to a specific column in a multi-column layout, you can insert a text box or use section breaks with different border settings. Option A applies borders to paragraphs, not columns. Option B modifies column structure. Option D is false; there are workarounds.

Question 3

You are working on a long document with numbered headings (1.1, 1.2, 2.1, etc.). After inserting a new section, the numbering becomes inconsistent. You need to reset the numbering using built-in outline levels. Which method is most appropriate?

Accepted Answer

The Multilevel List feature on the Home tab allows you to apply numbering schemes that are tied to heading styles and outline levels. This ensures consistent numbering throughout the document. Manual editing (B) is inefficient and error-prone. Deleting (C) is unnecessary. Track Changes (D) records changes but doesn't solve the numbering issue.

Question 4

You need to protect a Word document so that reviewers can only add comments, not edit the content. Which feature should you use?

Accepted Answer

The Restrict Editing option (found under Review tab or File > Info > Protect Document) allows you to specify what users can do with the document. You can restrict editing to comments only. Mark as Final (A) discourages but doesn't prevent editing. Track Changes (C) doesn't restrict editing. Read-Only (D) prevents saving, not editing.

Question 5

You are formatting a document for printing. Which TWO of the following should you check before printing to ensure the document displays correctly? Choose 2.

Accepted Answer

Margins, page orientation, and widow/orphan control affect how the document prints across pages. Font color (B) doesn't require pre-check unless printing in grayscale (not standard). Theme name (D) is cosmetic. Track Changes status (E) affects display but isn't critical for printing setup.

Question 6

You have a document with a custom style that you want to share with colleagues. What is the best way to ensure they receive the exact style definition?

Accepted Answer

Saving custom styles to a template (.dotx) and sharing that template ensures all style definitions are transferred accurately. Copy/paste (A) doesn't transfer style definitions. Screenshots (C) are visual only. Format Painter (D) copies formatting to existing styles but doesn't export definitions.

Question 7

You are creating a new Excel workbook. You need to add a second worksheet to the existing workbook. Which of the following is the quickest way to add a new sheet?

Accepted Answer

The plus icon (+) next to the sheet tabs is the quickest way to add a new sheet. Right-click (A) works but opens a dialog. File menu (B) creates a new workbook, not a sheet. Ctrl+N (D) creates a new workbook.

Question 8

You have a large dataset in Excel. You need to freeze the first three rows so they remain visible when scrolling down. Which feature should you use?

Accepted Answer

Freeze Panes (View tab) allows you to freeze rows and columns so they stay visible while scrolling. You must click on the first cell below the rows you want to freeze. Split Cells (B) merges/splits cell content. Lock Cells (C) protects sheets. Split Window (D) creates two independent viewing panes.

Question 9

You are working with a complex workbook containing multiple sheets with related data. You need to create a summary sheet that pulls data from specific cells across different sheets. Which function should you use to reference cells from other sheets?

Accepted Answer

The syntax for referencing cells in other sheets is =SheetName!CellAddress (e.g., =Sheet2!A1). This works for both internal and external references. Options A, C, and D are not valid Excel functions for sheet references.

Question 10

You need to ensure that a column of data always displays at least two decimal places, even if the values are whole numbers. Which formatting option should you apply?

Accepted Answer

Format Cells (Ctrl+1) allows you to set number format with specific decimal places. The Increase Decimal button (C) also works but Format Cells provides more control. Column width (A) doesn't control decimals. Custom formulas (D) change values, not display.

Question 11

You want to protect your worksheet so that users can edit only certain cells. Which TWO steps are necessary to accomplish this? Choose 2.

Accepted Answer

To allow editing of specific cells while protecting others: (1) unlock the cells to be edited via Format Cells > Protection, (2) protect the sheet via Review > Protect Sheet. Data Validation (D) restricts data type, not editing. Conditional Formatting (E) changes appearance based on conditions.

Question 12

You need to rename a worksheet. What is the fastest way to do this?

Accepted Answer

Double-clicking a sheet tab enters edit mode, allowing you to rename it directly. Right-click (A) also works but requires menu navigation. The Sheet menu (C) doesn't have direct rename. Ctrl+R (D) is not a standard shortcut for renaming sheets.

Question 13

You have a workbook with sensitive financial data. You need to hide an entire worksheet from view without deleting it. How can you accomplish this?

Accepted Answer

Right-clicking a sheet tab reveals the 'Hide' option, which hides the sheet from view but retains it in the workbook. Only unhide (via right-click) makes it visible again. Format > Hidden (B) hides cells, not sheets. Protection (C) doesn't hide. Moving (D) is unnecessary.

Question 14

You are creating a presentation in PowerPoint. You need to add a slide with a title and bullet points layout. Which is the quickest way to add this specific layout?

Accepted Answer

The New Slide button (Home tab or Quick Access Toolbar) has a dropdown showing layout options. Selecting directly from this dropdown is quickest. Option A accesses layouts but not as directly. Option B creates a slide but doesn't apply layout. Option D creates a new presentation.

Question 15

You have a presentation with multiple slides using different color schemes. You need to apply a consistent design by changing all slides at once. Which feature should you use?

Accepted Answer

The Design tab offers themes that apply consistently to all slides in the presentation. View > Slide Master (C) allows editing master slide layouts, which also affects all slides but is more advanced. Format Painter (B) copies individual formatting. Outline View (D) manages text only.

Question 16

You need to create a custom animation where text appears one bullet point at a time when presenting. You also want the animation to reverse when clicking backward during the slideshow. Which animation feature should you configure?

Accepted Answer

Entrance animations with 'On Click' and 'Reverse' option (found in Animation Pane) allow bullets to appear on click and reverse when navigating backward. Transitions (B) apply to slides, not objects. Auto timing (C) doesn't support click-based display. Multiple animations (D) work but aren't the standard approach.

Question 17

You want to embed a video into your PowerPoint presentation. Which option ensures the video is included in the file when sharing with others?

Accepted Answer

Inserting a video from a local device embeds it in the presentation file. Online videos (B) require internet access during presentation. OLE Objects (C) typically link rather than embed. Videos can be embedded (D is false).

Question 18

You need to prepare presenter notes for a slideshow. Where can you access and edit presenter notes in PowerPoint?

Accepted Answer

In Normal view, the Notes section appears below the slide, allowing you to add presenter notes. Notes Page (A) is a full-page view specifically for notes. Text boxes (C) are visible during presentation. Properties (D) is for file metadata.

Question 19

You are preparing to present your PowerPoint to a large audience. Which TWO features help ensure a smooth presentation experience? Choose 2.

Accepted Answer

Presenter View (A) and Pointer tools (D) enhance live presentation experience. Custom timings (B) work for unattended presentations but not live ones. Kiosk Mode (C) gives audience control. Recording (E) removes live interaction.

Question 20

You are creating a new email in Outlook. You need to add multiple recipients to the CC field. How should you separate the email addresses?

Accepted Answer

Outlook accepts both commas and semicolons as separators for email addresses in recipient fields. Either works, though semicolons are more traditional for Outlook. Spaces alone (C) are not sufficient as separators.

Question 21

You receive many emails daily and need to organize them automatically. You want emails from a specific sender to go to a designated folder. What is the best way to accomplish this?

Accepted Answer

Rules (File > Manage Rules & Alerts or similar, depending on Outlook version) automatically organize emails based on criteria like sender. Quick Steps (D) are manual actions applied after receiving. Manual methods (B, C) are time-consuming.

Question 22

You schedule a meeting for 2:00 PM and send invitations to attendees. Later, you need to change the meeting to 3:00 PM. You've already received acceptances from some attendees. What should you do to update everyone?

Accepted Answer

Opening the existing meeting, updating the time, and using 'Send Update' ensures all attendees receive a unified notification of the change. Sending a separate invitation (A) creates confusion. Canceling and creating new (C) is inefficient. Partial notification (D) leaves some uninformed.

Question 23

You want to ensure you don't forget birthdays of your important contacts. Which Outlook feature allows you to set automatic reminders for contact birthdays?

Accepted Answer

Contact information includes a birthday field. When filled in, Outlook automatically creates a birthday calendar (if enabled) that shows these dates. Recurring events (B) work but require manual setup. Email rules (C) are not designed for this. Outlook does support birthdays (D is false).

Question 24

You need to share your calendar with a colleague for a specific time period only. Which sharing option should you use?

Accepted Answer

The Share Calendar option allows you to grant permissions to specific people and define the level of access. Permanent online publishing (A) is not time-limited. .ics export (C) is one-time sharing, not dynamic. Calendars can be shared (D is false).

Question 25

You want to maintain good email hygiene and productivity. Which TWO practices are recommended for managing your Outlook inbox? Choose 2.

Accepted Answer

Categories (A) and Focused Inbox/Rules (C) help organize and prioritize emails. Keeping everything indefinitely (B) creates clutter. Deleting is reasonable but archiving (D) is better for compliance. Disabling all notifications (E) causes you to miss important emails.

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