info@jobexams.pk

MS Office MCQs

Master Microsoft Office skills with the most frequently asked MS Office MCQs, designed to help you succeed in job tests and competitive exams. This section covers all essential topics from MS Word, MS Excel, MS PowerPoint, MS Outlook, and more. Whether you're preparing for FPSC, PPSC, NTS, SPSC, BPSC, CSS, PMS, or other recruitment tests, these questions are tailored to meet the latest exam patterns and practical requirements. Our MS Office MCQs are updated regularly to reflect real-world usage and exam trends, helping you build confidence and speed. Perfect for administrative roles, computer operator tests, data entry positions, and IT-related government jobs. Sharpen your concepts, identify weak areas, and stay ahead in your preparation journey with our comprehensive and practice-oriented MS Office question bank.

Browse Categories
Quick Results 0 found

Question Coming Soon!

"" isn't in our database yet, but we're adding new questions daily.

1 MS Office MCQs

The shortcut key to close the workbook is:

  • Ctrl + W
  • Ctrl + X
  • Alt + W
  • Ctrl + Shift + Q
0 Comments
Correct Answer: C. Alt + W

Explanation:

In Microsoft Excel, pressing ... Read More Details

2 MS Office MCQs

What is the shortcut to insert a new row in Excel?

  • Ctrl + Shift + R
  • Alt + N
  • Alt + R
  • Ctrl + Shift + +
0 Comments
Correct Answer: D. Ctrl + Shift + +

Explanation:

In Microsoft Excel, to insert a new row, you can use the keyboard ... Read More Details

3 MS Office MCQs

Shortcut for inserting the current date:

  • Ctrl + :
  • Ctrl + ,
  • Ctrl + D
  • Ctrl + ;
0 Comments
Correct Answer: D. Ctrl + ;

Explanation:

In Microsoft Excel, pressing Ctrl + ; inserts the current date into the ... Read More Details

4 MS Office MCQs

Which tab contains the “Freeze Panes” option?

  • Home
  • File
  • Insert
  • View
0 Comments
Correct Answer: D. View

Explanation:

In Microsoft Excel, the Freeze Panes feature is located under the View tab. ... Read More Details

5 MS Office MCQs

How to insert a new worksheet?

  • File → New
  • Click "+" next to sheet tab
  • Ctrl + E
  • Alt + Shift + S
0 Comments
Correct Answer: B. Click "+" next to sheet tab

Explanation:

In Microsoft Excel, the easiest and most common way to insert a new ... Read More Details

6 MS Office MCQs

Which of the following is used to protect a sheet?

  • Review → Protect Sheet
  • File → Protect
  • Data → Security
  • View → Lock
0 Comments
Correct Answer: A. Review → Protect Sheet

Explanation:

In Microsoft Excel, the Protect Sheet feature is found under the Review tab. This option ... Read More Details

7 MS Office MCQs

To insert a chart, which tab is used?

  • Insert
  • View
  • Page layout
  • Home
0 Comments
Correct Answer: A. Insert

Explanation:

In Microsoft Excel, the Insert tab is used to add various elements into ... Read More Details

8 MS Office MCQs

What does the COUNT() function do?

  • Adds numbers
  • Counts numeric cells
  • Deletes data
  • Averages data
0 Comments
Correct Answer: B. Counts numeric cells

Explanation:

In Microsoft Excel, the COUNT() function is used to count how many cells ... Read More Details

9 MS Office MCQs

Which function is used to calculate the average in Excel?

  • ADD()
  • SUM()
  • COUNT()
  • AVERAGE()
0 Comments
Correct Answer: D. AVERAGE()

Explanation:

In Microsoft Excel, the AVERAGE() function is used to calculate the arithmetic mean ... Read More Details

10 MS Office MCQs

Which symbol is used to start a formula in Excel?

  • #
  • :
  • :
  • =
0 Comments
Correct Answer: D. =

Explanation:

In Microsoft Excel, every formula must begin with an equal sign. This tells ... Read More Details