Microsoft Office Specialist (MOS) Exam — Questions and Answers

Question 1: A user wants to calculate the monthly payment for a loan. They have the annual interest rate in cell B1 (6%), the loan term in years in cell B2 (5), and the loan amount (present value) in cell B3 ($25,000). Which formula correctly calculates the monthly payment?

=PMT(B1, B2*12, B3)
=PMT(B1/12, B2*12, B3) (Correct answer)
=PMT(B1, B2, B3/12)
=PMT(B1/12, B2, -B3)

Correct answer: =PMT(B1/12, B2*12, B3)

The PMT function calculates the payment for a loan. Its syntax is PMT(rate, nper, pv, ...). Since the payment is monthly, the annual interest rate (rate) must be divided by 12, and the loan term in years (nper) must be multiplied by 12 to get the total number of monthly periods.

Question 2: Which Excel feature lets you save a customized chart format so you can apply it to future charts quickly?

Cell Styles
Conditional Formatting
Named Ranges
Chart Templates (Correct answer)

Correct answer: Chart Templates

Saving a chart as a Chart Template (.crtx file) stores its formatting, colors, and layout for reuse via the Change Chart Type dialog.

Question 3: What is the purpose of the 'Space Before' setting in paragraph formatting?

Sets the left indent of the paragraph
Adds vertical space above the paragraph (Correct answer)
Adds space between characters in the paragraph
Adjusts the first-line indent

Correct answer: Adds vertical space above the paragraph

'Space Before' adds a specified amount of vertical whitespace above a paragraph, measured in points.

Question 4: When you forward a meeting request to someone who was not originally invited, what is the result?

The organizer automatically receives a notification and adds them to the attendee list
The new recipient receives the meeting details but is not tracked in the organizer's response list (Correct answer)
The meeting is duplicated on the organizer's calendar
The forwarded recipient can view all other attendees' responses

Correct answer: The new recipient receives the meeting details but is not tracked in the organizer's response list

Forwarding adds the person to the meeting but the organizer does not see them in the tracking tab unless they use Add Attendees.

Question 5: A screenshot inserted via Insert > Screenshot in Word is by default placed as which type of object?

A linked file that updates automatically
An inline picture embedded in the document (Correct answer)
A floating shape with Square text wrap
A SmartArt graphic

Correct answer: An inline picture embedded in the document

Screenshots inserted through the Insert tab are embedded as inline pictures by default.

Question 6: How do you create an email signature in Outlook?

Home tab > New Items > Signature
View tab > Layout > Signatures
Insert tab > Signature > Signatures in a new message
File > Options > Mail > Signatures (Correct answer)

Correct answer: File > Options > Mail > Signatures

Email signatures are created and managed under File > Options > Mail > Signatures.

Question 7: When you use 'Arrange All' under the View tab with multiple workbooks open, which arrangement option tiles windows side by side horizontally?

Vertical (Correct answer)
Horizontal
Cascade
Tiled

Correct answer: Vertical

The 'Vertical' arrangement in Arrange All places workbook windows side by side in columns.

Question 8: What would you click under Find and Replace if you wanted to search the whole workbook for all instances of the text "California" and replace it with "Anaheim"?

Options > Look in > Formulas
Options > Match case
Options > Search > By rows
Options > Within > Workbook (Correct answer)

Correct answer: Options > Within > Workbook

Explanation: <br> "Options: Within: Workbook” option allows you to search for the text "California" and replace it with "Anaheim" throughout the entire workbook. It ensures that your search covers all sheets and cells within the workbook, enabling comprehensive text replacement.

Question 9: You want to move a worksheet to the last position in a workbook with 5 sheets. What is the fastest method?

Press Alt+H then M to move the active sheet
Drag the sheet tab to the right of all other tabs (Correct answer)
Use Ctrl+Shift+End to reposition the sheet
Right-click the tab, choose Move or Copy, select '(move to end)'

Correct answer: Drag the sheet tab to the right of all other tabs

Dragging a sheet tab to the desired position is the fastest way to reorder worksheets in Excel.

Question 10: You want to apply a predefined visual style to your entire table. Where do you find Table Styles in Word?

Table Tools > Design > Table Styles (Correct answer)
Insert > Table > Table Styles
Home > Styles > Table Styles
Format > Table > Styles

Correct answer: Table Tools > Design > Table Styles

Table Styles are found in the Table Tools > Design tab's Table Styles gallery.

Question 11: What does the 'Very Hidden' property for a worksheet mean compared to 'Hidden'?

Very Hidden sheets can only be unhidden via the VBA editor, not through the Format menu (Correct answer)
Very Hidden sheets cannot be printed even when unhidden
Very Hidden prevents the sheet from being copied to another workbook
Very Hidden sheets are password protected by default

Correct answer: Very Hidden sheets can only be unhidden via the VBA editor, not through the Format menu

A 'Very Hidden' sheet (xlSheetVeryHidden) cannot be unhidden through the standard Format menu — only through the VBA editor.

Question 12: To add a trendline to a chart, you must first:

Click the chart title
Select the entire chart area
Select the data series in the chart (Correct answer)
Open the Format Cells dialog

Correct answer: Select the data series in the chart

A trendline is added to a specific data series, so you must select that series before accessing the Add Trendline option.

Question 13: What is the purpose of the 'Preserve Master' option in Slide Master view?

It prevents PowerPoint from deleting the master if no slides use it (Correct answer)
It copies the master to the clipboard
It locks the master so no edits can be made
It saves the master to a .potx file automatically

Correct answer: It prevents PowerPoint from deleting the master if no slides use it

Enabling Preserve Master ensures PowerPoint keeps the Slide Master even if all slides using it are deleted, so it stays available for future use.

Question 14: How do you insert an automatically updating field that displays the total number of pages in a Word document?

Insert > Quick Parts > Field > NumPages (Correct answer)
Insert > Header & Footer > Page Number > Total Pages
References > Insert Caption > Pages
Type {PAGES} manually

Correct answer: Insert > Quick Parts > Field > NumPages

Insert > Quick Parts > Field > NumPages inserts a field code that automatically reflects the total page count.

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

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

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 16: What does the 'Distributed' paragraph alignment option do, as opposed to 'Justify'?

It distributes text into multiple columns
It justifies all lines including the last line of the paragraph (Correct answer)
It aligns text to the center only
It distributes paragraphs evenly across all pages

Correct answer: It justifies all lines including the last line of the paragraph

Distributed alignment justifies every line including the last, spreading all text evenly edge-to-edge, unlike Justify which leaves the last line left-aligned.

Question 17: A Word table has alternating shaded rows for readability. Which Table Style option applies this formatting?

Home > Shading > Alternate Rows
Table Properties > Shading > Every Other Row
Layout > Rows > Band Shading
Banded Rows checkbox in Table Tools > Design > Table Style Options (Correct answer)

Correct answer: Banded Rows checkbox in Table Tools > Design > Table Style Options

Enabling Banded Rows in the Table Style Options group on the Design tab applies alternating row shading from the selected style.

Question 18: Which of these options describes how the document's personal information is provided?

Header
Cover Page
Document Property (Correct answer)
Footer

Correct answer: Document Property

Explanation: <br> The Document Property” option provides the personal data included within the document. With this function, users can furnish the document with relevant details like the author's name, title, subject, and keywords. The document properties section provides access to and viewing of this data, which offers more context and document details.

Question 19: When a chart is selected in Excel, two contextual tabs appear on the Ribbon, providing specific tools for chart manipulation. What are these two tabs called?

Insert and Page Layout
Data and Review
View and Formulas
Chart Design and Format (Correct answer)

Correct answer: Chart Design and Format

When you select a chart object, Excel displays contextual tools to help you work with it. The two tabs that appear under 'Chart Tools' are 'Chart Design' (for changing chart type, layout, styles, and data) and 'Format' (for formatting shapes, fills, and text).

Question 20: What is the purpose of the 'Hidden and Empty Cells' option in the Select Data Source dialog?

To lock chart data so it cannot be edited
To control how the chart handles missing or hidden data points (Correct answer)
To apply a filter that removes outliers from the chart
To hide specific data series from the chart permanently

Correct answer: To control how the chart handles missing or hidden data points

This setting determines whether the chart gaps, connects with a line, or plots zero for cells that are blank or in hidden rows/columns.

Question 21: What does the 'Lock Aspect Ratio' checkbox do in the Layout dialog's Size tab?

Locks the image's position on the page
Prevents the image from being moved
Ensures width and height scale together when either is changed (Correct answer)
Prevents text from wrapping around the image

Correct answer: Ensures width and height scale together when either is changed

Lock Aspect Ratio keeps the width-to-height ratio constant so the image does not distort when resized.

Question 22: Which option would you use to add a decorative first letter that drops down several lines at the beginning of a paragraph?

WordArt
Initial Cap style
Large Text effect
Drop Cap (Correct answer)

Correct answer: Drop Cap

The Drop Cap feature (Insert tab > Text group > Drop Cap) enlarges the first letter of a paragraph and drops it down to span multiple lines.

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

=EXTERNAL(WorkbookName,SheetName,CellRef)
=[SheetName!CellRef]WorkbookName
='[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 24: In the Animation Pane, what does a yellow bar represent for an animation item?

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

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 25: When applying a transition, where do you set the duration of the transition effect?

Design tab > Customize group
Animations tab > Timing group > Duration field
Transitions tab > Timing group > Duration field (Correct answer)
Slide Show tab > Set Up group

Correct answer: Transitions tab > Timing group > Duration field

The Duration field in the Timing group on the Transitions tab controls how long the transition effect lasts.

Question 26: What happens when you use the 'Clean Up Conversation' feature in Outlook?

All unread messages are marked as read
All messages in the conversation are permanently deleted
The conversation is collapsed into a single thread
Redundant messages whose content is included in a later reply are moved to the Deleted Items folder (Correct answer)

Correct answer: Redundant messages whose content is included in a later reply are moved to the Deleted Items folder

Clean Up Conversation removes redundant messages—those whose full content already appears in a later reply—moving them to Deleted Items.

Question 27: You are customizing a presentation theme and want to change the font of the title placeholder to 'Arial Black' only for slides that use the 'Title and Content' layout, without affecting the title font on other layouts like the 'Title Slide'. Where must you make this specific change?

On the parent Slide Master.
In 'Normal' view, on an individual slide currently using that layout.
On the specific 'Title and Content' layout within the Slide Master view. (Correct answer)
In the 'Outline View' by selecting the titles for those slides.

Correct answer: On the specific 'Title and Content' layout within the Slide Master view.

Changes made to a specific layout in Slide Master view only affect slides using that particular layout. Modifying the parent Slide Master would change the title font on all layouts that inherit from it, while a change in 'Normal' view only affects a single slide.

Question 28: A user wants to prevent others from editing a specific paragraph in a shared document. Which Word feature should they use?

Mark the document as Final
Restrict Editing with exceptions (Correct answer)
Password-protect the file
Enable Track Changes

Correct answer: Restrict Editing with exceptions

Restrict Editing (Review > Protect > Restrict Editing) lets you lock specific sections while allowing others to remain editable.

Question 29: Which paragraph alignment option spreads text evenly between both the left and right margins?

Justify (Correct answer)
Left
Right
Center

Correct answer: Justify

Justified alignment expands spacing between words so that each line (except the last) reaches both margins.

Question 30: You are working on a report and notice that a paragraph is split, with its last line appearing by itself at the top of a new page. What is this formatting issue called, and which paragraph setting should you use to prevent it?

An orphan; enable 'Keep with next'
A runover; enable 'Page break before'
A widow; enable 'Widow/Orphan control' (Correct answer)
A straggler; enable 'Keep lines together'

Correct answer: A widow; enable 'Widow/Orphan control'

A 'widow' is the last line of a paragraph appearing alone at the top of a page. The 'Widow/Orphan control' feature in Word's Paragraph settings is designed specifically to prevent this by ensuring at least two lines of a paragraph appear at the top or bottom of a page.

Question 31: When an image is set to 'Behind Text' wrapping, what behavior does the image have?

Text appears only above and below the image
Text flows tightly around the image's outline
The image is anchored and cannot be moved
The image acts as a watermark-style background behind the text (Correct answer)

Correct answer: The image acts as a watermark-style background behind the text

Behind Text places the image on a layer beneath the text layer, allowing text to appear over the image.

Question 32: A user is trying to find an important email from last quarter that had a contract attached. They remember the sender was "David Chen" and the subject line contained the word "Agreement". Which of the following is the most effective search query to use in the Outlook search bar?

subject:Agreement OR from:"David Chen"
from:"David Chen" AND hasattachments:yes AND subject:Agreement (Correct answer)
David Chen Agreement contract
received:<last quarter AND attachment:contract.docx

Correct answer: from:"David Chen" AND hasattachments:yes AND subject:Agreement

Using specific search keywords like `from:`, `subject:`, and `hasattachments:yes` combined with the `AND` operator provides the most precise criteria to find the exact email. The other options are either too broad, use the wrong operator (OR), or use incorrect syntax.

Question 33: Which tab in PowerPoint contains the Transitions gallery?

Design
Transitions (Correct answer)
Slide Show
Animations

Correct answer: Transitions

The Transitions tab houses the full gallery of slide transition effects along with timing options.

Question 34: A user wants to convert a multi-column table back into plain text, with each column's data separated by a comma. Which sequence of commands should be used?

Select the table, go to the Table Design tab, click 'Export', and choose 'Comma Separated'.
Right-click the table, select 'Table Properties', and choose 'Convert to Text'.
Select the table, go to the Insert tab, and click 'Convert Table to Text'.
Select the table, go to the Layout tab under Table Tools, click 'Convert to Text', and then choose 'Commas'. (Correct answer)

Correct answer: Select the table, go to the Layout tab under Table Tools, click 'Convert to Text', and then choose 'Commas'.

The 'Convert to Text' feature is located on the 'Layout' contextual tab within the 'Data' group. After clicking this, a dialog box appears where the user can specify the separator for the text, such as a comma, tab, or paragraph mark.

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

Export all calendar events to a CSV file for sharing
Merge your calendar with another user's calendar permanently
Publish your calendar availability to colleagues within your organization via an email invitation (Correct answer)
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 36: Which feature allows you to repeat a table's header row on each page when a table spans multiple pages?

References > Insert Caption > Header Row
Insert > Header > Link to Table
Layout > Breaks > Page Break before the row
Table Properties > Row > Repeat as header row at the top of each page (Correct answer)

Correct answer: Table Properties > Row > Repeat as header row at the top of each page

The 'Repeat as header row at the top of each page' option in Table Properties ensures the header repeats across pages.

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

These practice questions were written with AI tools. They are not real exam questions. Exam facts are checked against the official sources listed below. Not reviewed by a subject-matter expert. Editorial policy

Sources & references

Exam facts on this page (fees, format, dates, passing scores) are checked against these official sources; the date is our last check. Editorial policy

store.certiport.com — Fees · verified Oct 2026
certiport.pearsonvue.com — Score validity · verified Oct 2026
learn.microsoft.com — Retake policy · verified Oct 2026
certiport.pearsonvue.com — Passing score · verified Oct 2026
learn.microsoft.com — Time limit · verified Oct 2026
certiport.pearsonvue.com — Test delivery · verified Oct 2026