Top 20 MS Office MCQs for NTS, CSS, PMS, KPPSC, PPSC, ETEA, SPSC, BPSC, and FPSC Tests

Proficiency in Microsoft Office is a mandatory skill tested in almost all government job exams, including NTS, CSS, PMS, KPPSC, PPSC, ETEA, SPSC, BPSC, and FPSC. These 20 MCQs on MS Word, Excel, and PowerPoint will help you sharpen your skills and secure maximum marks in the computer proficiency section.

1. Which function key is used for spell check in MS Word?

• F1
• F5
• F7
• F9

Answer: F7

2. What is the shortcut key to create a new document in MS Word?

• Ctrl + O
• Ctrl + N
• Ctrl + S
• Ctrl + D

Answer: Ctrl + N

3. In MS Excel, all formulas must begin with...?

• an asterisk (*)
• a plus sign (+)
• an equal sign (=)
• a hash (#)

Answer: an equal sign (=)

4. A collection of worksheets in MS Excel is called a...?

• Workbook
• Workset
• Excel book
• Document

Answer: Workbook

5. Which of the following is the file extension for an MS PowerPoint presentation?

• .docx
• .xlsx
• .pptx
• .pdf

Answer: .pptx

6. The "Portrait" and "Landscape" options are types of...?

• Page Orientation
• Page Size
• Page Margins
• Font Style

Answer: Page Orientation

7. What is the shortcut to go to the last slide in a PowerPoint presentation?

• Ctrl + End
• Shift + End
• End
• Alt + End

Answer: End

8. In MS Excel, the intersection of a row and a column is called a...?

• Cell
• Box
• Grid
• Square

Answer: Cell

9. To center-align a paragraph in MS Word, use the shortcut...?

• Ctrl + L
• Ctrl + R
• Ctrl + C
• Ctrl + E

Answer: Ctrl + E

10. Which function is used to calculate the sum of a range of cells in MS Excel?

• =ADD()
• =TOTAL()
• =SUM()
• =CALC()

Answer: =SUM()

11. What is a "Slide Transition" in PowerPoint?

• The movement of text on a slide
• The visual effect as one slide changes to the next
• The animation of an object
• The way a presentation is printed

Answer: The visual effect as one slide changes to the next

12. The 'Header' and 'Footer' option is available in which tab of MS Word?

• Home
• View
• Insert
• Page Layout

Answer: Insert

13. In MS Excel, to select an entire column, you should click on the...?

• Row heading
• Column heading
• Cell
• Formula bar

Answer: Column heading

14. What is the purpose of the 'BCC' field in an email composed via MS Outlook?

• To send a copy to all recipients
• To send a blind carbon copy, hiding the recipient's email from others
• To mark the email as important
• To attach a file

Answer: To send a blind carbon copy, hiding the recipient's email from others

15. The feature in MS Word that automatically corrects common spelling errors is called...?

• AutoFormat
• AutoCorrect
• AutoText
• Spell Check

Answer: AutoCorrect

16. Which chart type is best for comparing values across categories in MS Excel?

• Pie Chart
• Line Chart
• Bar Chart
• Scatter Plot

Answer: Bar Chart

17. What is the shortcut key to start a slideshow from the beginning in PowerPoint?

• F5
• Shift + F5
• Ctrl + P
• Alt + F5

Answer: F5

18. Which view in MS Word is best for reading a document on screen?

• Print Layout
• Web Layout
• Read Mode
• Outline View

Answer: Read Mode

19. To insert a new worksheet in MS Excel, you can use the shortcut...?

• Ctrl + W
• Shift + F11
• Alt + N
• Ctrl + Tab

Answer: Shift + F11

20. The "Find and Replace" feature is available in which tab of MS Office applications?

• Home
• Insert
• View
• Review

Answer: Home