MS Office MCQs with Answers and Explanations

Question #181

Share Report

In MS Word, which of the following is used to create a table of figures?

A. Insert Caption

B. Insert Cross-reference

C. Insert Index

D. Insert Table of Figures

View Answer & Solution Discuss

Get Complete Subject PDF for Computer

Correct Answer: Option D

Explanation:
The Table of Figures feature (under References tab) generates a list of figures based on captions. Captions are inserted for figures, but to generate the table, you use Table of Figures.

This question belongs to: Computer Microsoft Office

Question #182

Share Report

In Excel, what does the 'CONCATENATE' function do?

A. Converts text to uppercase

B. Joins two or more text strings into one

C. Splits text into separate columns

D. Compares two text strings

View Answer & Solution Discuss

Get Complete Subject PDF for Computer

Correct Answer: Option B

Explanation:
CONCATENATE combines multiple text strings into a single string. In newer versions, CONCAT or TEXTJOIN are also used.

This question belongs to: Computer Microsoft Office

Question #183

Share Report

Which view in MS Access allows you to view data in a spreadsheet-like format?

A. Datasheet View

B. Form View

C. Design View

D. Layout View

View Answer & Solution Discuss

Get Complete Subject PDF for Computer

Correct Answer: Option A

Explanation:
Datasheet View displays data in rows and columns, similar to a spreadsheet. Design View is for structure, Form View for forms, Layout View for form/report layout.

This question belongs to: Computer Microsoft Office

Question #184

Share Report

What is the shortcut key to go to the beginning of a document in MS Word?

A. Home

B. Ctrl + Home

C. Ctrl + End

D. Ctrl + Page Up

View Answer & Solution Discuss

Get Complete Subject PDF for Computer

Correct Answer: Option B

Explanation:
Ctrl + Home moves the cursor to the beginning of the document. Ctrl + End goes to the end. Home moves to the beginning of the line. Ctrl+Page Up moves to previous page.

This question belongs to: Computer Microsoft Office

Question #185

Share Report

In MS PowerPoint, which feature allows you to apply a visual effect to text or objects, such as shadow or glow?

A. Both A and B

B. Text Effects

C. WordArt

D. Shape Effects

View Answer & Solution Discuss

Get Complete Subject PDF for Computer

Correct Answer: Option A

Explanation:
Both Text Effects and Shape Effects provide options for shadows, glows, reflections, etc. for text and shapes respectively.

This question belongs to: Computer Microsoft Office

Question #186

Share Report

Which of the following is a valid shortcut to open the 'Save As' dialog box in MS Office?

A. Alt + S

B. F12

C. Shift + S

D. Ctrl + S

View Answer & Solution Discuss

Get Complete Subject PDF for Computer

Correct Answer: Option B

Explanation:
F12 opens the Save As dialog box. Ctrl + S saves the current file (or opens Save As if new). Alt+S is not standard.

This question belongs to: Computer Microsoft Office

Question #187

Share Report

In MS Word, the 'Watermark' feature is used to:

A. Insert a border around the page

B. Add a header or footer

C. Protect the document from editing

D. Add a background image or text behind the main content

View Answer & Solution Discuss

Get Complete Subject PDF for Computer

Correct Answer: Option D

Explanation:
A watermark is a faded background image or text (like 'Draft' or 'Confidential') that appears behind the document text. It does not protect, border, or header/footer.

This question belongs to: Computer Microsoft Office

Question #188

Share Report

In Excel, which function is used to find the largest value in a range?

A. MAXIFS

B. MAXA

C. LARGE

D. MAX

View Answer & Solution Discuss

Get Complete Subject PDF for Computer

Correct Answer: Option D

Explanation:
The MAX function returns the largest numeric value in a range. LARGE can return the nth largest, MAXA includes logical values, MAXIFS finds max based on criteria.

This question belongs to: Computer Microsoft Office

Question #189

Share Report

Which of the following is NOT a valid slide layout in MS PowerPoint?

A. Title Slide

B. Title and Content

C. Multi-Column

D. Section Header

View Answer & Solution Discuss

Get Complete Subject PDF for Computer

Correct Answer: Option C

Explanation:
PowerPoint has built-in layouts like Title Slide, Title and Content, Section Header, Comparison, etc. There is no 'Multi-Column' standard layout, though you can create columns manually.

This question belongs to: Computer Microsoft Office

Question #190

Share Report

In MS Access, what is the purpose of a 'Report'?

A. To query data

B. To enter data

C. To display data in a formatted print-ready layout

D. To store data

View Answer & Solution Discuss

Get Complete Subject PDF for Computer

Correct Answer: Option C

Explanation:
Reports are designed to present data in a professional, printable format. They are not for data entry (forms) or storage (tables) or querying (queries).

This question belongs to: Computer Microsoft Office

Question #191

Share Report

What is the shortcut key to open the 'Format Cells' dialog box in MS Excel?

A. Ctrl + 1

B. Ctrl + 2

C. Ctrl + 3

D. Ctrl + 4

View Answer & Solution Discuss

Get Complete Subject PDF for Computer

Correct Answer: Option A

Explanation:
Ctrl + 1 opens the Format Cells dialog box. Ctrl+2 applies bold (also Ctrl+B), Ctrl+3 italic, Ctrl+4 underline.

This question belongs to: Computer Microsoft Office

Question #192

Share Report

In MS Word, which feature automatically corrects common spelling and typing errors?

A. AutoFormat

B. AutoText

C. Spell Check

D. AutoCorrect

View Answer & Solution Discuss

Get Complete Subject PDF for Computer

Correct Answer: Option D

Explanation:
AutoCorrect automatically fixes common mistakes, such as correcting 'teh' to 'the'. AutoText is for inserting predefined text, AutoFormat applies formatting, Spell Check checks manually.

This question belongs to: Computer Microsoft Office

Question #193

Share Report

In Excel, what does the 'PMT' function calculate?

A. The payment for a loan based on constant payments and interest rate

B. The present value of an investment

C. The future value of an annuity

D. The interest rate of a loan

View Answer & Solution Discuss

Get Complete Subject PDF for Computer

Correct Answer: Option A

Explanation:
PMT computes the periodic payment for a loan or annuity with constant payments and a fixed interest rate. PV calculates present value, FV future value, RATE calculates interest rate.

This question belongs to: Computer Microsoft Office

Question #194

Share Report

In MS PowerPoint, which option allows you to change the background style of a slide?

A. Slide Design

B. Both A and B

C. Background Styles

D. Format Background

View Answer & Solution Discuss

Get Complete Subject PDF for Computer

Correct Answer: Option B

Explanation:
In PowerPoint, you can right-click and select 'Format Background' or use the 'Background Styles' dropdown under Design tab to change the background.

This question belongs to: Computer Microsoft Office

Question #195

Share Report

What is the maximum number of columns in a Word table (as of Word 2016)?

A. 32767

B. Unlimited

C. 255

D. 63

View Answer & Solution Discuss

Get Complete Subject PDF for Computer

Correct Answer: Option D

Explanation:
A Word table can have up to 63 columns. The number of rows is virtually unlimited (up to 32,767 rows in a table). So 63 is correct.

This question belongs to: Computer Microsoft Office

Question #196

Share Report

In Excel, which function is used to convert a text string that looks like a number into a number?

A. TEXT

B. VALUE

C. CONVERT

D. NUMBER

View Answer & Solution Discuss

Get Complete Subject PDF for Computer

Correct Answer: Option B

Explanation:
The VALUE function converts a text string that represents a number into a numeric value. TEXT does the opposite.

This question belongs to: Computer Microsoft Office

Question #197

Share Report

Which of the following is not a valid object type in MS Access?

A. Worksheet

B. Module

C. Macro

D. Table

View Answer & Solution Discuss

Get Complete Subject PDF for Computer

Correct Answer: Option A

Explanation:
Access objects include Tables, Queries, Forms, Reports, Macros, and Modules. Worksheet is an Excel object, not an Access object.

This question belongs to: Computer Microsoft Office

Question #198

Share Report

In MS Word, the 'Show/Hide' button (¶) is used to:

A. Hide the document text

B. Display or hide non-printing characters like spaces, tabs, and paragraph marks

C. Show or hide the ruler

D. Toggle between print layout and draft view

View Answer & Solution Discuss

Get Complete Subject PDF for Computer

Correct Answer: Option B

Explanation:
The Show/Hide button (¶) toggles the display of formatting marks (paragraph marks, spaces, tabs, etc.). It does not change view or hide text.

This question belongs to: Computer Microsoft Office

Question #199

Share Report

In Excel, what is the result of the formula =LEFT(Microsoft,3)?

A. Soft

B. Mic

C. Micro

D. Microsoft

View Answer & Solution Discuss

Get Complete Subject PDF for Computer

Correct Answer: Option B

Explanation:
LEFT extracts a specified number of characters from the left side of a text string. LEFT(Microsoft,3) returns Mic.

This question belongs to: Computer Microsoft Office

Question #200

Share Report

Which view in MS PowerPoint is used to add speaker notes to slides?

A. Normal View

B. Slide Sorter View

C. Outline View

D. Notes Page View

View Answer & Solution Discuss

Get Complete Subject PDF for Computer

Correct Answer: Option A

Explanation:
In Normal View, there is a Notes pane at the bottom where speaker notes can be entered. Notes Page View also allows editing notes, but Normal is more common for adding notes.

This question belongs to: Computer Microsoft Office

Microsoft Office MCQs

Practice Questions

More Computer Topics