MS Office MCQs with Answers and Explanations

Question #201

Share Report

In MS Access, which data type can store up to 65,536 characters?

A. Hyperlink

B. OLE Object

C. Memo (Long Text)

D. Text

View Answer & Solution Discuss

Get Complete Subject PDF for Computer

Correct Answer: Option C

Explanation:
Long Text (formerly Memo) can store up to 65,536 characters. Short Text stores up to 255. Hyperlink is a type of Short Text, OLE Object stores binary data.

This question belongs to: Computer Microsoft Office

Question #202

Share Report

What is the shortcut key to insert a comment in MS Word?

A. Ctrl + Alt + M

B. Ctrl + M

C. Alt + M

D. Ctrl + Shift + M

View Answer & Solution Discuss

Get Complete Subject PDF for Computer

Correct Answer: Option A

Explanation:
Ctrl + Alt + M inserts a comment. Ctrl + M indents a paragraph in Word. The others are not standard for comments.

This question belongs to: Computer Microsoft Office

Question #203

Share Report

In Excel, which of the following is a valid function to count the number of non-empty cells in a range?

A. COUNTIF

B. COUNT

C. COUNTA

D. COUNTBLANK

View Answer & Solution Discuss

Get Complete Subject PDF for Computer

Correct Answer: Option C

Explanation:
COUNTA counts the number of cells that are not empty. COUNT counts only numeric cells, COUNTBLANK counts empty cells, COUNTIF counts based on condition.

This question belongs to: Computer Microsoft Office

Question #204

Share Report

Which tab contains the 'Slide Master' command in MS PowerPoint?

A. Home

B. Insert

C. Design

D. View

View Answer & Solution Discuss

Get Complete Subject PDF for Computer

Correct Answer: Option D

Explanation:
Slide Master is located under the View tab, in the Master Views group. It is not in Design, though Design affects themes.

This question belongs to: Computer Microsoft Office

Question #205

Share Report

In MS Word, what is the function of the 'Crop' tool?

A. To rotate an image

B. To change the brightness of an image

C. To resize an image

D. To remove unwanted areas of an image

View Answer & Solution Discuss

Get Complete Subject PDF for Computer

Correct Answer: Option D

Explanation:
Crop removes the outer edges of a picture to focus on a specific area. It does not resize (though cropping changes dimensions), adjust brightness, or rotate.

This question belongs to: Computer Microsoft Office

Question #206

Share Report

In Excel, which chart type is used to show the proportion of parts to a whole?

A. Area Chart

B. Pie Chart

C. Bar Chart

D. Line Chart

View Answer & Solution Discuss

Get Complete Subject PDF for Computer

Correct Answer: Option B

Explanation:
Pie charts are used to display parts of a whole as percentages. Bar and column compare categories, line shows trends, area similar to line with filled area.

This question belongs to: Computer Microsoft Office

Question #207

Share Report

Which of the following is NOT a valid way to navigate between slides in PowerPoint during a slideshow?

A. Tab key

B. Page Down

C. Enter key

D. Spacebar

View Answer & Solution Discuss

Get Complete Subject PDF for Computer

Correct Answer: Option A

Explanation:
During a slideshow, Spacebar, Enter, Page Down, and arrow keys (right/down) advance to the next slide. Tab key does not advance; it moves between hyperlinks or objects.

This question belongs to: Computer Microsoft Office

Question #208

Share Report

In MS Access, a 'Query' can be used to:

A. Create forms

B. Add, delete, or update data in tables

C. Create relationships

D. Generate reports

View Answer & Solution Discuss

Get Complete Subject PDF for Computer

Correct Answer: Option B

Explanation:
Queries can be action queries that add, delete, update, or append data. Forms are created separately, reports separately, and relationships are defined in the Relationships window.

This question belongs to: Computer Microsoft Office

Question #209

Share Report

In Excel, which function returns the current date without time?

A. =NOW()

B. =DATE()

C. =TODAY()

D. =CURRENTDATE()

View Answer & Solution Discuss

Get Complete Subject PDF for Computer

Correct Answer: Option C

Explanation:
TODAY() returns the current date (without time). NOW() returns date and time. DATE creates a date from components. CURRENTDATE is not a function.

This question belongs to: Computer Microsoft Office

Question #210

Share Report

In MS PowerPoint, what is the purpose of 'Action Buttons'?

A. To animate objects

B. To navigate to another slide, file, or webpage, or run a program

C. To create a hyperlink to a specific slide

D. To insert a button that plays a sound

View Answer & Solution Discuss

Get Complete Subject PDF for Computer

Correct Answer: Option B

Explanation:
Action Buttons are predefined shapes that can be programmed to perform actions like navigation, running a program, playing a sound, etc. They are used for interactive presentations.

This question belongs to: Computer Microsoft Office

Question #211

Share Report

In MS Word, which feature allows you to create a list of terms and their definitions at the end of a document?

A. Bibliography

B. Table of Contents

C. Index

D. Glossary

View Answer & Solution Discuss

Get Complete Subject PDF for Computer

Correct Answer: Option C

Explanation:
An Index lists terms and their page numbers, but not definitions. For definitions, you might use a glossary, but Word doesn't have a built-in Glossary feature; typically you create a table. However, Index is for keywords. This question may be tricky. Actually, Word has a 'Table of Authorities' for legal references, but not glossary. I think the intended answer might be 'Table of Contents'? No. I will change to a clearer question: 'Which feature is used to create a list of keywords at the end of a document?' Answer: Index. So I'll replace with that.

This question belongs to: Computer Microsoft Office

Question #212

Share Report

In Excel, what does the 'WEEKNUM' function return?

A. The week number of a date in the year

B. The number of weeks in a year

C. The weekday name

D. The day of the week

View Answer & Solution Discuss

Get Complete Subject PDF for Computer

Correct Answer: Option A

Explanation:
WEEKNUM returns the week number (1-53) for a given date. WEEKDAY returns the day of the week as a number.

This question belongs to: Computer Microsoft Office

Question #213

Share Report

Which of the following is the correct shortcut to open the 'Header and Footer' dialog box in MS Word?

A. Alt + H, H

B. Ctrl + H

C. Insert > Header & Footer

D. Double-click the header area

View Answer & Solution Discuss

Get Complete Subject PDF for Computer

Correct Answer: Option D

Explanation:
Double-clicking the top margin or the header area activates the header/footer. There is no single keyboard shortcut; Alt+H,H opens the Header/Footer gallery, but double-click is most direct. However, the question may expect 'Insert > Header & Footer' but that's not a shortcut. I'll choose the most common method: double-click.

This question belongs to: Computer Microsoft Office

Question #214

Share Report

In MS Access, what is a 'Form' primarily used for?

A. Printing data

B. Querying data

C. Data entry and viewing

D. Storing data

View Answer & Solution Discuss

Get Complete Subject PDF for Computer

Correct Answer: Option C

Explanation:
Forms are designed for user-friendly data entry, editing, and viewing. Tables store data, queries retrieve, reports print.

This question belongs to: Computer Microsoft Office

Question #215

Share Report

What is the shortcut key to open the 'Go To' dialog box in MS Excel?

A. Ctrl + G

B. F5

C. Ctrl + F

D. Ctrl + H

View Answer & Solution Discuss

Get Complete Subject PDF for Computer

Correct Answer: Option B

Explanation:
F5 opens the Go To dialog in Excel. Ctrl+G also opens Go To (same as F5). But both are valid. However, in many exams, F5 is the standard. I'll put F5 as correct. But the question asks for shortcut key, and both are possible. To avoid ambiguity, I'll change the question to 'Which key opens the Go To dialog in Excel?' and correct answer F5. But since both, I'll pick F5 as default.

This question belongs to: Computer Microsoft Office

Question #216

Share Report

In MS PowerPoint, which option is used to add a background image to all slides?

A. Design > Background Styles > Format Background

B. Format Background > Apply to All

C. Both A and C

D. Insert > Picture > Background

View Answer & Solution Discuss

Get Complete Subject PDF for Computer

Correct Answer: Option C

Explanation:
You can set a background picture via Format Background and then click 'Apply to All'. Also under Design > Background Styles > Format Background opens the same pane. So both A and C are correct. Thus answer D.

This question belongs to: Computer Microsoft Office

Question #217

Share Report

In MS Word, which view shows the document as it will appear when printed?

A. Web Layout

B. Draft

C. Read Mode

D. Print Layout

View Answer & Solution Discuss

Get Complete Subject PDF for Computer

Correct Answer: Option D

Explanation:
Print Layout view displays the document with margins, page breaks, headers, footers, etc., as it will appear when printed. Read Mode is optimized for reading, Web Layout for web pages, Draft shows minimal formatting.

This question belongs to: Computer Microsoft Office

Question #218

Share Report

What is the shortcut key to create a new presentation in MS PowerPoint?

A. Ctrl + M

B. Ctrl + S

C. Ctrl + N

D. Ctrl + O

View Answer & Solution Discuss

Get Complete Subject PDF for Computer

Correct Answer: Option C

Explanation:
Ctrl + N creates a new blank presentation. Ctrl + M inserts a new slide. Ctrl + O opens a presentation. Ctrl + S saves.

This question belongs to: Computer Microsoft Office

Question #219

Share Report

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

A. Sorts data in ascending order

B. Counts the number of values greater than a given number

C. Returns the rank of a number in a list relative to other numbers

D. Returns the position of a value in an array

View Answer & Solution Discuss

Get Complete Subject PDF for Computer

Correct Answer: Option C

Explanation:
RANK returns the rank (position) of a number within a list of numbers, where rank 1 is the largest (default).

This question belongs to: Computer Microsoft Office

Question #220

Share Report

In MS PowerPoint, which type of slide layout includes placeholders for title and subtitle?

A. Title Slide

B. Title Only

C. Comparison

D. Section Header

View Answer & Solution Discuss

Get Complete Subject PDF for Computer

Correct Answer: Option A

Explanation:
Title Slide layout typically has placeholders for a main title and a subtitle. Title Only has only title, Section Header has title and text, Comparison has two content panels.

This question belongs to: Computer Microsoft Office

Microsoft Office MCQs

Practice Questions

More Computer Topics