Wednesday , November 18 2026
Breaking News

Microsoft Office Specialist (MOS) Certification Exam Answers 2026 (All 100 Questions)

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?

A. SUM
B. COUNTIF ✔
C. AVERAGEIF
D. VLOOKUP

Correct answer: B. COUNTIF

2. What does the AutoSum button do?

A. Finds the average
B. Adds selected cells ✔
C. Subtracts values
D. Sorts data

Correct answer: B. Adds selected cells

3. Which shortcut key inserts the current date in a cell?

A. Ctrl + D
B. Ctrl + ; ✔
C. Ctrl + :
D. Ctrl + Shift + T

Correct answer: B. Ctrl + ;

4. What does =IF(A1>10, "Yes", "No") return if A1 is 5?

A. 10
B. Yes
C. No ✔
D. A1

Correct answer: C. No

5. What is the use of Freeze Panes in Excel?

A. Locks entire workbook
B. Makes cell borders bold
C. Keeps header rows/columns visible while scrolling ✔
D. Creates a chart

Correct answer: C. Keeps header rows/columns visible while scrolling

6. Which chart is best for showing percentages?

A. Line chart
B. Bar chart
C. Pie chart ✔
D. Scatter chart

Correct answer: C. Pie chart

7. What does the function =VLOOKUP(101, A2:B10, 2, FALSE) do?

A. Looks for 101 in column A and returns value from column B ✔
B. Adds all numbers in range A2:B10
C. Filters column 2
D. Checks for duplicates

Correct answer: A. Looks for 101 in column A and returns value from column B

8. Which function calculates the average of selected values?

A. SUM
B. MEDIAN
C. AVERAGE ✔
D. COUNT

Correct answer: C. AVERAGE

9. The function =CONCAT(A1, B1) does what?

A. Adds A1 and B1
B. Returns the larger of A1 and B1
C. Combines text from A1 and B1 ✔
D. Converts values to upper case

Correct answer: C. Combines text from A1 and B1

10. What does the Wrap Text option do?

A. Hides overflow text
B. Merges text in multiple cells
C. Displays long text within the cell boundaries ✔
D. Inserts a line break

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…)?

A. Flash Fill
B. AutoFill ✔
C. Quick Fill
D. Format Painter

Correct answer: B. AutoFill

12. What is the default file extension for an Excel workbook?

A. xls
B. xlsx ✔
C. .xlsm
D. .csv

Correct answer: B. xlsx

13. Which formula finds the largest number in a range?

A. =MIN(A1:A10)
B. =COUNT(A1:A10)
C. =MAX(A1:A10) ✔
D. =SUM(A1:A10)

Correct answer: C. =MAX(A1:A10)

14. Which tab is used to apply borders in Excel?

A. Insert
B. Layout
C. Home ✔
D. View

Correct answer: C. Home

15. What is the purpose of Conditional Formatting?

A. Convert numbers to text
B. Format cells manually
C. Automatically format cells based on rules
D. Insert formulas ✔

Correct answer: D. Insert formulas

16. MOS stands for:

A. Managed Office Suite
B. Master Office Skills
C. Microsoft Operating System
D. Microsoft Office Specialist ✔

Correct answer: D. Microsoft Office Specialist

17. In Word, Ctrl+B applies:

A. Bookmarks
B. Bold formatting ✔
C. Bullets
D. Borders

Correct answer: B. Bold formatting

18. In Word, Ctrl+I applies:

A. Index
B. Italic formatting ✔
C. Insert mode
D. Indent

Correct answer: B. Italic formatting

19. In Word, Ctrl+U applies:

A. Undo
B. Update
C. Underline ✔
D. Uppercase

Correct answer: C. Underline

20. Ctrl+Z in Office apps:

A. Zooms in
B. Undoes the last action ✔
C. Saves the file
D. Redoes an action

Correct answer: B. Undoes the last action

21. Ctrl+Y in Office apps usually:

A. Redoes or repeats the last action ✔
B. Opens help
C. Closes the file
D. Undoes

Correct answer: A. Redoes or repeats the last action

22. Ctrl+S is used to:

A. Spell check
B. Save the file ✔
C. Search
D. Select all

Correct answer: B. Save the file

23. F7 in Word starts:

A. Find
B. Print preview
C. Spelling and grammar check ✔
D. Save As

Correct answer: C. Spelling and grammar check

24. F12 in Word opens:

A. Print
B. Save As ✔
C. Thesaurus
D. Help

Correct answer: B. Save As

25. Styles in Word help to:

A. Apply consistent formatting and build a table of contents ✔
B. Encrypt documents
C. Translate text
D. Insert charts only

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:

A. Bookmarks only
B. Heading styles ✔
C. Comments
D. Footnotes

Correct answer: B. Heading styles

27. Section breaks in Word allow:

A. Track changes
B. Spell check
C. Merging documents
D. Different page layouts within one document ✔

Correct answer: D. Different page layouts within one document

28. A page break forces text to:

A. Disappear
B. Move to a new column
C. Start on the next page ✔
D. Become bold

Correct answer: C. Start on the next page

29. Headers and footers appear:

A. At the top and bottom of every page ✔
B. Only in tables
C. In the middle of pages
D. Only on the first page always

Correct answer: A. At the top and bottom of every page

30. Mail Merge in Word is used to:

A. Compress images
B. Create personalised letters, labels or emails from a data source ✔
C. Merge two Word files
D. Combine cells

Correct answer: B. Create personalised letters, labels or emails from a data source

31. Track Changes in Word lets users:

A. Lock the document
B. Delete comments
C. Record edits so they can be reviewed ✔
D. Hide all changes permanently

Correct answer: C. Record edits so they can be reviewed

32. Comments in Word are used to:

A. Add notes or feedback without changing the text ✔
B. Insert tables
C. Print the document
D. Format headings

Correct answer: A. Add notes or feedback without changing the text

33. Footnotes appear:

A. In the header
B. At the bottom of the page ✔
C. At the end of the document only
D. In a comment

Correct answer: B. At the bottom of the page

34. Endnotes appear:

A. In the margin
B. At the bottom of each page
C. In the title
D. At the end of a section or document ✔

Correct answer: D. At the end of a section or document

35. Find and Replace (Ctrl+H) is used to:

A. Search for text and replace it ✔
B. Highlight text
C. Insert hyperlinks
D. Hide text

Correct answer: A. Search for text and replace it

36. A hanging indent indents:

A. No lines
B. Only the last line
C. All lines except the first ✔
D. Only the first line

Correct answer: C. All lines except the first

37. Line spacing controls:

A. Page margins
B. Column width
C. Space between words
D. Space between lines of text ✔

Correct answer: D. Space between lines of text

38. Margins define:

A. The blank space around the page edges ✔
B. Header text
C. Line spacing
D. Font size

Correct answer: A. The blank space around the page edges

39. Orientation can be set to:

A. Portrait or landscape ✔
B. Single or double
C. Top or bottom
D. Left or right

Correct answer: A. Portrait or landscape

40. Watermarks in Word are used to:

A. Encrypt files
B. Track changes
C. Insert footnotes
D. Show faint text or images behind content, like DRAFT ✔

Correct answer: D. Show faint text or images behind content, like DRAFT

41. In Excel, a cell reference like B3 refers to:

A. Book B, chart 3
B. Row B, column 3
C. Column B, row 3 ✔
D. Sheet B, page 3

Correct answer: C. Column B, row 3

42. In Excel, formulas begin with:

A. A dollar sign
B. A plus sign only
C. A hash (#)
D. An equals sign (=) ✔

Correct answer: D. An equals sign (=)

43. In Excel, SUM(A1:A5) returns:

A. The total of cells A1 to A5 ✔
B. The average
C. The largest value
D. The count

Correct answer: A. The total of cells A1 to A5

44. In Excel, AVERAGE returns:

A. The mode
B. The median
C. The total
D. The arithmetic mean ✔

Correct answer: D. The arithmetic mean

45. In Excel, COUNTIF counts cells that:

A. Contain formulas only
B. Meet a condition ✔
C. Are blank only
D. Are bold

Correct answer: B. Meet a condition

46. In Excel, the IF function:

A. Sums values
B. Sorts data
C. Returns different values based on a condition ✔
D. Creates charts

Correct answer: C. Returns different values based on a condition

47. In Excel, $A$1 is:

A. A relative reference
B. A range name
C. A mixed reference
D. An absolute reference ✔

Correct answer: D. An absolute reference

48. In Excel, VLOOKUP is used to:

A. Look up a value in the first column of a table ✔
B. Format cells
C. Sort data
D. Protect sheets

Correct answer: A. Look up a value in the first column of a table

49. In Excel, XLOOKUP:

A. Deletes duplicates
B. Only searches right
C. Creates PivotTables
D. Searches a range and returns a matching item in any direction ✔

Correct answer: D. Searches a range and returns a matching item in any direction

50. A PivotTable in Excel is used to:

A. Write macros
B. Summarise large data sets ✔
C. Draw shapes
D. Insert pictures

Correct answer: B. Summarise large data sets

Questions 51 to 75

51. Conditional formatting in Excel:

A. Protects sheets
B. Merges cells
C. Formats cells based on rules ✔
D. Adds comments

Correct answer: C. Formats cells based on rules

52. Freeze Panes in Excel keeps:

A. Files closed
B. Formulas locked
C. Rows or columns visible while scrolling ✔
D. Charts static

Correct answer: C. Rows or columns visible while scrolling

53. Data validation in Excel restricts:

A. Fonts
B. Print area
C. What can be entered in cells ✔
D. Chart types

Correct answer: C. What can be entered in cells

54. Sorting in Excel arranges data:

A. Into charts
B. Into comments
C. In ascending or descending order ✔
D. Into macros

Correct answer: C. In ascending or descending order

55. Filtering in Excel:

A. Encrypts rows
B. Merges rows
C. Shows only rows that meet criteria ✔
D. Deletes rows

Correct answer: C. Shows only rows that meet criteria

56. Flash Fill in Excel:

A. Fills data automatically based on a pattern ✔
B. Protects cells
C. Prints sheets
D. Inserts charts

Correct answer: A. Fills data automatically based on a pattern

57. A chart in Excel visualises:

A. Only text
B. Only images
C. Data from a range ✔
D. Comments

Correct answer: C. Data from a range

58. Sparklines are:

A. Animations
B. Macros
C. Borders
D. Small charts inside a single cell ✔

Correct answer: D. Small charts inside a single cell

59. The Name Box in Excel shows:

A. The active cell reference or named range ✔
B. The sheet colour
C. The file name
D. The printer

Correct answer: A. The active cell reference or named range

60. Wrap Text in Excel:

A. Merges files
B. Rotates the sheet
C. Deletes text
D. Displays long text on multiple lines in a cell ✔

Correct answer: D. Displays long text on multiple lines in a cell

61. Merge and Center:

A. Deletes cells
B. Splits cells
C. Combines cells and centres content ✔
D. Sorts cells

Correct answer: C. Combines cells and centres content

62. Print Titles in Excel repeat:

A. Selected rows or columns on every printed page ✔
B. Comments
C. Charts
D. Macros

Correct answer: A. Selected rows or columns on every printed page

63. In PowerPoint, a slide layout defines:

A. The file size
B. The audio volume
C. The presenter’s notes
D. The arrangement of placeholders on a slide ✔

Correct answer: D. The arrangement of placeholders on a slide

64. The Slide Master controls:

A. Speaker notes only
B. Consistent design and layout across all slides ✔
C. Only one slide
D. Animations only

Correct answer: B. Consistent design and layout across all slides

65. Transitions in PowerPoint apply to:

A. Objects on a slide
B. Text spacing
C. Charts only
D. The movement between slides ✔

Correct answer: D. The movement between slides

66. Animations in PowerPoint apply to:

A. Moving between slides
B. Objects on a slide ✔
C. File saving
D. Slide size

Correct answer: B. Objects on a slide

67. Speaker notes are:

A. Notes visible to the presenter, not the audience ✔
B. Text on the slide
C. Hidden slides
D. Footers

Correct answer: A. Notes visible to the presenter, not the audience

68. Presenter View shows:

A. Current slide, next slide and notes to the presenter ✔
B. Only thumbnails
C. The file menu
D. Only the audience view

Correct answer: A. Current slide, next slide and notes to the presenter

69. F5 in PowerPoint:

A. Opens Find
B. Inserts a slide
C. Starts the slideshow from the beginning ✔
D. Saves the file

Correct answer: C. Starts the slideshow from the beginning

70. Shift+F5 in PowerPoint:

A. Ends the show
B. Duplicates a slide
C. Deletes a slide
D. Starts the slideshow from the current slide ✔

Correct answer: D. Starts the slideshow from the current slide

71. Ctrl+M in PowerPoint:

A. Mutes audio
B. Merges shapes
C. Moves text
D. Inserts a new slide ✔

Correct answer: D. Inserts a new slide

72. SmartArt is used to:

A. Record audio
B. Edit photos
C. Write macros
D. Create visual diagrams such as processes and hierarchies ✔

Correct answer: D. Create visual diagrams such as processes and hierarchies

73. Hiding a slide means:

A. It is deleted
B. It is locked
C. It is printed only
D. It is skipped during the slideshow but remains in the file ✔

Correct answer: D. It is skipped during the slideshow but remains in the file

74. Slide Sorter view is used to:

A. Record narration
B. Rearrange and organise slides ✔
C. Edit text on one slide
D. Write notes

Correct answer: B. Rearrange and organise slides

75. Morph transition creates:

A. Smooth movement of objects between slides ✔
B. Hyperlinks
C. Sound only
D. Random effects

Correct answer: A. Smooth movement of objects between slides

Questions 76 to 100

76. Rehearse Timings records:

A. File size
B. How long each slide is shown ✔
C. Comments
D. Audio only

Correct answer: B. How long each slide is shown

77. Exporting a presentation as video:

A. Locks the file
B. Prints handouts
C. Creates a video file of the slides ✔
D. Deletes animations

Correct answer: C. Creates a video file of the slides

78. Handouts in PowerPoint are:

A. Transitions
B. Animations
C. Printed pages with multiple slides for the audience ✔
D. Speaker notes only

Correct answer: C. Printed pages with multiple slides for the audience

79. In Outlook, a rule is used to:

A. Create charts
B. Edit photos
C. Write documents
D. Automatically handle incoming messages ✔

Correct answer: D. Automatically handle incoming messages

80. In Outlook, CC means:

A. The sender
B. Hidden recipients
C. The subject
D. Carbon copy, visible recipients who receive a copy ✔

Correct answer: D. Carbon copy, visible recipients who receive a copy

81. In Outlook, BCC recipients are:

A. The sender only
B. Ignored
C. Hidden from other recipients ✔
D. Visible to all

Correct answer: C. Hidden from other recipients

82. A meeting request in Outlook:

A. Sends a file only
B. Creates a task only
C. Invites attendees and tracks responses ✔
D. Deletes an event

Correct answer: C. Invites attendees and tracks responses

83. Out of Office (Automatic Replies) in Outlook:

A. Blocks senders
B. Archives mail
C. Sends automatic responses when you are away ✔
D. Deletes mail

Correct answer: C. Sends automatic responses when you are away

84. Categories in Outlook help to:

A. Translate mail
B. Colour-code and organise items ✔
C. Encrypt mail
D. Print mail

Correct answer: B. Colour-code and organise items

85. Quick Steps in Outlook:

A. Create slides
B. Write formulas
C. Edit images
D. Apply multiple actions with one click ✔

Correct answer: D. Apply multiple actions with one click

86. OneDrive integration allows:

A. Offline only
B. Printing only
C. Saving and sharing files in the cloud ✔
D. Only local saving

Correct answer: C. Saving and sharing files in the cloud

87. Co-authoring lets multiple people:

A. Edit the same document at the same time ✔
B. Only print
C. Only comment offline
D. Only view files

Correct answer: A. Edit the same document at the same time

88. AutoSave in Microsoft 365 works when:

A. Files are emailed
B. Files are stored on OneDrive or SharePoint ✔
C. Files are printed
D. Files are zipped

Correct answer: B. Files are stored on OneDrive or SharePoint

89. Inspect Document is used to:

A. Add watermarks
B. Check spelling
C. Print copies
D. Find and remove hidden data and personal information ✔

Correct answer: D. Find and remove hidden data and personal information

90. Check Accessibility helps to:

A. Add animations
B. Make content usable by people with disabilities ✔
C. Speed up files
D. Encrypt documents

Correct answer: B. Make content usable by people with disabilities

91. Alt text on images is used for:

A. Changing image colour
B. Cropping images
C. Compressing images
D. Describing images for screen readers ✔

Correct answer: D. Describing images for screen readers

92. Protect Document can:

A. Restrict editing or require a password ✔
B. Translate text
C. Print automatically
D. Delete content

Correct answer: A. Restrict editing or require a password

93. Saving as PDF is useful to:

A. Track changes
B. Add animations
C. Edit formulas easily
D. Preserve layout for sharing and printing ✔

Correct answer: D. Preserve layout for sharing and printing

94. The Quick Access Toolbar holds:

A. Frequently used commands ✔
B. All files
C. Fonts only
D. Templates only

Correct answer: A. Frequently used commands

95. The Ribbon is organised into:

A. Rows and columns
B. Files and folders
C. Pages and sections
D. Tabs, groups and commands ✔

Correct answer: D. Tabs, groups and commands

96. Templates help users to:

A. Delete files
B. Encrypt data
C. Start documents with predefined design and content ✔
D. Compress images

Correct answer: C. Start documents with predefined design and content

97. Format Painter copies:

A. Files
B. Text content
C. Formatting from one item to another ✔
D. Comments

Correct answer: C. Formatting from one item to another

98. Ctrl+P in Office apps:

A. Protects the file
B. Opens a new file
C. Opens print options ✔
D. Pastes

Correct answer: C. Opens print options

99. Ctrl+N in Office apps:

A. Opens notes
B. Creates a new file ✔
C. Inserts a number
D. Changes font

Correct answer: B. Creates a new file

100. The MOS certification validates:

A. Programming skills
B. Network administration
C. Practical skills in Microsoft Office applications ✔
D. Hardware repair

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

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.

About Priya Dogra

Priya Dogra runs priyadogra.com, where she shares free certification courses, internships, jobs, scholarships and exam preparation guides for Indian students and freshers. Follow her on YouTube, LinkedIn and Instagram for the latest opportunities.

Check Also

Unix/ Linux Certification exam answers 2026

Unix/ Linux Certification Exam Answers 2026 (All 100 Questions)

All 100 Unix/ Linux Certification exam questions with correct answers highlighted - updated 2026.

Leave a Reply

Your email address will not be published. Required fields are marked *