Microsoft Office Specialist (MOS) Certification exam answers 2026: This page lists all 100 questions of the official Microsoft Office Specialist (MOS) Certification exam by Itronix Solutions, each with its four answer options and the correct answer highlighted in green. Use it to revise every topic before you attempt the test and earn your verifiable certificate.
About this certification: The MOS (Microsoft Office Specialist) certification validates your skills in using Microsoft Office applications effectively.Learn to secure Microsoft Office with this certification.
| Certification | Microsoft Office Specialist (MOS) Certification |
| Provider | Itronix Solutions |
| Category | Office & Computer Basics |
| Total questions | 100 multiple-choice questions |
| Marks | 1 mark per question (100 marks) |
| Passing score | 80% (80 out of 100) |
| Retake | Available if you do not pass |
| Certificate | Verifiable online certificate |
Take the exam: Microsoft Office Specialist (MOS) Certification on Itronix Solutions. See every other Itronix exam in our complete list of Itronix certification answers.
Microsoft Office Specialist (MOS) Exam Questions and Answers
Questions 1 to 25
1. Which function returns the number of cells that meet a condition?
Correct answer: B. COUNTIF
2. What does the AutoSum button do?
Correct answer: B. Adds selected cells
3. Which shortcut key inserts the current date in a cell?
Correct answer: B. Ctrl + ;
4. What does =IF(A1>10, "Yes", "No") return if A1 is 5?
Correct answer: C. No
5. What is the use of Freeze Panes in Excel?
Correct answer: C. Keeps header rows/columns visible while scrolling
6. Which chart is best for showing percentages?
Correct answer: C. Pie chart
7. What does the function =VLOOKUP(101, A2:B10, 2, FALSE) do?
Correct answer: A. Looks for 101 in column A and returns value from column B
8. Which function calculates the average of selected values?
Correct answer: C. AVERAGE
9. The function =CONCAT(A1, B1) does what?
Correct answer: C. Combines text from A1 and B1
10. What does the Wrap Text option do?
Correct answer: C. Displays long text within the cell boundaries
11. Which Excel feature is used to quickly fill a series (e.g., Jan, Feb, Mar…)?
Correct answer: B. AutoFill
12. What is the default file extension for an Excel workbook?
Correct answer: B. xlsx
13. Which formula finds the largest number in a range?
Correct answer: C. =MAX(A1:A10)
14. Which tab is used to apply borders in Excel?
Correct answer: C. Home
15. What is the purpose of Conditional Formatting?
Correct answer: D. Insert formulas
16. MOS stands for:
Correct answer: D. Microsoft Office Specialist
17. In Word, Ctrl+B applies:
Correct answer: B. Bold formatting
18. In Word, Ctrl+I applies:
Correct answer: B. Italic formatting
19. In Word, Ctrl+U applies:
Correct answer: C. Underline
20. Ctrl+Z in Office apps:
Correct answer: B. Undoes the last action
21. Ctrl+Y in Office apps usually:
Correct answer: A. Redoes or repeats the last action
22. Ctrl+S is used to:
Correct answer: B. Save the file
23. F7 in Word starts:
Correct answer: C. Spelling and grammar check
24. F12 in Word opens:
Correct answer: B. Save As
25. Styles in Word help to:
Correct answer: A. Apply consistent formatting and build a table of contents
Questions 26 to 50
26. A table of contents in Word is generated from:
Correct answer: B. Heading styles
27. Section breaks in Word allow:
Correct answer: D. Different page layouts within one document
28. A page break forces text to:
Correct answer: C. Start on the next page
29. Headers and footers appear:
Correct answer: A. At the top and bottom of every page
30. Mail Merge in Word is used to:
Correct answer: B. Create personalised letters, labels or emails from a data source
31. Track Changes in Word lets users:
Correct answer: C. Record edits so they can be reviewed
32. Comments in Word are used to:
Correct answer: A. Add notes or feedback without changing the text
33. Footnotes appear:
Correct answer: B. At the bottom of the page
34. Endnotes appear:
Correct answer: D. At the end of a section or document
35. Find and Replace (Ctrl+H) is used to:
Correct answer: A. Search for text and replace it
36. A hanging indent indents:
Correct answer: C. All lines except the first
37. Line spacing controls:
Correct answer: D. Space between lines of text
38. Margins define:
Correct answer: A. The blank space around the page edges
39. Orientation can be set to:
Correct answer: A. Portrait or landscape
40. Watermarks in Word are used to:
Correct answer: D. Show faint text or images behind content, like DRAFT
41. In Excel, a cell reference like B3 refers to:
Correct answer: C. Column B, row 3
42. In Excel, formulas begin with:
Correct answer: D. An equals sign (=)
43. In Excel, SUM(A1:A5) returns:
Correct answer: A. The total of cells A1 to A5
44. In Excel, AVERAGE returns:
Correct answer: D. The arithmetic mean
45. In Excel, COUNTIF counts cells that:
Correct answer: B. Meet a condition
46. In Excel, the IF function:
Correct answer: C. Returns different values based on a condition
47. In Excel, $A$1 is:
Correct answer: D. An absolute reference
48. In Excel, VLOOKUP is used to:
Correct answer: A. Look up a value in the first column of a table
49. In Excel, XLOOKUP:
Correct answer: D. Searches a range and returns a matching item in any direction
50. A PivotTable in Excel is used to:
Correct answer: B. Summarise large data sets
Questions 51 to 75
51. Conditional formatting in Excel:
Correct answer: C. Formats cells based on rules
52. Freeze Panes in Excel keeps:
Correct answer: C. Rows or columns visible while scrolling
53. Data validation in Excel restricts:
Correct answer: C. What can be entered in cells
54. Sorting in Excel arranges data:
Correct answer: C. In ascending or descending order
55. Filtering in Excel:
Correct answer: C. Shows only rows that meet criteria
56. Flash Fill in Excel:
Correct answer: A. Fills data automatically based on a pattern
57. A chart in Excel visualises:
Correct answer: C. Data from a range
58. Sparklines are:
Correct answer: D. Small charts inside a single cell
59. The Name Box in Excel shows:
Correct answer: A. The active cell reference or named range
60. Wrap Text in Excel:
Correct answer: D. Displays long text on multiple lines in a cell
61. Merge and Center:
Correct answer: C. Combines cells and centres content
62. Print Titles in Excel repeat:
Correct answer: A. Selected rows or columns on every printed page
63. In PowerPoint, a slide layout defines:
Correct answer: D. The arrangement of placeholders on a slide
64. The Slide Master controls:
Correct answer: B. Consistent design and layout across all slides
65. Transitions in PowerPoint apply to:
Correct answer: D. The movement between slides
66. Animations in PowerPoint apply to:
Correct answer: B. Objects on a slide
67. Speaker notes are:
Correct answer: A. Notes visible to the presenter, not the audience
68. Presenter View shows:
Correct answer: A. Current slide, next slide and notes to the presenter
69. F5 in PowerPoint:
Correct answer: C. Starts the slideshow from the beginning
70. Shift+F5 in PowerPoint:
Correct answer: D. Starts the slideshow from the current slide
71. Ctrl+M in PowerPoint:
Correct answer: D. Inserts a new slide
72. SmartArt is used to:
Correct answer: D. Create visual diagrams such as processes and hierarchies
73. Hiding a slide means:
Correct answer: D. It is skipped during the slideshow but remains in the file
74. Slide Sorter view is used to:
Correct answer: B. Rearrange and organise slides
75. Morph transition creates:
Correct answer: A. Smooth movement of objects between slides
Questions 76 to 100
76. Rehearse Timings records:
Correct answer: B. How long each slide is shown
77. Exporting a presentation as video:
Correct answer: C. Creates a video file of the slides
78. Handouts in PowerPoint are:
Correct answer: C. Printed pages with multiple slides for the audience
79. In Outlook, a rule is used to:
Correct answer: D. Automatically handle incoming messages
80. In Outlook, CC means:
Correct answer: D. Carbon copy, visible recipients who receive a copy
81. In Outlook, BCC recipients are:
Correct answer: C. Hidden from other recipients
82. A meeting request in Outlook:
Correct answer: C. Invites attendees and tracks responses
83. Out of Office (Automatic Replies) in Outlook:
Correct answer: C. Sends automatic responses when you are away
84. Categories in Outlook help to:
Correct answer: B. Colour-code and organise items
85. Quick Steps in Outlook:
Correct answer: D. Apply multiple actions with one click
86. OneDrive integration allows:
Correct answer: C. Saving and sharing files in the cloud
87. Co-authoring lets multiple people:
Correct answer: A. Edit the same document at the same time
88. AutoSave in Microsoft 365 works when:
Correct answer: B. Files are stored on OneDrive or SharePoint
89. Inspect Document is used to:
Correct answer: D. Find and remove hidden data and personal information
90. Check Accessibility helps to:
Correct answer: B. Make content usable by people with disabilities
91. Alt text on images is used for:
Correct answer: D. Describing images for screen readers
92. Protect Document can:
Correct answer: A. Restrict editing or require a password
93. Saving as PDF is useful to:
Correct answer: D. Preserve layout for sharing and printing
94. The Quick Access Toolbar holds:
Correct answer: A. Frequently used commands
95. The Ribbon is organised into:
Correct answer: D. Tabs, groups and commands
96. Templates help users to:
Correct answer: C. Start documents with predefined design and content
97. Format Painter copies:
Correct answer: C. Formatting from one item to another
98. Ctrl+P in Office apps:
Correct answer: C. Opens print options
99. Ctrl+N in Office apps:
Correct answer: B. Creates a new file
100. The MOS certification validates:
Correct answer: C. Practical skills in Microsoft Office applications
How to Pass the Microsoft Office Specialist (MOS) Exam
- Read every question carefully; most options look similar, so look for the most precise answer.
- Revise the questions above topic by topic rather than memorising letters, because option order can change in the live test.
- You need 80 correct answers out of 100 to pass, so aim to understand at least 85 to stay safe.
- If you do not clear it on the first attempt, review the questions you missed and use the retake option.
Frequently Asked Questions
How many questions are in the Microsoft Office Specialist (MOS) Certification exam?
The exam has 100 multiple-choice questions, each worth 1 mark.
What is the passing score for the Microsoft Office Specialist (MOS) Certification?
You need at least 80% (80 out of 100) to pass and receive the certificate.
Can I retake the Microsoft Office Specialist (MOS) Certification exam?
Yes. If you score below 80%, you can retry the test after reviewing the topics.
Is the Itronix certificate verifiable?
Yes. Every certificate issued by Itronix Solutions has a unique ID that can be checked on the Itronix verify-certificate page.
More Office & Computer Basics Certification Answers
- Basics of Computer Certification Exam Answers
- Communication Skills Professional Certification Exam Answers
- Data entry Operator Certification Exam Answers
- Google Workspace Professional Certification Exam Answers
- Health and Nutrition Certification Exam Answers
- Interview Preparation Professional Certification Exam Answers
- Microsoft Advance Excel Certification Exam Answers
- Microsoft Excel VBA Certification Exam Answers
Disclaimer: These answers are provided for learning and revision. Questions and answers are checked regularly; if you find a mistake, let us know in the comments.
Priya Dogra – Free Certifications, Exam Answers & Career Guides Free certification exam answers, courses, scholarships and career guides for learners worldwide