📘 100 MS Office MCQs with Answers
1. MS Word
is mainly used for:
(A) Calculations
(B) Presentations
(C) Word Processing
(D) Databases
✅ Right Answer: (C) Word Processing
2. The
default extension of MS Word 2016 file is:
(A) .xls
(B) .pptx
(C) .docx
(D) .txt
✅ Right Answer: (C) .docx
3. The
default extension of MS Excel 2016 file is:
(A) .xlsx
(B) .docx
(C) .pptx
(D) .xlsm
✅ Right Answer: (A) .xlsx
4. The
default extension of MS PowerPoint 2016 file is:
(A) .ppt
(B) .pptx
(C) .docx
(D) .txt
✅ Right Answer: (B) .pptx
5. The
default extension of MS Access 2016 database file is:
(A) .mdb
(B) .accdb
(C) .dbf
(D) .sql
✅ Right Answer: (B)
.accdb
6. Which
shortcut is used to copy in MS Word?
(A) Ctrl + V
(B) Ctrl + C
(C) Ctrl + X
(D) Ctrl + Z
✅ Right Answer: (B) Ctrl + C
7. Which
shortcut is used to paste in MS Word?
(A) Ctrl + C
(B) Ctrl + P
(C) Ctrl + V
(D) Ctrl + X
✅ Right Answer: (C) Ctrl + V
8. Which
shortcut is used to cut in MS Word?
(A) Ctrl + Z
(B) Ctrl + C
(C) Ctrl + V
(D) Ctrl + X
✅ Right Answer: (D) Ctrl + X
9. Which
shortcut is used to undo an action?
(A) Ctrl + V
(B) Ctrl + Z
(C) Ctrl + Y
(D) Ctrl + A
✅ Right Answer: (B) Ctrl + Z
10. Which
shortcut is used to redo an action?
(A) Ctrl + R
(B) Ctrl + Y
(C) Ctrl + U
(D) Ctrl + Z
✅ Right Answer: (B) Ctrl + Y
11. Shortcut
for "Save As" dialog box in Word is:
(A) F12
(B) Shift + S
(C) Ctrl + S
(D) Alt + S
✅ Right Answer: (A) F12
12. Shortcut
for Print in MS Word:
(A) Ctrl + O
(B) Ctrl + P
(C) Ctrl + L
(D) Ctrl + N
✅ Right Answer: (B) Ctrl + P
13. Shortcut
for New Document in MS Word:
(A) Ctrl + D
(B) Ctrl + O
(C) Ctrl + N
(D) Ctrl + T
✅ Right Answer: (C) Ctrl + N
14. Shortcut
for Open Document in MS Word:
(A) Ctrl + O
(B) Ctrl + U
(C) Ctrl + L
(D) Ctrl + E
✅ Right Answer: (A) Ctrl + O
15. Shortcut
to Select All text:
(A) Ctrl + V
(B) Ctrl + A
(C) Ctrl + T
(D) Ctrl + E
✅ Right Answer: (B) Ctrl + A
16. Shortcut
to Bold text:
(A) Ctrl + U
(B) Ctrl + B
(C) Ctrl + I
(D) Ctrl + E
✅ Right Answer: (B) Ctrl + B
17. Shortcut
to Italic text:
(A) Ctrl + B
(B) Ctrl + U
(C) Ctrl + I
(D) Ctrl + L
✅ Right Answer: (C) Ctrl + I
18. Shortcut
to Underline text:
(A) Ctrl + B
(B) Ctrl + U
(C) Ctrl + I
(D) Ctrl + O
✅ Right Answer: (B) Ctrl + U
19. Shortcut
to Align text center:
(A) Ctrl + C
(B) Ctrl + L
(C) Ctrl + E
(D) Ctrl + R
✅ Right Answer: (C) Ctrl + E
20. Shortcut
to Align text left:
(A) Ctrl + R
(B) Ctrl + L
(C) Ctrl + C
(D) Ctrl + E
✅ Right Answer: (B) Ctrl + L
21. Shortcut
to Align text right:
(A) Ctrl + E
(B) Ctrl + L
(C) Ctrl + R
(D) Ctrl + J
✅ Right Answer: (C) Ctrl + R
22. Shortcut
to Justify text:
(A) Ctrl + J
(B) Ctrl + G
(C) Ctrl + H
(D) Ctrl + F
✅ Right Answer: (A) Ctrl + J
23. In
Excel, function for Sum is:
(A) =ADD()
(B) =TOTAL()
(C) =SUM()
(D) =PLUS()
✅ Right Answer: (C) =SUM()
24. In
Excel, function for Average is:
(A) =AVG()
(B) =AVERAGE()
(C) =MEAN()
(D) =SUM()/N
✅ Right Answer: (B) =AVERAGE()
25. In
Excel, function for Maximum value:
(A) =MAX()
(B) =LARGE()
(C) =MAXIMUM()
(D) =BIG()
✅ Right Answer: (A) =MAX()
26. In
Excel, function for Minimum value:
(A) =MIN()
(B) =SMALL()
(C) =LOW()
(D) =MINIMUM()
✅ Right Answer: (A) =MIN()
27. In
Excel, function to count numbers:
(A) =COUNT()
(B) =COUNTA()
(C) =NUMBER()
(D) =LEN()
✅ Right Answer: (A) =COUNT()
28. In
Excel, function to count text and numbers:
(A) =COUNT()
(B) =LEN()
(C) =COUNTA()
(D) =SUM()
✅ Right Answer: (C) =COUNTA()
29. In
Excel, CONCATENATE function is used for:
(A) Calculations
(B) Joining text
(C) Finding errors
(D) Formatting
✅ Right Answer: (B) Joining text
30. Which
chart is not in Excel?
(A) Line
(B) Bar
(C) Pie
(D) Circle Graph
✅ Right Answer: (D) Circle Graph
31. Which
key is used to edit a cell in Excel?
(A) Enter
(B) F2
(C) F4
(D) Esc
✅ Right Answer: (B) F2
32. Which
key is used to start slideshow in PowerPoint?
(A) F2
(B) F5
(C) F7
(D) F8
✅ Right Answer: (B) F5
33. In
PowerPoint, shortcut to create New Slide:
(A) Ctrl + N
(B) Ctrl + M
(C) Ctrl + O
(D) Ctrl + S
✅ Right Answer: (B) Ctrl + M
34. In
PowerPoint, shortcut for Slide Show from current slide:
(A) Shift + F5
(B) F5
(C) Alt + F5
(D) Ctrl + F5
✅ Right Answer: (A) Shift + F5
35. In
PowerPoint, animation is applied to:
(A) Only text
(B) Only images
(C) Text, images, objects
(D) Only charts
✅ Right Answer: (C) Text, images, objects
36. In MS
Access, a row is called:
(A) Field
(B) Column
(C) Record
(D) Data type
✅ Right Answer: (C) Record
37. In MS
Access, a column is called:
(A) Row
(B) Field
(C) Record
(D) Table
✅ Right Answer: (B) Field
38. In MS
Access, Primary Key is used to:
(A) Identify a table
(B) Identify a record uniquely
(C) Encrypt data
(D) Join tables
✅ Right Answer: (B) Identify a record uniquely
39. Which
object in Access is used to ask questions from database?
(A) Table
(B) Form
(C) Query
(D) Report
✅ Right Answer: (C) Query
40. Which
object in Access is used to print formatted data?
(A) Query
(B) Report
(C) Form
(D) Table
✅ Right Answer: (B) Report
41. Outlook
is mainly used for:
(A) Word Processing
(B) Emails
(C) Presentations
(D) Graphics
✅ Right Answer: (B) Emails
42. Shortcut
for Send Email in Outlook:
(A) Ctrl + Enter
(B) Ctrl + S
(C) Ctrl + M
(D) Alt + S
✅ Right Answer: (A) Ctrl + Enter
43. Which is
not a part of MS Office suite?
(A) Word
(B) Excel
(C) Photoshop
(D) PowerPoint
✅ Right Answer: (C) Photoshop
44. In
Excel, formula always starts with:
(A) =
(B) +
(C) -
(D) \
✅ Right Answer: (A) =
45. In
Excel, cell reference A1 is:
(A) Relative
(B) Absolute
(C) Mixed
(D) Constant
✅ Right Answer: (A) Relative
46. Absolute
reference in Excel is written as:
(A) A1
(B) \$A\$1
(C) A\$1
(D) \$A1
✅ Right Answer: (B) \$A\$1
47. In
Excel, to freeze row and column we use:
(A) Freeze Panes
(B) Lock Sheet
(C) Hold Cell
(D) Protect Sheet
✅ Right Answer: (A) Freeze Panes
48. In Word,
the smallest unit of a document is:
(A) Word
(B) Character
(C) Paragraph
(D) Page
✅ Right Answer: (B) Character
49. In Word,
to insert page number we use:
(A) Footer/Header
(B) Table
(C) Format
(D) Layout
✅ Right Answer: (A) Footer/Header
50. The
default font in MS Word 2016 is:
(A) Calibri
(B) Times New Roman
(C) Arial
(D) Verdana
✅ Right Answer: (A) Calibri
51. In MS
Word, which feature is used to check spelling?
(A) Find & Replace
(B) Thesaurus
(C) Spelling & Grammar
(D) Translate
✅ Right Answer: (C) Spelling & Grammar
52. In MS
Word, shortcut for Find is:
(A) Ctrl + H
(B) Ctrl + F
(C) Ctrl + A
(D) Ctrl + L
✅ Right Answer: (B) Ctrl + F
53. In MS
Word, shortcut for Replace is:
(A) Ctrl + F
(B) Ctrl + H
(C) Ctrl + E
(D) Ctrl + R
✅ Right Answer: (B) Ctrl + H
54. In Word,
inserting footnote is possible from:
(A) Insert Tab
(B) References Tab
(C) View Tab
(D) Review Tab
✅ Right Answer: (B) References Tab
55. In Word,
table is inserted using:
(A) Layout → Insert
(B) Insert → Table
(C) View → Table
(D) Format → Table
✅ Right Answer: (B) Insert → Table
56. In
Excel, IF function is used for:
(A) Formatting
(B) Logical Test
(C) Summation
(D) Text Joining
✅ Right Answer: (B) Logical Test
57. Formula
=IF(A1>50,"Pass","Fail") will return “Pass” if:
(A) A1 < 50
(B) A1 = 50
(C) A1 > 50
(D) A1 blank
✅ Right Answer: (C) A1 > 50
58. In
Excel, shortcut for creating chart quickly is:
(A) F2
(B) F4
(C) F11
(D) F12
✅ Right Answer: (C) F11
59. Which
chart is best for showing percentages?
(A) Bar Chart
(B) Line Chart
(C) Pie Chart
(D) Area Chart
✅ Right Answer: (C) Pie Chart
60. In
Excel, shortcut for AutoSum is:
(A) Alt + =
(B) Ctrl + S
(C) Ctrl + Shift + A
(D) Shift + =
✅ Right Answer: (A) Alt + =
61. In
Excel, VLOOKUP is used for:
(A) Vertical lookup
(B) Horizontal lookup
(C) Sorting
(D) Filtering
✅ Right Answer: (A) Vertical lookup
62. In
Excel, HLOOKUP is used for:
(A) Vertical lookup
(B) Horizontal lookup
(C) Date check
(D) Summation
✅ Right Answer: (B) Horizontal lookup
63. Which
function counts blank cells in Excel?
(A) COUNT
(B) COUNTA
(C) COUNTBLANK
(D) ISBLANK
✅ Right Answer: (C) COUNTBLANK
64. In
Excel, which symbol is used for absolute reference?
(A) @
(B) \$
(C)
(D) %
✅ Right Answer: (B) \$
65. In
PowerPoint, Slide Master is used for:
(A) Background formatting
(B) Animations
(C) Hyperlinks
(D) Printing
✅ Right Answer: (A) Background formatting
66. In
PowerPoint, transition is applied to:
(A) Text only
(B) Images only
(C) Slides
(D) Charts
✅ Right Answer: (C) Slides
67. In
PowerPoint, animation is applied to:
(A) Slide
(B) Objects
(C) Page setup
(D) Notes
✅ Right Answer: (B) Objects
68. Shortcut
to duplicate a slide in PowerPoint is:
(A) Ctrl + C, Ctrl + V
(B) Ctrl + D
(C) Ctrl + N
(D) Ctrl + M
✅ Right Answer: (B) Ctrl + D
69.
PowerPoint file can be exported as:
(A) PDF
(B) Video
(C) Image
(D) All of these
✅ Right Answer: (D) All of these
70. In MS
Access, which view is used to design a table?
(A) Datasheet View
(B) Design View
(C) Query View
(D) Layout View
✅ Right Answer: (B) Design View
71. In
Access, which field type stores Yes/No values?
(A) Text
(B) Boolean
(C) Number
(D) AutoNumber
✅ Right Answer: (B) Boolean
72. In
Access, relationship is created between:
(A) Tables
(B) Queries
(C) Reports
(D) Forms
✅ Right Answer: (A) Tables
73. In
Access, default key field is:
(A) Primary Key
(B) Foreign Key
(C) Composite Key
(D)
Alternate Key
✅ Right Answer: (A) Primary Key
74. In
Access, Form is mainly used for:
(A) Entering data
(B) Printing data
(C) Designing database
(D) Querying data
✅ Right Answer: (A) Entering data
75. In
Outlook, Calendar is used for:
(A) Sending mail
(B) Scheduling meetings
(C) Managing tasks
(D) Drafting documents
✅ Right Answer: (B) Scheduling meetings
76. In
Outlook, shortcut to create new email:
(A) Ctrl + N
(B) Ctrl + M
(C) Ctrl + Shift + M
(D) Alt + N
✅ Right Answer: (C) Ctrl + Shift + M
77. In
Outlook, which protocol is used for receiving mail?
(A) SMTP
(B) POP/IMAP
(C) HTTP
(D) SNMP
✅ Right Answer: (B) POP/IMAP
78. In
Outlook, which protocol is used for sending mail?
(A) POP3
(B) SMTP
(C) IMAP
(D) FTP
✅ Right Answer: (B) SMTP
79. In Word,
Track Changes feature is under:
(A) View Tab
(B) Insert Tab
(C) Review Tab
(D) Layout Tab
✅ Right Answer: (C) Review Tab
80. In Word,
default page orientation is:
(A) Landscape
(B) Portrait
(C) Square
(D) A4
✅ Right Answer: (B) Portrait
81. In Word,
watermark option is available in:
(A) Insert Tab
(B) Layout Tab
(C) Design Tab
(D) Review Tab
✅ Right Answer: (C)
Design Tab
82. In Word,
shortcut for double spacing is:
(A) Ctrl + 1
(B) Ctrl + 2
(C) Ctrl + 5
(D) Ctrl + D
✅ Right Answer: (B) Ctrl + 2
83. In Word,
shortcut for single spacing is:
(A) Ctrl + 1
(B) Ctrl + 2
(C) Ctrl + 5
(D) Ctrl + S
✅ Right Answer: (A) Ctrl + 1
84. In
Excel, pivot table is used for:
(A) Data summarization
(B) Data entry
(C) Data cleaning
(D) Data import
✅ Right Answer: (A) Data summarization
85. In
Excel, Conditional Formatting is used for:
(A) Formatting cells automatically
(B) Inserting rows
(C) Merging cells
(D) Deleting rows
✅ Right Answer: (A) Formatting cells
automatically
86. In
Excel, shortcut for Insert new sheet:
(A) Shift + F11
(B) Ctrl + F11
(C) Alt + F11
(D) Ctrl + N
✅ Right Answer: (A) Shift + F11
87. In
Excel, shortcut for Insert function dialog box:
(A) Shift + F3
(B) F2
(C) F4
(D) Alt + F3
✅ Right Answer: (A) Shift + F3
88. In
Excel, shortcut for Insert current date:
(A) Ctrl + D
(B) Ctrl + ;
(C) Ctrl + Shift + :
(D) Ctrl + T
✅ Right Answer: (B) Ctrl + ;
89. In
Excel, shortcut for Insert current time:
(A) Ctrl + D
(B) Ctrl + ;
(C) Ctrl + Shift + :
(D) Ctrl + T
✅ Right Answer: (C) Ctrl + Shift + :
90. In
Excel, shortcut for Rename sheet:
(A) Double click sheet tab
(B) Right click → Rename
(C) Alt + H + O + R
(D) All of these
✅ Right Answer: (D) All of these
91. In Word,
mail merge is used for:
(A) Combining letters with database
(B) Formatting paragraphs
(C) Inserting images
(D) Reviewing text
✅ Right Answer: (A) Combining letters with database
92. In Word,
default view is:
(A) Draft
(B) Print Layout
(C) Web Layout
(D) Outline
✅ Right Answer: (B) Print Layout
93. In Word,
Header and Footer are found in:
(A) Insert Tab
(B) Layout Tab
(C) View Tab
(D) Design Tab
✅ Right Answer: (A) Insert Tab
94. In Word,
Thesaurus is used for:
(A) Spell check
(B) Grammar check
(C) Synonyms & Antonyms
(D) Translate
✅ Right Answer: (C) Synonyms & Antonyms
95. In
Excel, shortcut to open format cell dialog:
(A) Ctrl + 1
(B) Ctrl + 2
(C) Ctrl + 3
(D) Ctrl + 4
✅ Right Answer: (A) Ctrl + 1
96. In
Excel, shortcut for Find is:
(A) Ctrl + H
(B) Ctrl + F
(C) Ctrl + R
(D) Ctrl + D
✅ Right Answer: (B) Ctrl + F
97. In
Excel, shortcut for Replace is:
(A) Ctrl + F
(B) Ctrl + H
(C) Ctrl + R
(D) Ctrl + A
✅ Right Answer: (B) Ctrl + H
98. In
Excel, Go To dialog box shortcut is:
(A) Ctrl + G
(B) Ctrl + J
(C) Ctrl + T
(D) Ctrl + K
✅ Right Answer: (A) Ctrl + G
99. In Word,
Ctrl + Shift + L applies:
(A) Bold
(B) Italic
(C) Bullet list
(D) Numbering
✅ Right Answer: (C) Bullet list
100. In
Word, Ctrl + Enter inserts:
(A) Line break
(B) Page break
(C) Column break
(D) Section break
✅ Right Answer: (B) Page break
Rakhshan Division Jobs
Your trusted source for the latest government and private jobs
across Balochistan and Pakistan.
Daily updates | Application forms | Test & Interview Schedules
| All in one place!
Visit Our Website: