📘 MS Office MCQs with Answers
- Best For students
- 1 Hrs
Prepare MS Office MCQs with detailed answers to strengthen your skills in Word, Excel, PowerPoint, and other Office tools. Perfect for scholarship exams, job interview tests, and competitive assessments.
1. Which key is used to save a document in MS Word?
- A) F1
B) Ctrl + S
C) Ctrl + P
D) Shift + S
Answer: B) Ctrl + S
2. In MS Excel, which symbol is used to start a formula?
A) =
B) +
C) –
D) *
Answer: A) =
3. Which tab in MS Word contains the option for Page Orientation?
A) Home
B) Layout
C) Insert
D) Review
Answer: B) Layout
4. Shortcut key for "Paste" in MS Office is:
A) Ctrl + V
B) Ctrl + C
C) Ctrl + X
D) Ctrl + P
Answer: A) Ctrl + V
5. Which file extension is used for MS PowerPoint presentations?
A) .docx
B) .xlsx
C) .pptx
D) .pdf
Answer: C) .pptx
6. In MS Excel, which function is used to calculate the average of numbers?
A) SUM
B) COUNT
C) AVG
D) AVERAGE
Answer: D) AVERAGE
7. In MS Word, the default font is:
A) Arial
B) Calibri
C) Times New Roman
D) Verdana
Answer: B) Calibri
8. Which shortcut is used to create a new slide in PowerPoint?
A) Ctrl + N
B) Ctrl + M
C) Ctrl + S
D) Ctrl + P
Answer: B) Ctrl + M
9. What is the maximum number of rows in Excel 2016?
A) 65,536
B) 1,048,576
C) 10,000
D) 999,999
Answer: B) 1,048,576.
10. Which view in PowerPoint shows all slides at once?
- A) Slide Sorter
B) Normal View
C) Outline View
D) Reading View
Answer: A) Slide Sorter
11. In MS Word, Ctrl + Z is used for:
A) Redo
B) Undo
C) Save
D) Copy
Answer: B) Undo
12. The default file extension of MS Excel 2010 and later is:
A) .xls
B) .xlsx
C) .docx
D) .csv
Answer: B) .xlsx
13. Which feature in Word is used to check grammar mistakes?
A) Find
B) Replace
C) Spelling & Grammar
D) Track Changes
Answer: C) Spelling & Grammar
14. In Excel, the intersection of a row and column is called:
A) Field
B) Cell
C) Box
D) Table
Answer: B) Cell
15. Which shortcut is used to print a document?
A) Ctrl + P
B) Ctrl + O
C) Ctrl + N
D) Ctrl + F
Answer: A) Ctrl + P
16. Which element of PowerPoint is used to add effects to objects?
A) Transition
B) Animation
C) Slide Show
D) Insert
Answer: B) Animation
17. In MS Word, which option is used to set page margins?
A) Insert → Margins
B) Layout → Margins
C) View → Margins
D) Review → Margins
Answer: B) Layout → Margins
18. MS Office is developed by:
A) Google
B) Microsoft
C) Apple
D) IBM
Answer: B) Microsoft
19. Which function in Excel adds numbers?
A) ADD()
B) SUM()
C) TOTAL()
D) COUNT()
Answer: B) SUM()
20. Which PowerPoint view is used to deliver a presentation?
A) Normal
B) Slide Sorter
C) Slide Show
D) Outline
Answer: C) Slide Show
21. Shortcut key to copy selected text in MS Word is:
A) Ctrl + V
B) Ctrl + C
C) Ctrl + X
D) Ctrl + S
Answer: B) Ctrl + C
22. In Excel, the IF function is used for:
A) Mathematical operations
B) Conditional checking
C) Formatting cells
D) Summing values
Answer: B) Conditional checking
23. Which menu in Word allows you to insert a table?
A) Home
B) Insert
C) Layout
D) Design
Answer: B) Insert
24. The shortcut to close MS Word is:
A) Ctrl + W
B) Ctrl + Q
C) Ctrl + X
D) Ctrl + C
Answer: A) Ctrl + W
25. In PowerPoint, "Transitions" are applied to:
A) Text only
B) Objects only
C) Whole Slide
D) Notes only
Answer: C) Whole Slide
26. What is the default extension of Word 2016 files?
A) .doc
B) .docx
C) .txt
D) .pdf
Answer: B) .docx
27. Which function is used to count numeric values in Excel?
A) COUNT
B) COUNTA
C) SUM
D) NUM
Answer: A) COUNT
28. In MS Word, which shortcut is used to open a new document?
A) Ctrl + O
B) Ctrl + N
C) Ctrl + S
D) Ctrl + W
Answer: B) Ctrl + N
29. In Excel, charts are created using:
A) Insert Tab
B) View Tab
C) Data Tab
D) Review Tab
Answer: A) Insert Tab
30. In PowerPoint, "Slide Master" is used to:
A) Create new slides
B) Set a design template
C) Insert animations
D) Delete slides
Answer: B) Set a design template
31. Shortcut for "Find" in Word is:
A) Ctrl + P
B) Ctrl + F
C) Ctrl + H
D) Ctrl + N
Answer: B) Ctrl + F
32. Excel allows data sorting in:
A) Ascending order only
B) Descending order only
C) Both Ascending and Descending
D) None
Answer: C) Both Ascending and Descending
33. PowerPoint shortcut to start slide show from the beginning:
A) F5
B) F2
C) F7
D) Ctrl + S
Answer: A) F5
34. Which feature in Word shows how the document will look when printed?
A) Print Preview
B) Outline
C) Draft
D) Page Layout
Answer: A) Print PreviewA: Yangtze River (China).
35. In Excel, which function returns the largest value?
A) MAX()
B) MIN()
C) LARGE()
D) BIG()
Answer: A) MAX()aikal, Russia.
36. In PowerPoint, to duplicate a slide quickly use:
A) Ctrl + C then Ctrl + V
B) Right-click → Duplicate Slide
C) Both A and B
D) None
Answer: C) Both A and B
37. In MS Word, shortcut key for "Bold" text is:
A) Ctrl + U
B) Ctrl + I
C) Ctrl + B
D) Ctrl + E
Answer: C) Ctrl + B
38. Excel allows filtering of data using:
A) View Tab
B) Data Tab
C) Home Tab
D) Insert Tab
Answer: B) Data Tab
39. In PowerPoint, which option is used to apply the same design to all slides?
A) Slide Layout
B) Slide Master
C) Transition
D) Animation
Answer: B) Slide Master
40. The default orientation of MS Word page is:
A) Landscape
B) Portrait
C) Horizontal
D) Vertical
Answer: B) Portrait
41. Shortcut for "Redo" in Word is:
A) Ctrl + Z
B) Ctrl + Y
C) Ctrl + R
D) Ctrl + U
Answer: B) Ctrl + Y
42. Which chart is best for showing percentages in Excel?
A) Line Chart
B) Pie Chart
C) Column Chart
D) Bar Chart
Answer: B) Pie Chart
43. Which tab contains the "SmartArt" option in PowerPoint?
A) Home
B) Insert
C) Design
D) View
Answer: B) Insert
44. MS Office was first released in:
A) 1985
B) 1989
C) 1990
D) 1995
Answer: C) 1990
45. In Word, to justify text use shortcut:
A) Ctrl + J
B) Ctrl + E
C) Ctrl + L
D) Ctrl + R
Answer: A) Ctrl + J
46. Which function in Excel gives the smallest value?
A) MAX()
B) MIN()
C) SMALL()
D) LOW()
Answer: B) MIN()
47. PowerPoint files can also be saved as:
A) Video
B) PDF
C) Image
D) All of the above
Answer: D) All of the above
48. In Word, which feature is used to combine mail with data?
A) Mail Merge
B) Track Changes
C) SmartArt
D) Hyperlink
Answer: A) Mail Merge
49. Which Excel function counts only non-empty cells?
A) COUNT
B) COUNTA
C) COUNTIF
D) SUM
Answer: B) COUNTA
50. In PowerPoint, which key ends a presentation?
A) Esc
B) F1
C) Tab
D) Delete
Answer: A) Esc
