Microsoft Office Specialist (MOS) Exam — Questions and Answers

Question 1: How do you add a watermark to every page of a Word document?

Insert > Header & Footer > Watermark
Home tab > Paragraph > Watermark
Design tab > Page Background > Watermark (Correct answer)
Layout tab > Arrange > Watermark

Correct answer: Design tab > Page Background > Watermark

Watermarks are added via Design > Page Background > Watermark and appear on all pages through the header layer.

Question 2: In the Animation Pane, what does a yellow bar represent for an animation item?

The duration of the animation effect
A trigger-based animation
An animation set to loop
The delay period before the animation starts (Correct answer)

Correct answer: The delay period before the animation starts

In the Animation Pane timeline view, the yellow (lighter) portion of the bar represents the delay before the animation begins playing.

Question 3: You need to remove a column from a table without deleting its content. Which action should you take first?

Use Home > Cut to remove the column
Right-click the column header and choose Hide Column
Select the column, then use Table Tools > Layout > Delete > Delete Columns (Correct answer)
Press the Delete key after selecting the column

Correct answer: Select the column, then use Table Tools > Layout > Delete > Delete Columns

To delete a table column in Word, select it and use the Delete Columns option under Table Tools > Layout.

Question 4: Which Animation Pane feature lets you change the order in which objects animate on a slide?

Reorder Animations arrows (Correct answer)
Trigger button
Effect Options
Animation Painter

Correct answer: Reorder Animations arrows

The up and down Reorder Animations arrows in the Animation Pane let you change the sequence of animations.

Question 5: A presenter wants slide numbers to appear on every slide except the title slide. What is the best approach using Slide Master view?

Add the slide number placeholder to the Slide Master but remove it from the Title Slide layout
Use Insert > Header & Footer and check 'Don't show on title slide'
Insert a slide number text box on each content slide manually
Both B and C achieve this goal (Correct answer)

Correct answer: Both B and C achieve this goal

You can either remove the footer/number placeholder from the Title Slide layout in Slide Master view or use the Header & Footer dialog's 'Don't show on title slide' option — both work.

Question 6: What does 'Widow/Orphan control' do in Word paragraph formatting?

Removes extra spaces between paragraphs
Keeps all paragraph lines on the same page
Adjusts spacing between widowed characters
Prevents single lines of a paragraph from appearing alone at the top or bottom of a page (Correct answer)

Correct answer: Prevents single lines of a paragraph from appearing alone at the top or bottom of a page

Widow/Orphan control prevents the first or last line of a paragraph from being stranded alone at the bottom or top of a page.

Question 7: Which Picture Format option lets you choose a specific color in the image to make fully transparent?

Corrections > Brightness
Artistic Effects > Blur
Remove Background
Color > Set Transparent Color (Correct answer)

Correct answer: Color > Set Transparent Color

Set Transparent Color lets you click any single color in the image to make all pixels of that color transparent.

Question 8: When you apply a 'Quick Layout' from the Chart Design tab, what does it change?

The color scheme and font used throughout the chart
The chart type while keeping the same data source
The arrangement of chart elements such as titles, legends, and data labels (Correct answer)
The size and position of the chart on the worksheet

Correct answer: The arrangement of chart elements such as titles, legends, and data labels

Quick Layouts are predefined arrangements that add, remove, or reposition chart elements like axes, titles, and legends in one click.

Question 9: In Word, which tab on the ribbon contains the 'Text Effects and Typography' button?

Format
Home (Correct answer)
Insert
Design

Correct answer: Home

The Text Effects and Typography button (represented by a glowing 'A') is located in the Font group on the Home tab.

Question 10: Which dialog box setting controls whether Word automatically adjusts spacing between specific pairs of characters (e.g., 'AV')?

Tracking
Kerning (Correct answer)
Leading
Ligatures

Correct answer: Kerning

Kerning adjusts the spacing between specific character pairs to improve visual appearance, and can be enabled in the Font dialog's Advanced tab.

Question 11: You right-click a slide in Normal view and choose 'Reset Slide.' What does this action do?

Reapplies the Slide Master theme colors
Restores placeholder size, position, and formatting to match the current layout (Correct answer)
Removes all animations from the slide
Deletes all content from the slide

Correct answer: Restores placeholder size, position, and formatting to match the current layout

Reset Slide restores the slide's placeholder positions, sizes, and formatting to the defaults defined in its assigned layout.

Question 12: How do you select every worksheet in a workbook simultaneously?

Right-click a tab and choose 'Select All Sheets' (Correct answer)
Click the first tab, then Ctrl+Shift+End
Shift+click the first and last tab
Ctrl+A while clicking any sheet tab

Correct answer: Right-click a tab and choose 'Select All Sheets'

Right-clicking any sheet tab and choosing 'Select All Sheets' groups all worksheets together.

Question 13: What does the 'Calendar Sharing' feature in Outlook allow you to do?

Publish your calendar availability to colleagues within your organization via an email invitation (Correct answer)
Merge your calendar with another user's calendar permanently
Export all calendar events to a CSV file for sharing
Copy your calendar to another user's Outlook profile

Correct answer: Publish your calendar availability to colleagues within your organization via an email invitation

Calendar Sharing sends an email invite granting specified colleagues permission to view your calendar at the access level you choose.

Question 14: How do you change the cell margins (padding) for all cells in a Word table at once?

Home > Paragraph > Spacing > Cell Padding
Table Properties > Cell > Options > Margins
Format > Table > Cell Padding
Table Tools > Layout > Alignment > Cell Margins (Correct answer)

Correct answer: Table Tools > Layout > Alignment > Cell Margins

Cell Margins in the Table Tools > Layout > Alignment group opens a dialog to set uniform or custom padding for all cells.

Question 15: Which menu option removes all animations from a selected object at once?

Right-click the object > Remove All Animations
Animations tab > None in the gallery
Select the animations in the Animation Pane and press Delete (Correct answer)
Edit tab > Clear > Animations

Correct answer: Select the animations in the Animation Pane and press Delete

Selecting all of an object's entries in the Animation Pane and pressing Delete removes every animation applied to that object.

Question 16: What does the IFERROR function do in Excel?

Returns a specified value if a formula results in an error, otherwise returns the formula's result (Correct answer)
Logs errors to a separate worksheet
Prevents formulas from being entered incorrectly
Highlights cells containing errors in red

Correct answer: Returns a specified value if a formula results in an error, otherwise returns the formula's result

IFERROR evaluates a formula and returns a custom value if it produces an error, or the formula result if no error occurs.

Question 17: In Outlook, which response option marks a meeting as accepted but signals you may not attend?

Forward
Propose New Time
Tentative (Correct answer)
Accept

Correct answer: Tentative

Tentative places the meeting on your calendar with a striped indicator, signaling uncertain attendance to the organizer.

Question 18: In a Word table, how do you evenly distribute the widths of all selected columns?

Table Layout tab > Distribute Columns (Correct answer)
Home tab > Paragraph > Columns
Right-click > Table Properties > Column
Design tab > Table Styles > AutoFit

Correct answer: Table Layout tab > Distribute Columns

The Distribute Columns button on the Table Layout tab divides the total width equally among all selected columns.

Question 19: How do you change a shape to a different shape type while keeping its size, position, and formatting?

Right-click > Format Shape > Type
Delete and reinsert a new shape with the same formatting
Insert > Shapes > Replace Current
Shape Format > Edit Shape > Change Shape (Correct answer)

Correct answer: Shape Format > Edit Shape > Change Shape

Edit Shape > Change Shape replaces the current shape with a new one while preserving applied formatting and dimensions.

Question 20: To link a chart title directly to a cell value so it updates automatically, you should:

Right-click the title and choose 'Link to Cell'
Type the cell reference directly into the chart title text box
Use the Define Name feature to name the title range
Select the chart title, type = in the formula bar, then click the source cell (Correct answer)

Correct answer: Select the chart title, type = in the formula bar, then click the source cell

After selecting the chart title, typing = in the formula bar and clicking a cell creates a live reference that keeps the title synchronized with that cell.

Question 21: Which Outlook option sends an automatic notification to the sender when you open their message?

Return Receipt
Read Receipt (Correct answer)
Open Notification
Delivery Receipt

Correct answer: Read Receipt

A Read Receipt is an automated notification sent to the original sender when the recipient opens the message.

Question 22: In a formal business proposal, you need to ensure that a specific heading and the paragraph that immediately follows it are never separated by a page break. Which option in the Paragraph dialog box should be used on the heading?

Keep with next (Correct answer)
Page break before
Keep lines together
Widow/Orphan control

Correct answer: Keep with next

The 'Keep with next' option is specifically designed to keep the selected paragraph (in this case, the heading) on the same page as the subsequent paragraph. 'Keep lines together' applies to lines within a single paragraph, and 'Widow/Orphan control' prevents single lines from being stranded.

Question 23: Which keyboard shortcut toggles double underline formatting in Word?

Ctrl+Shift+U
Alt+U
Ctrl+U
Ctrl+Shift+D (Correct answer)

Correct answer: Ctrl+Shift+D

Ctrl+Shift+D applies double underline formatting to selected text in Word.

Question 24: When you reset a picture in Word (Format > Reset Picture), what happens?

The picture is resized to its original dimensions only
The picture is deleted and must be reinserted
The picture's position is reset to inline
All formatting changes are removed and the original image is restored (Correct answer)

Correct answer: All formatting changes are removed and the original image is restored

Reset Picture removes all applied corrections, color changes, and effects, reverting the image to its original state.

Question 25: Which Outlook feature allows you to apply a color-coded label to messages to help organize and visually identify them?

Conditional Formatting
Themes
Categories (Correct answer)
Flags

Correct answer: Categories

Categories in Outlook let you assign color-coded labels to messages (and other items) for visual organization.

Question 26: Which Excel feature lets you define a name for a specific workbook file location so you can quickly switch between commonly used folders when saving?

Named Ranges for file paths
Custom Views
Places list in the Save As dialog (Pinned folders) (Correct answer)
Quick Access Toolbar shortcut

Correct answer: Places list in the Save As dialog (Pinned folders)

Pinning folders in the Save As dialog adds them to your Places list for quick access during save operations.

Question 27: You want the numbering in a list to continue from a previous numbered list rather than restart at 1. Which option do you choose?

Format > List > Link to Previous
Right-click and choose Restart at 1
Home > Numbering > Auto-Continue
Right-click the list and choose Continue Numbering (Correct answer)

Correct answer: Right-click the list and choose Continue Numbering

Right-clicking a numbered list and selecting Continue Numbering resumes counting from the previous list's last number.

Question 28: When you freeze panes in Excel, where does the freeze line appear relative to the selected cell?

Only to the right of the selected cell
Below and to the right of the selected cell (Correct answer)
Only below the selected cell
Above and to the left of the selected cell

Correct answer: Below and to the right of the selected cell

Freeze Panes freezes all rows above and all columns to the left of the currently selected cell.

Question 29: To correct the text as it is typed, which of the following will you use?

Template
AutoComplete
AutoText
AutoCorrect (Correct answer)

Correct answer: AutoCorrect

Explanation: <br> The function that will be used to edit the text as it is typed is called "AutoCorrect". Grammar and spelling mistakes are automatically found and corrected by AutoCorrect as the user types, offering suggestions or making edits in real-time. Text entry forms, chat apps, and word-processing tools frequently have this capability. Its automated error correction helps to increase typing accuracy and speed.

Question 30: Which function counts only the cells in a range that contain numbers?

COUNTIF
COUNTBLANK
COUNT (Correct answer)
COUNTA

Correct answer: COUNT

COUNT counts only numeric values, while COUNTA counts all non-empty cells regardless of data type.

Question 31: Which chart type is most appropriate for showing how individual parts contribute to a total across multiple categories?

Bubble chart
100% Stacked Bar chart (Correct answer)
Line chart
Scatter chart

Correct answer: 100% Stacked Bar chart

A 100% Stacked Bar chart normalizes each bar to 100%, making it easy to compare proportional contributions across categories.

Question 32: What is the function of the yellow adjustment handle that sometimes appears on a shape?

It modifies a specific geometric feature of the shape, like corner radius (Correct answer)
It changes the shape's color fill
It rotates the shape
It resizes the shape proportionally

Correct answer: It modifies a specific geometric feature of the shape, like corner radius

Yellow diamond handles let you adjust a shape's unique geometric property, such as the corner roundness of a rounded rectangle.

Question 33: A user needs to send an email to a list of external clients but wants to prevent the recipients from seeing each other's email addresses for privacy reasons. Which field should be used for the clients' addresses?

To
From
Cc (Carbon Copy)
Bcc (Blind Carbon Copy) (Correct answer)

Correct answer: Bcc (Blind Carbon Copy)

The Bcc (Blind Carbon Copy) field is used to send a copy of an email to recipients without revealing their email addresses to anyone else on the message. This is the standard method for protecting recipient privacy in a group email.

Question 34: Which command lets you set a specific row height to an exact measurement in a Word table?

Format > Row > Set Height
Home > Paragraph > Line Spacing > Row Height
Table Tools > Layout > Cell Size > Table Row Height field (Correct answer)
Table Properties > Cell > Height

Correct answer: Table Tools > Layout > Cell Size > Table Row Height field

The Table Row Height field in the Cell Size group on the Layout tab lets you enter an exact row height.

Question 35: You want to link a cell in one workbook to a cell in a different workbook. What syntax does the external reference use?

=[SheetName!CellRef]WorkbookName
=EXTERNAL(WorkbookName,SheetName,CellRef)
='[WorkbookName.xlsx]SheetName'!CellRef (Correct answer)
=[WorkbookName]SheetName!CellRef

Correct answer: ='[WorkbookName.xlsx]SheetName'!CellRef

External references use the syntax ='[WorkbookName.xlsx]SheetName'!CellRef with the filename in square brackets.

Question 36: Which of the following correctly describes the 'Plot Area' of a chart?

The background color applied to the chart title
The entire chart including the title and legend
The area containing the chart's axis labels
The rectangular region bounded by the axes where data is plotted (Correct answer)

Correct answer: The rectangular region bounded by the axes where data is plotted

The plot area is the inner region bounded by the chart axes where the actual data markers, bars, or lines appear.

Microsoft Office Specialist (MOS) Exam

The MOS certification is administered by Certiport (Pearson VUE) and validates proficiency in Microsoft Office applications including Word, Excel, PowerPoint, and Outlook. The exam uses performance-based, live-in-the-app tasks organized into projects rather than traditional multiple-choice questions.

Questions

50 min

Time Limit

70%

To Pass

Checking for saved progress...

Exam Rules

You can skip questions and return to them later
Flag questions for review before submitting
No feedback shown until you submit the entire exam
Unanswered questions count as wrong — answer everything
10 pretest questions are mixed in and don't affect your score
Timer auto-submits when time runs out
Your progress is auto-saved every 30 seconds