Microsoft Office – 50 MCQ Questions with Answers | ComputerGS

 

Welcome to ComputerGS (www.computergs.online) – Your trusted platform for SSC, Banking, Railway, UPSI, STENO & Computer Operator Exam Preparation.

This post contains 50 Difficult Level MCQs on Microsoft Office specially designed for high-level competitive exams like SSC CGL, IBPS PO, RBI, and State PCS.

Covered Applications:

• Microsoft Word

• Microsoft Excel

• Microsoft PowerPoint

• Microsoft Outlook

---

🔥 Microsoft Office – 50 Difficult MCQs

---

✅ 1–10 (Microsoft Word – Advanced)

1. Which feature in MS Word is used to create a standard letter format for multiple recipients?
A) Macro
B) Mail Merge
C) Track Changes
D) Format Painter
Answer: B

2. Which view is best for rearranging pages in Word?
A) Draft View
B) Outline View
C) Print Layout
D) Web Layout
Answer: B

3. Which shortcut opens the Navigation Pane?
A) Ctrl + F
B) Ctrl + N
C) Ctrl + Shift + F
D) Alt + F
Answer: A

4. What is the default file extension of Word 2019?
A) .doc
B) .docx
C) .dot
D) .rtf
Answer: B

5. Which feature records a sequence of commands?
A) Mail Merge
B) Macro
C) Styles
D) Bookmark
Answer: B

6. Which option protects document formatting?
A) Restrict Editing
B) Track Changes
C) Page Setup
D) Mailings
Answer: A

7. Which tab contains “SmartArt”?
A) Insert
B) Design
C) Review
D) Layout
Answer: A

8. Which feature shows edits by different users?
A) Compare
B) Track Changes
C) Comments
D) Inspect
Answer: B

9. Ctrl + Shift + > increases:
A) Line spacing
B) Font size
C) Margin
D) Zoom
Answer: B

10. A template file extension is:
A) .docx
B) .dotx
C) .rtf
D) .txt
Answer: B

---

✅ 11–25 (Microsoft Excel – Advanced)

11. Which function counts non-empty cells?
A) COUNT
B) COUNTA
C) COUNTIF
D) SUM
Answer: B

12. Which symbol is used for absolute reference?
A) #
B) @
C) $
D) &
Answer: C

13. Which function returns current date?
A) NOW()
B) TODAY()
C) DATE()
D) TIME()
Answer: B

14. VLOOKUP searches data in:
A) Horizontal form
B) Vertical form
C) Circular form
D) Random form
Answer: B

15. Which chart shows trends over time?
A) Pie Chart
B) Line Chart
C) Bar Chart
D) Area Chart
Answer: B

16. Pivot Table is used for:
A) Formatting
B) Data Analysis
C) Printing
D) Sorting only
Answer: B

17. Which function combines text?
A) CONCAT
B) SUM
C) LEN
D) MID
Answer: A

18. Shortcut to edit cell:
A) F1
B) F2
C) F4
D) F7
Answer: B

19. Conditional Formatting is under which tab?
A) Insert
B) Home
C) Data
D) View
Answer: B

20. Which operator is used for exponentiation?
A) ^
B) %
C) *
D) /
Answer: A

21. INDEX function returns:
A) Position
B) Value
C) Sum
D) Chart
Answer: B

22. IF function syntax starts with:
A) IF(logical_test, value_if_true, value_if_false)
B) IF(value)
C) IF(sum)
D) IF(text)
Answer: A

23. What is the intersection of row and column called?
A) Table
B) Range
C) Cell
D) Sheet
Answer: C

24. Excel file extension:
A) .xls
B) .xlsx
C) .xlt
D) .csv
Answer: B

25. Data validation is used to:
A) Format cells
B) Restrict input
C) Insert chart
D) Print sheet
Answer: B

---

✅ 26–35 (Microsoft PowerPoint – Advanced)

26. Which view is used to edit Slide Master?
A) Normal
B) Slide Show
C) Slide Master View
D) Outline
Answer: C

27. Shortcut to start slide show from beginning:
A) F1
B) F5
C) Shift + F5
D) Ctrl + F5
Answer: B

28. Transition is applied to:
A) Text
B) Slide
C) Chart
D) Image only
Answer: B

29. Animation is applied to:
A) Slide
B) Object
C) Page
D) Layout
Answer: B

30. Default extension:
A) .ppt
B) .pptx
C) .pps
D) .pdf
Answer: B

31. Which option hides a slide?
A) Slide Layout
B) Hide Slide
C) Custom Animation
D) Design
Answer: B

32. Rehearse Timing is used to:
A) Design slide
B) Set time for slide show
C) Insert video
D) Print slide
Answer: B

33. Which tab contains Themes?
A) Insert
B) Review
C) Design
D) Home
Answer: C

34. Ctrl + M inserts:
A) New Slide
B) Chart
C) Image
D) Textbox
Answer: A

35. Slide Sorter View is used to:
A) Print
B) Rearrange slides
C) Animate
D) Edit text
Answer: B

---

✅ 36–50 (Outlook & General MS Office)

36. Outlook is mainly used for:
A) Spreadsheet
B) Presentation
C) Email management
D) Programming
Answer: C

37. BCC stands for:
A) Blind Carbon Copy
B) Basic Copy
C) Binary Copy
D) Backup Copy
Answer: A

38. Which Office feature checks grammar?
A) Review Tab
B) Insert Tab
C) Layout Tab
D) Data Tab
Answer: A

39. Ctrl + K inserts:
A) Page break
B) Hyperlink
C) Comment
D) Header
Answer: B

40. Which Office tool creates database?
A) Word
B) Excel
C) Access
D) Outlook
Answer: C

41. Office suite developed by:
A) Google
B) IBM
C) Microsoft
D) Oracle
Answer: C

42. OneDrive is used for:
A) Printing
B) Cloud storage
C) Programming
D) Antivirus
Answer: B

43. Which file is macro-enabled?
A) .docx
B) .xlsx
C) .xlsm
D) .pptx
Answer: C

44. Track Changes available in:
A) Word
B) Excel
C) PowerPoint
D) All
Answer: A

45. Which feature prevents unauthorized access?
A) Password Protection
B) Mail Merge
C) Pivot Table
D) Animation
Answer: A

46. Which shortcut saves file?
A) Ctrl + S
B) Ctrl + P
C) Ctrl + O
D) Ctrl + H
Answer: A

47. Ctrl + P is used for:
A) Paste
B) Print
C) Preview
D) Protect
Answer: B

48. Which tool creates forms in Word?
A) Developer Tab
B) Insert
C) Review
D) Design
Answer: A

49. Which Excel function finds maximum value?
A) MAX()
B) MIN()
C) AVG()
D) SUM()
Answer: A

50. PowerPoint supports which multimedia?
A) Audio
B) Video
C) Animation
D) All
Answer: D

---

🎯 Conclusion

These 50 MCQs on Microsoft Office are highly useful for SSC CGL, IBPS PO, RBI, and other competitive exams.

Practice regularly from ComputerGS – www.computergs.online to score full marks in Computer Awareness section.

🔥 Very Important Topics: Must see

✅ Social Media Networking
✅ Cyber Crime and Security
✅ Open Education Resources (OER)
✅ E-commerce and Internet
✅ Important files extension names