MS Office MCQ Questions

 

Why Prepare for MS Office MCQ Questions

MS Office MCQs are common in banking exams and other competitive exams as they assess a candidate’s ability to use basic office tools effectively. Mastering these questions can improve your chances of scoring higher in exams, particularly in the computer knowledge section.

Let’s get into the key Microsoft Office practice questions that you should be familiar with for competitive exams.

Top MS Office MCQ Questions for Competitive Exams

1. What is placed at the left of the horizontal bar in MS Word?

(a) Home

(b) Indicators

(c) Ctrl + Tab

(d) View buttons

(e) None of the above

Answer: (d) View buttons

Explanation: View buttons help in changing how the presentation or document appears.

2. Where is the horizontal split bar located on the MS Word screen?

(a) On the vertical scroll bar’s top

(b) On the vertical scroll bar’s bottom

(c) The horizontal scroll bar’s left side

(d) The horizontal scroll bar’s right side

(e) None of the above

Answer: (a) On the vertical scroll bar’s top

Explanation: The horizontal split bar is located above the vertical scroll bar in MS Word.

Frequently Asked MS Office MCQ Questions in Bank Exams

3. What purpose do bookmarks serve in MS Word?

(a) To save the document in a specific location

(b) To save a website’s URL for future reference

(c) To use the document for search

(d) To save alignments as they are

(e) None of the above

Answer: (b) To save a website’s URL for future reference

Explanation: A bookmark is used to save a web page URL, allowing quick access later.

4. What does Ctrl + D do in MS Word?

(a) To add the dialogue folder

(b) Bookmark of the URL is added and contents can be overwritten in Google Sheets and Microsoft Excel

(c) To insert any subfolder in desktop

(d) To save any URL in the system

(e) None of the above

Answer: (b) Bookmark of the URL is added and contents can be overwritten in Google Sheets and Microsoft Excel

Explanation: Ctrl + D is used for adding a URL to bookmarks and is also used in Excel to duplicate objects.

Excel Related Interview Questions

5. Explain the VLOOKUP function in Excel.

Answer: The VLOOKUP function searches for a value in the first column of a range and returns a value from the same row in a different column. It is widely used for data lookups.

6. What is the difference between a workbook and a worksheet in MS Excel?

Answer: A workbook is a file in Excel that contains multiple worksheets. A worksheet is a single sheet within the workbook that holds cells organized in rows and columns.

7. How do you reference a cell in an Excel formula?

Answer: You reference a cell by using the cell address (e.g., A1). The reference can be relative (changes when copied) or absolute (remains constant with a $ sign).

Excel Questions Asked in Interview

8. How do you count unique values in Excel?

Answer: You can use the combination of COUNTIF and SUM functions to count unique values in a range, or use the UNIQUE function in Office 365.

9. What does Ctrl + G do in MS Word?

(a) Activates the Goto Tab while the Find and Replace dialogue box is opened.

(b) Launches the Find Tab in the Find and Replace dialogue box.

(c) Opens the Replace Tab.

(d) Launches the Goto Dialog box.

Answer: (a) Activates the Goto Tab in the Find and Replace dialogue box.

Explanation: The Ctrl + G shortcut opens the Goto Tab in the Find and Replace dialog box for easier navigation.

Excel Interview Questions for Advanced Users

10. How do you use the PivotTable function in Excel?

Answer: PivotTables are used to summarize large datasets. They allow you to perform arithmetic operations, sort, filter, and group data, making them ideal for data analysis.

11. What is the purpose of the INDEX-MATCH function in Excel?

Answer: The INDEX-MATCH function is an alternative to VLOOKUP. It is used to look up values in tables based on row and column indices, offering more flexibility than VLOOKUP.

12. How do you protect a worksheet in Excel?

Answer: You can protect a worksheet by right-clicking the sheet tab, selecting “Protect Sheet,” and setting a password to prevent unauthorized changes.

MS Office MCQ for Bank and Government Exams

Ques: What is the maximum number of columns you can insert into a Word document?

(a) 45

(b) 50

(c) 63

(d) 65

Answer: (c) 63

Explanation: The maximum number of columns you can insert in a Word document is 63, which can be added as a table.