MS Office Quiz – Test Your Knowledge!

Microsoft Office is one of the most widely used software suites for document creation, data analysis, presentations, and communication. Test your knowledge with this quiz!

Multiple Choice Questions (MCQs)

MS Word Questions

1. What is the default file extension of MS Word 2016?
a) .txt
b) .doc
c) .docx ✅
d) .word

2. Which feature in MS Word helps to check spelling and grammar?
a) AutoCorrect
b) Spell Check ✅
c) WordArt
d) Find & Replace

3. What is the shortcut key to save a document in MS Word?
a) Ctrl + S ✅
b) Ctrl + P
c) Ctrl + C
d) Ctrl + V

4. What does "Ctrl + B" do in MS Word?
a) Bold ✅
b) Underline
c) Italic
d) Copy

5. Which feature allows users to insert a preformatted text style in MS Word?
a) Font
b) Paragraph
c) Styles ✅
d) Header & Footer

MS Excel Questions

6. Which MS Office application is used for creating spreadsheets?
a) MS Word
b) MS PowerPoint
c) MS Excel ✅
d) MS Outlook

7. What symbol is used to begin a formula in MS Excel?
a) = ✅
b) @
c) #
d) &

8. What function is used to calculate the sum of a range of values in Excel?
a) =SUM() ✅
b) =ADD()
c) =TOTAL()
d) =COUNT()

9. Which feature in MS Excel allows users to combine multiple cells?
a) Merge & Center ✅
b) Wrap Text
c) AutoSum
d) Conditional Formatting

10. What is the shortcut key to open a new workbook in MS Excel?
a) Ctrl + N ✅
b) Ctrl + O
c) Ctrl + W
d) Ctrl + T

MS PowerPoint Questions

11. Which shortcut key starts a PowerPoint slideshow from the beginning?
a) F5 ✅
b) Ctrl + S
c) Shift + P
d) Alt + F4

12. Which view in MS PowerPoint is used for arranging slides in sequence?
a) Slide Show
b) Slide Sorter ✅
c) Outline
d) Notes

13. What is the purpose of "Transitions" in PowerPoint?
a) To create slide animations
b) To switch between slides smoothly ✅
c) To add text effects
d) To insert images

14. Which of the following is NOT a valid PowerPoint file extension?
a) .ppt
b) .pptx
c) .pdf ✅
d) .ppsx

15. What is the default slide orientation in PowerPoint?
a) Landscape ✅
b) Portrait
c) Square
d) Custom

MS Outlook & General MS Office Questions

16. Which MS Office tool is used for managing emails?
a) MS Word
b) MS Excel
c) MS PowerPoint
d) MS Outlook ✅

17. What is the purpose of "Mail Merge" in MS Word?
a) To send emails automatically
b) To create bulk letters with personalized details ✅
c) To add hyperlinks
d) To insert a table

18. What does "Ctrl + P" do in any MS Office application?
a) Prints the document ✅
b) Pastes the text
c) Opens a new file
d) Saves the file

19. Which feature in MS Office allows cloud-based document sharing?
a) OneDrive ✅
b) Outlook
c) SharePoint
d) Google Drive

20. What is the full form of VBA in MS Office?
a) Visual Basic for Applications ✅
b) Virtual Basic Analyzer
c) Visual Byte Algorithm
d) Verified Business Application