Mastering ms office mcqs with answers is essential for candidates preparing for competitive exams in Pakistan, including PPSC, FPSC, NTS, CSS, FIA, Junior Clerk, Computer Operator, and Data Entry Operator tests. In almost every general recruitment and IT screening exam, Microsoft Office questions from MS Word, MS Excel, and MS PowerPoint carry high weightage. Practicing ms office mcqs with answers helps candidates quickly recall shortcut keys, formulas, menu tabs, file extensions, and practical features that frequently appear in past papers.
In this comprehensive guide, we have compiled 30 of the most repeated and exam-focused MS Office multiple-choice questions along with verified answers and clear explanations.
Table of Contents
Why Practice ms office mcqs with answers for Competitive Exams?
Examiners test both theoretical knowledge and hands-on familiarity with productivity tools. Whether you are preparing for a clerical post, administrative test, or computer operator screening exam, revising ms office mcqs with answers sharpens your accuracy and saves valuable time during one-paper MCQs tests.
For broader test preparation on mcqsdesk.com, you can also practice our Computer Science Fundamentals MCQs for Test Preparation, Pakistan Studies MCQs with Answers, and Islamic Studies MCQs with Answers. If you also appreciate classical Urdu poetry and literary reflections during study breaks, explore Ahmad Nadeem Qasmi Poetry in Urdu on DailyWishers. For official Microsoft Office product documentation and feature guides, visit Microsoft Support Official Portal.
Top 30 MS Office MCQs with Answers and Explanations
Below are 30 frequently repeated questions covering MS Word, MS Excel, and MS PowerPoint from past papers of PPSC, FPSC, and NTS:
1. Which shortcut key is used to open the Print dialog box in MS Word?
- A) Ctrl + P
- B) Ctrl + O
- C) Ctrl + Shift + P
- D) Alt + P
- Correct Answer: A) Ctrl + P
- Explanation: Pressing Ctrl + P opens the Print pane directly in MS Word, Excel, and PowerPoint.
2. What is the default file extension of a document created in MS Word 2016 or later?
- A) .doc
- B) .docx
- C) .txt
- D) .rtf
- Correct Answer: B) .docx
3. Which feature in MS Word is used to send the same letter to multiple recipients with different addresses?
- A) Track Changes
- B) Mail Merge
- C) Macro
- D) SmartArt
- Correct Answer: B) Mail Merge
- Explanation: Mail Merge combines a main document with a recipient data source such as an Excel sheet or Outlook contact list.
4. Which shortcut key is used to apply Bold formatting to selected text in MS Word?
- A) Ctrl + I
- B) Ctrl + U
- C) Ctrl + B
- D) Ctrl + Shift + B
- Correct Answer: C) Ctrl + B
5. In MS Word, which menu tab contains options for Page Margins, Orientation, and Size?
- A) Insert
- B) Layout
- C) Review
- D) References
- Correct Answer: B) Layout
6. What is the shortcut key to insert a Page Break in MS Word?
- A) Ctrl + Enter
- B) Shift + Enter
- C) Alt + Enter
- D) Ctrl + Shift + Enter
- Correct Answer: A) Ctrl + Enter
7. Which view in MS Word shows how the document will look when printed, including headers, footers, and margins?
- A) Draft View
- B) Web Layout View
- C) Print Layout View
- D) Outline View
- Correct Answer: C) Print Layout View
8. Which shortcut key is used to open the Find and Replace dialog box in MS Word?
- A) Ctrl + F
- B) Ctrl + H
- C) Ctrl + R
- D) Ctrl + G
- Correct Answer: B) Ctrl + H
9. In MS Word, what is the default font in modern versions (Word 2007–2021)?
- A) Times New Roman
- B) Arial
- C) Calibri
- D) Cambria
- Correct Answer: C) Calibri
10. Which shortcut key is used to justify text alignment in MS Word?
- A) Ctrl + L
- B) Ctrl + R
- C) Ctrl + E
- D) Ctrl + J
- Correct Answer: D) Ctrl + J
11. What is the default file extension of a workbook in MS Excel 2016 or later?
- A) .xls
- B) .xlsx
- C) .csv
- D) .xlsm
- Correct Answer: B) .xlsx
12. In MS Excel, every formula must begin with which character?
- A) +
- B) =
- C) @
- D) #
- Correct Answer: B) =
13. What is the intersection of a row and a column in MS Excel called?
- A) Field
- B) Cell
- C) Record
- D) Block
- Correct Answer: B) Cell
14. Which Excel function is used to find the highest value in a selected range of cells?
- A) HIGH()
- B) TOP()
- C) MAX()
- D) LARGE()
- Correct Answer: C) MAX()
15. Which shortcut key is used to insert the current date in an MS Excel cell?
- A) Ctrl + ;
- B) Ctrl + Shift + ;
- C) Alt + D
- D) Ctrl + D
- Correct Answer: A) Ctrl + ;
- Explanation: Ctrl + ; inserts a static current date, while Ctrl + Shift + ; inserts the current time.
16. What error value appears in MS Excel when a formula divides a number by zero?
- A) #NAME?
- B) #VALUE!
- C) #DIV/0!
- D) #REF!
- Correct Answer: C) #DIV/0!
17. Which Excel function counts only cells that contain numeric values?
- A) COUNTA()
- B) COUNT()
- C) COUNTIF()
- D) COUNTBLANK()
- Correct Answer: B) COUNT()
18. In MS Excel, which symbol is used to create an absolute cell reference (for example, $A$1)?
- A) %
- B) &
- C) $
- D) *
- Correct Answer: C) $
19. Which feature in MS Excel summarizes large tables of data dynamically by dragging fields?
- A) Conditional Formatting
- B) PivotTable
- C) Data Validation
- D) Goal Seek
- Correct Answer: B) PivotTable
20. Which shortcut key selects an entire row in MS Excel?
- A) Ctrl + Spacebar
- B) Shift + Spacebar
- C) Alt + Spacebar
- D) Ctrl + Shift + Spacebar
- Correct Answer: B) Shift + Spacebar
- Explanation: Shift + Spacebar selects the entire row, whereas Ctrl + Spacebar selects the entire column.
21. What is the default file extension of a presentation in MS PowerPoint 2016 or later?
- A) .ppt
- B) .pptx
- C) .pps
- D) .pot
- Correct Answer: B) .pptx
22. Which shortcut key is used to start a slide show from the very first slide in MS PowerPoint?
- A) F5
- B) Shift + F5
- C) Ctrl + F5
- D) Alt + F5
- Correct Answer: A) F5
23. Which shortcut key starts a slide show from the currently selected slide in MS PowerPoint?
- A) F5
- B) Shift + F5
- C) Ctrl + S
- D) Alt + S
- Correct Answer: B) Shift + F5
24. Which shortcut key is used to insert a new slide in MS PowerPoint?
- A) Ctrl + N
- B) Ctrl + M
- C) Ctrl + Shift + N
- D) Alt + N
- Correct Answer: B) Ctrl + M
25. In MS PowerPoint, what are visual effects applied when moving from one slide to another called?
- A) Animations
- B) Transitions
- C) Themes
- D) Layouts
- Correct Answer: B) Transitions
- Explanation: Transitions apply between slides, while animations apply to individual objects or text inside a slide.
26. Which view in MS PowerPoint displays all slides as small thumbnails on one screen for easy reordering?
- A) Normal View
- B) Reading View
- C) Slide Sorter View
- D) Notes Page View
- Correct Answer: C) Slide Sorter View
27. Which shortcut key is used to group selected objects in MS PowerPoint?
- A) Ctrl + G
- B) Ctrl + Shift + G
- C) Alt + G
- D) Ctrl + H
- Correct Answer: A) Ctrl + G
28. Which feature in MS PowerPoint controls the overall design, font styles, and placeholders of all slides in a presentation?
- A) Slide Master
- B) Handout Master
- C) Design Ideas
- D) Format Painter
- Correct Answer: A) Slide Master
29. Which shortcut key is used to exit an active slide show in MS PowerPoint?
- A) End
- B) Esc
- C) Backspace
- D) Ctrl + E
- Correct Answer: B) Esc
30. Which shortcut key copies formatting from one object or text selection to another in MS Office?
- A) Ctrl + Shift + C
- B) Ctrl + Alt + C
- C) Alt + Shift + C
- D) Ctrl + C
- Correct Answer: A) Ctrl + Shift + C
- Explanation: Ctrl + Shift + C copies formatting, and Ctrl + Shift + V pastes that formatting.
Conclusion
Consistent practice of ms office mcqs with answers is one of the fastest ways to score high in PPSC, FPSC, NTS, and departmental computer tests. Bookmark this page on mcqsdesk.com and review these Word, Excel, and PowerPoint questions regularly to build speed, accuracy, and exam confidence.
