Microsoft Office Specialist (MOS) Exam — Questions and Answers

Question 1: A user wants to apply the same custom formatting (font, size, and color) from one heading to several other headings throughout a lengthy document. What is the most efficient way to do this?

Manually select each heading and re-apply the formatting options one by one.
Create a new Quick Style based on the formatted heading and then apply that style to the other headings. (Correct answer)
Copy the formatted heading and paste it over each of the other headings.
Select the formatted text, double-click the Format Painter, and then click on each subsequent heading.

Correct answer: Create a new Quick Style based on the formatted heading and then apply that style to the other headings.

Creating a new style is the most efficient method for applying consistent formatting throughout a document, especially a long one. Once the style is created, it can be applied to any text with a single click. Double-clicking the Format Painter is also efficient for multiple applications, but styles offer better long-term document management and consistency.

Question 2: What does the 'Character Spacing' setting 'Expanded' do to text?

Increases the font size
Stretches characters horizontally
Adds space between individual characters (Correct answer)
Increases line spacing

Correct answer: Adds space between individual characters

The 'Expanded' character spacing option increases the amount of space between each character in the selected text.

Question 3: You have created a standardized budget workbook that your team will use as a starting point for all new projects. To prevent accidental overwriting of the original file, you need to save it in a format that opens as a new, untitled copy each time. Which file type should you choose in the 'Save As' dialog box?

Excel Macro-Enabled Workbook (.xlsm)
Excel Binary Workbook (.xlsb)
Excel Workbook (.xlsx)
Excel Template (.xltx) (Correct answer)

Correct answer: Excel Template (.xltx)

Saving a file as an Excel Template (.xltx) creates a master copy. When a user opens a template file, Excel automatically creates a new, unsaved workbook based on the template, leaving the original template file untouched.

Question 4: In Word, what is the effect of applying the 'Hidden' font formatting to text?

The text becomes password-protected
The text is not printed or displayed unless Show All Formatting Marks is on (Correct answer)
The text is moved to a hidden layer
The text turns white

Correct answer: The text is not printed or displayed unless Show All Formatting Marks is on

Hidden text is invisible on screen and does not print unless you enable 'Show hidden text' in Word Options or toggle Show/Hide marks.

Question 5: A project manager needs to compare sales data from two different workbooks simultaneously. What is the most efficient way to display both workbooks on the screen side-by-side for comparison?

Use the 'New Window' command on the View tab for each workbook.
Open both workbooks and use the 'Arrange All' command on the View tab. (Correct answer)
Use the 'Switch Windows' command to toggle back and forth quickly.
Copy and paste the data from one workbook into a new sheet in the other.

Correct answer: Open both workbooks and use the 'Arrange All' command on the View tab.

The 'Arrange All' command on the View tab is designed to organize all open workbook windows on the screen. The user can choose from options like Tiled, Horizontal, or Vertical to view them simultaneously.

Question 6: Which option lets you prevent a table row from breaking across a page boundary?

Insert > Page Break before the row
Layout > Paragraph > Keep with Next
Table Properties > Row > Allow row to break across pages (uncheck) (Correct answer)
Table Tools > Design > Row Bands > Lock Row

Correct answer: Table Properties > Row > Allow row to break across pages (uncheck)

Unchecking 'Allow row to break across pages' in Table Properties > Row prevents the row from splitting across pages.

Question 7: After you insert a shape (such as a rectangle or an arrow) and select it, which contextual tab appears on the Ribbon, providing tools for formatting?

Shape Format (Correct answer)
Drawing Tools
Picture Format
Graphics Format

Correct answer: Shape Format

When a shape is selected, the 'Shape Format' contextual tab appears. This tab contains specific tools for modifying the shape's fill, outline, effects, and text.

Question 8: Which chart type is best suited for showing the proportion of parts to a whole?

Bar chart
Line chart
Pie chart (Correct answer)
Scatter chart

Correct answer: Pie chart

A pie chart displays data as slices of a circle, making it ideal for showing each category's proportion of a total.

Question 9: How do you add a Teams or Skype link to an Outlook meeting request?

Go to File > Add-ins and enable the virtual meeting plugin
Click the 'Teams Meeting' or 'Skype Meeting' button in the Meeting tab ribbon when composing the request (Correct answer)
Paste the meeting URL manually into the location field
Use Insert > Link and select a Teams meeting template

Correct answer: Click the 'Teams Meeting' or 'Skype Meeting' button in the Meeting tab ribbon when composing the request

The Teams Meeting button in the Meeting ribbon inserts a Join link and dial-in details automatically into the meeting body.

Question 10: To reference the words on the same page, which of the following will you use?

Footnote (Correct answer)
Smart Art
Footer
Header

Correct answer: Footnote

Explanation: <br> A footnote would be used to provide the reference for the words that are on the same page. A footnote is a brief statement that appears at the bottom of a page and offers further details or citations for the material on the page. It keeps the main text's flow intact while making it simple for the reader to find the definition or source of any given term or phrase.

Question 11: 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?

Cc (Carbon Copy)
From
To
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 12: What does the 'Mark as Final' command do to a Word document?

Permanently locks editing for all users
Makes the document read-only and disables typing (Correct answer)
Encrypts the file with a password
Deletes all tracked changes

Correct answer: Makes the document read-only and disables typing

Mark as Final sets the document to read-only mode and notifies readers it is a finished version, but this can be undone.

Question 13: A user is creating a report and wants to insert a diagram to visually represent a hierarchical process, such as an organization chart. Which feature from the Insert tab should they use?

Screenshot
Chart
SmartArt (Correct answer)
3D Models

Correct answer: SmartArt

SmartArt is the correct tool in Word for creating visual representations of information like processes, hierarchies, and cycles. While a Chart is used for numerical data, a Screenshot captures the screen, and 3D Models are for inserting three-dimensional objects, SmartArt is specifically designed for creating diagrams like organizational charts.

Question 14: Which command on the SmartArt Design tab changes all colors used in a SmartArt graphic at once?

Layouts
Reset Graphic
Change Colors (Correct answer)
SmartArt Styles

Correct answer: Change Colors

Change Colors offers preset color combinations based on the document's theme colors applied to all SmartArt shapes simultaneously.

Question 15: What is the purpose of adding Alt Text to an image in a Word document?

It makes the image searchable in Windows Explorer
It compresses the image for smaller file size
It adds a visible caption below the image
It provides a text description for screen readers and accessibility tools (Correct answer)

Correct answer: It provides a text description for screen readers and accessibility tools

Alt Text provides a textual description of an image so screen readers can convey its content to visually impaired users.

Question 16: Which view in Outlook groups email messages by their conversation thread?

Conversation view (Correct answer)
Compact view
Reading Pane view
By Category

Correct answer: Conversation view

Conversation view groups all replies and forwards related to an original message together, making it easier to follow a discussion.

Question 17: When would you use an Error Bar on a chart?

To visualize the variability or uncertainty around each data point (Correct answer)
To indicate that a data series has missing values
To add a statistical regression line to the chart
To mark data points that fall outside the chart's axis range

Correct answer: To visualize the variability or uncertainty around each data point

Error bars display the margin of error, standard deviation, or confidence interval around plotted values, communicating data uncertainty.

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

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

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 19: How can you apply multiple different animations to the same object in PowerPoint?

Use Copy/Paste Special for each animation
Duplicate the object for each animation
Use 'Add Animation' on the Animations tab to add each subsequent effect (Correct answer)
Drag additional effects from the gallery onto the object

Correct answer: Use 'Add Animation' on the Animations tab to add each subsequent effect

Clicking 'Add Animation' instead of selecting from the main gallery lets you stack additional animation effects on the same object.

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

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

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 21: Which tab appears in the Ribbon only when you are in Slide Master view?

Transitions
Review
Design
Slide Master (Correct answer)

Correct answer: Slide Master

The Slide Master tab is a contextual tab that appears in the Ribbon exclusively when Slide Master view is active.

Question 22: A workbook's file size is unexpectedly large. Which action in File > Info can help identify the cause?

Inspect Document to check for hidden rows/sheets (Correct answer)
View Permissions to check linked data sources
Check Compatibility to find size-heavy features
Manage Workbook to review unsaved versions

Correct answer: Inspect Document to check for hidden rows/sheets

The Document Inspector can reveal hidden worksheets, rows, columns, and other data that may inflate file size.

Question 23: You right-click a sheet tab and do not see the 'Ungroup Sheets' option. What does this indicate?

The workbook is protected
The sheet is hidden
You must use the Format menu to ungroup
No sheets are currently grouped (Correct answer)

Correct answer: No sheets are currently grouped

'Ungroup Sheets' only appears in the context menu when multiple sheets are currently grouped.

Question 24: Which motion path option makes an animated object follow a circular route?

Circle (Correct answer)
Arc
Spiral
Loops

Correct answer: Circle

The Circle motion path causes the object to travel in a circular route around its starting position.

Question 25: What does the 'Keep with next' paragraph option do?

Prevents a page break between the paragraph and the one that follows it (Correct answer)
Keeps the paragraph on the same line as the next word
Locks the paragraph so it cannot be edited
Keeps all lines of the paragraph on the same page

Correct answer: Prevents a page break between the paragraph and the one that follows it

'Keep with next' ensures the selected paragraph always appears on the same page as the paragraph immediately following it.

Question 26: In Excel, 'Sparklines' differ from regular charts in which key way?

Sparklines automatically update only when the workbook is manually recalculated
Sparklines support all 20+ chart types available in Excel
Sparklines can be printed independently of the worksheet
Sparklines are miniature charts inside a single cell, not separate chart objects (Correct answer)

Correct answer: Sparklines are miniature charts inside a single cell, not separate chart objects

Sparklines are tiny, cell-embedded charts that provide an at-a-glance data trend without taking up chart object space.

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

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

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.

Question 28: What is the effect of applying 'Through' text wrapping to an image?

Text flows through any transparent areas within the image's editing points (Correct answer)
Text is hidden behind the image completely
Text flows around the image's rectangular bounding box
Text flows only above and below the image

Correct answer: Text flows through any transparent areas within the image's editing points

Through wrapping allows text to fill any open or transparent areas within the image's wrap points, unlike Tight which only wraps the outer edge.

Question 29: To best illustrate the contribution of several product categories to the total annual sales, where each category is a part of the whole, which chart type is most appropriate?

Pie Chart (Correct answer)
Scatter Plot
Histogram
Line Chart

Correct answer: Pie Chart

A Pie Chart is the ideal chart type for showing the proportions of individual parts to a whole. Each slice represents a category's percentage of the total. A Line Chart shows trends over time, a Scatter Plot shows relationships between variables, and a Histogram shows frequency distribution.

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

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

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 31: In Access Query Design View, what is the purpose of the 'Criteria' row?

To add calculated fields to the query output
To filter records based on conditions they must meet (Correct answer)
To specify which fields appear in the query results
To sort the query results in ascending or descending order

Correct answer: To filter records based on conditions they must meet

The Criteria row lets you enter conditions (such as ='Smith' or >100) that records must satisfy to be included in query results.

Question 32: A user wants to sort a list of names in a table alphabetically by last name. Which tab contains the Sort command?

References
View
Home
Table Tools > Layout (Correct answer)

Correct answer: Table Tools > Layout

The Sort command for table data is located in the Data group on the Table Tools > Layout tab.

Question 33: How can you change the text direction inside a table cell to read vertically?

Home > Paragraph > Text Direction
Table Tools > Layout > Alignment > Text Direction (Correct answer)
Format > Text > Rotate 90°
Insert > Text Box > Vertical

Correct answer: Table Tools > Layout > Alignment > Text Direction

The Text Direction button in Table Tools > Layout > Alignment cycles the cell text through horizontal and vertical orientations.

Question 34: When applying a transition, where do you set the duration of the transition effect?

Slide Show tab > Set Up group
Animations tab > Timing group > Duration field
Transitions tab > Timing group > Duration field (Correct answer)
Design tab > Customize 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 35: In Outlook, what is the 'Clutter' or 'Focused Inbox' feature designed to do?

Group newsletters into a single digest
Delete low-priority messages automatically
Mark promotional emails as junk
Separate high-priority messages from less important ones into two tabs (Correct answer)

Correct answer: Separate high-priority messages from less important ones into two tabs

Focused Inbox separates your inbox into 'Focused' (important messages) and 'Other' (lower-priority messages) tabs.

Question 36: What does Ctrl+E do in Microsoft Word?

Opens the Find dialog
Center-aligns the selected paragraph (Correct answer)
Inserts an endnote
Applies Emphasis style

Correct answer: Center-aligns the selected paragraph

Ctrl+E is the shortcut for center alignment, centering the selected paragraph between the left and right margins.

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