MS Office MCQs with Answers and Explanations

Question #1181

Share Report

In MS Word, the 'Ctrl + Shift + A' shortcut:

A. Applies bold

B. Toggles all caps

C. Opens font dialog

D. Selects all

View Answer & Solution Discuss

Get Complete Subject PDF for Computer

Correct Answer: Option B

Explanation:
Ctrl+Shift+A toggles UPPERCASE.

This question belongs to: Computer Microsoft Office

Question #1182

Share Report

In PowerPoint, the 'Morph' transition requires:

A. Two slides with common objects that change position, size, or formatting

B. A 3D model

C. A video file

D. An add-in

View Answer & Solution Discuss

Get Complete Subject PDF for Computer

Correct Answer: Option A

Explanation:
Morph animates smooth changes between slides with same objects.

This question belongs to: Computer Microsoft Office

Question #1183

Share Report

In MS Access, the 'Allow Zero Length' property is relevant for:

A. Text and Memo (Long Text) fields

B. Number fields

C. All fields

D. Date fields

View Answer & Solution Discuss

Get Complete Subject PDF for Computer

Correct Answer: Option A

Explanation:
Only text-based fields.

This question belongs to: Computer Microsoft Office

Question #1184

Share Report

Which of the following is the default file extension for a Word template?

A. .dot

B. .dotx

C. .docx

D. .doc

View Answer & Solution Discuss

Get Complete Subject PDF for Computer

Correct Answer: Option B

Explanation:
.dotx is Word template.

This question belongs to: Computer Microsoft Office

Question #1185

Share Report

In Excel, the 'Paste Special' option 'Values' pastes:

A. Only the values, not formulas or formatting

B. Formatting only

C. Formulas only

D. Comments only

View Answer & Solution Discuss

Get Complete Subject PDF for Computer

Correct Answer: Option A

Explanation:
Values pastes the results of formulas.

This question belongs to: Computer Microsoft Office

Question #1186

Share Report

In MS Word, the 'Ctrl + Alt + 1' shortcut applies:

A. Heading 1 style

B. Single line spacing

C. Bullet list

D. Font size 1

View Answer & Solution Discuss

Get Complete Subject PDF for Computer

Correct Answer: Option A

Explanation:
Ctrl+Alt+1 applies Heading 1, Ctrl+Alt+2 Heading 2, etc.

This question belongs to: Computer Microsoft Office

Question #1187

Share Report

In PowerPoint, to add a sound that plays across multiple slides, use:

A. Transitions -> Sound

B. Animations -> Sound

C. Insert -> Audio -> Play Across

D. Audio Tools Playback -> Play Across Slides

View Answer & Solution Discuss

Get Complete Subject PDF for Computer

Correct Answer: Option D

Explanation:
Play Across Slides under Playback tab.

This question belongs to: Computer Microsoft Office

Question #1188

Share Report

In MS Access, the 'Format' property for a Yes/No field can display:

A. 0/1 only

B. Checked/Unchecked

C. Both A and C

D. True/False, Yes/No, or On/Off

View Answer & Solution Discuss

Get Complete Subject PDF for Computer

Correct Answer: Option D

Explanation:
Format property controls display.

This question belongs to: Computer Microsoft Office

Question #1189

Share Report

What is the shortcut to maximize a document window in MS Word?

A. F11

B. Ctrl + F10

C. Ctrl + F12

D. Alt + F10

View Answer & Solution Discuss

Get Complete Subject PDF for Computer

Correct Answer: Option B

Explanation:
Ctrl+F10 maximizes document window.

This question belongs to: Computer Microsoft Office

Question #1190

Share Report

In Excel, the 'Goal Seek' tool is found under:

A. Insert tab

B. Formulas tab

C. Review tab

D. Data tab -> What-If Analysis -> Goal Seek

View Answer & Solution Discuss

Get Complete Subject PDF for Computer

Correct Answer: Option D

Explanation:
Goal Seek is under Data > What-If Analysis.

This question belongs to: Computer Microsoft Office

Question #1191

Share Report

In MS Word, the 'Ctrl + ]' shortcut:

A. Increases font size by 1 point

B. Increases line spacing

C. Applies superscript

D. Increases indent

View Answer & Solution Discuss

Get Complete Subject PDF for Computer

Correct Answer: Option A

Explanation:
Ctrl+] grows font 1 point.

This question belongs to: Computer Microsoft Office

Question #1192

Share Report

In PowerPoint, which of the following is NOT a standard slide layout?

A. Title and 2 Content

B. Section Header

C. Comparison

D. Chart Slide

View Answer & Solution Discuss

Get Complete Subject PDF for Computer

Correct Answer: Option D

Explanation:
Chart Slide is not a built-in layout.

This question belongs to: Computer Microsoft Office

Question #1193

Share Report

In MS Access, a 'Table' object stores data in:

A. Rows (records) and columns (fields)

B. Pages

C. Reports

D. Forms

View Answer & Solution Discuss

Get Complete Subject PDF for Computer

Correct Answer: Option A

Explanation:
Table structure is rows and columns.

This question belongs to: Computer Microsoft Office

Question #1194

Share Report

Which of the following is the correct keyboard shortcut to open the 'Format Cells' dialog in Excel?

A. Ctrl + Shift + F

B. Both A and B

C. Ctrl + 1

D. Ctrl + 2

View Answer & Solution Discuss

Get Complete Subject PDF for Computer

Correct Answer: Option B

Explanation:
Both open Format Cells, but Ctrl+1 opens main, Ctrl+Shift+F opens Font tab.

This question belongs to: Computer Microsoft Office

Question #1195

Share Report

In MS Word, the 'Ctrl + Alt + N' shortcut switches to:

A. Draft view

B. Print Layout view

C. Outline view

D. Normal view (deprecated)

View Answer & Solution Discuss

Get Complete Subject PDF for Computer

Correct Answer: Option A

Explanation:
Ctrl+Alt+N switches to Draft view.

This question belongs to: Computer Microsoft Office

Question #1196

Share Report

In Excel, the function =VLOOKUP(102, A2:C10, 2, FALSE) searches for 102 in:

A. The first column of the range A2:C10

B. The row 102

C. The second column

D. The entire range

View Answer & Solution Discuss

Get Complete Subject PDF for Computer

Correct Answer: Option A

Explanation:
VLOOKUP searches the first column of the table_array.

This question belongs to: Computer Microsoft Office

Question #1197

Share Report

In PowerPoint, which key can be used to jump to a specific slide number during a slide show?

A. Alt + slide number

B. Ctrl + G

C. Type slide number and press Enter

D. Shift + slide number

View Answer & Solution Discuss

Get Complete Subject PDF for Computer

Correct Answer: Option C

Explanation:
During slide show, type number and Enter to go to that slide.

This question belongs to: Computer Microsoft Office

Question #1198

Share Report

In MS Access, what is the default data type for a field when you create a new table in Datasheet View?

A. AutoNumber

B. Short Text

C. Number

D. Long Text

View Answer & Solution Discuss

Get Complete Subject PDF for Computer

Correct Answer: Option B

Explanation:
When you enter data directly, Access assigns Short Text by default.

This question belongs to: Computer Microsoft Office

Question #1199

Share Report

In PowerPoint, to see only the text content of slides in a structured list, use:

A. Notes Page

B. Outline view

C. Normal view

D. Slide Sorter

View Answer & Solution Discuss

Get Complete Subject PDF for Computer

Correct Answer: Option B

Explanation:
Outline view shows slide text only.

This question belongs to: Computer Microsoft Office

Microsoft Office MCQs

Practice Questions

More Computer Topics