MS Office MCQs with Answers and Explanations

Question #1

In MS Excel, what is the default keyboard shortcut to toggle the absolute cell referencing mode ($) while editing a formula?

A. F4

B. F11

C. F8

D. F2

View Answer & Solution Discuss

Get Complete Subject PDF for Computer

Correct Answer: Option A

Explanation:
Pressing the F4 key while editing a cell reference in an Excel formula toggles through absolute ($A$1), mixed (A$1, $A1), and relative (A1) references.

This question belongs to: Computer Microsoft Office

Question #2

Share Report

In MS PowerPoint, which view allows you to see all the slides in a presentation as thumbnails arranged in horizontal rows for easy reordering?

A. Reading View

B. Slide Sorter View

C. Outline View

D. Presenter View

View Answer & Solution Discuss

Get Complete Subject PDF for Computer

Correct Answer: Option B

Explanation:
Slide Sorter View displays all slides in the presentation as miniature thumbnails, allowing users to easily reorder, delete, or organize slides into sections.

This question belongs to: Computer Microsoft Office

Question #3

Share Report

Which of the following database objects in MS Access is primarily designed to securely look up, enter, or modify data in a table through a user-friendly layout?

A. Report

B. Form

C. Query

D. Macro

View Answer & Solution Discuss

Get Complete Subject PDF for Computer

Correct Answer: Option B

Explanation:
A Form in MS Access provides a user interface or layout used to view, enter, change, or navigate records in a table or query.

This question belongs to: Computer Microsoft Office

Question #4

Share Report

What is the key combination used to insert a mandatory page break manually in MS Word?

A. Ctrl + Shift + Enter

B. Alt + Enter

C. Shift + Enter

D. Ctrl + Enter

View Answer & Solution Discuss

Get Complete Subject PDF for Computer

Correct Answer: Option D

Explanation:
Ctrl + Enter inserts a hard or manual page break at the cursor position in MS Word, while Shift + Enter inserts a soft line break.

This question belongs to: Computer Microsoft Office

Question #5

Share Report

Which transition or animation effect property in MS PowerPoint allows an animation to start at the exact same time as the previous animation item?

A. On Click

B. Trigger

C. With Previous

D. After Previous

View Answer & Solution Discuss

Get Complete Subject PDF for Computer

Correct Answer: Option C

Explanation:
The 'With Previous' setting starts the selected animation effect simultaneously with the animation immediately preceding it on the slide timeline.

This question belongs to: Computer Microsoft Office

Question #6

Share Report

In MS Access, which data type is ideal for fields that store long strings of alphanumeric characters, sentences, or paragraphs exceeding 255 characters?

A. Long Text

B. Short Text

C. OLE Object

D. Hyperlink

View Answer & Solution Discuss

Get Complete Subject PDF for Computer

Correct Answer: Option A

Explanation:
In modern versions of MS Access, 'Long Text' (previously called Memo) stores up to about 1 gigabyte of text, whereas 'Short Text' is capped at 255 characters.

This question belongs to: Computer Microsoft Office

Question #7

Share Report

What is the function of the shortcut key combination Ctrl + Shift + G in MS Word?

A. Opens the Word Count dialog box

B. Toggles between uppercase and lowercase text

C. Activates the Research pane

D. Inserts a hyperlink

View Answer & Solution Discuss

Get Complete Subject PDF for Computer

Correct Answer: Option A

Explanation:
Ctrl + Shift + G directly opens the Word Count statistics dialog box in MS Word, providing details like pages, words, characters, and paragraphs.

This question belongs to: Computer Microsoft Office

Question #8

Share Report

Which feature in MS PowerPoint allows you to pick specific slides from a larger presentation file to build an alternative sequence without modifying the original slides?

A. Broadcast Slide Show

B. Slide Master

C. Rehearsed Timings

D. Custom Slide Show

View Answer & Solution Discuss

Get Complete Subject PDF for Computer

Correct Answer: Option D

Explanation:
A Custom Slide Show lets you select specific slides from your current presentation file and arrange them into a separate tailored sequence for a specific audience.

This question belongs to: Computer Microsoft Office

Question #9

Share Report

What happens when you select a block of text in MS Word and press the 'Ctrl + E' shortcut?

A. The text is left-aligned

B. The text is justified

C. The text is centered

D. The text is right-aligned

View Answer & Solution Discuss

Get Complete Subject PDF for Computer

Correct Answer: Option C

Explanation:
Ctrl + E is the standard keyboard shortcut used to center-align the selected text or paragraph in MS Word.

This question belongs to: Computer Microsoft Office

Question #10

Share Report

Which function in MS Excel counts the number of cells in a specified range that contain numerical data only?

A. COUNT

B. COUNTA

C. COUNTBLANK

D. COUNTIF

View Answer & Solution Discuss

Get Complete Subject PDF for Computer

Correct Answer: Option A

Explanation:
The COUNT function counts cells containing numbers only. COUNTA counts all non-empty cells regardless of data type, and COUNTBLANK counts empty cells.

This question belongs to: Computer Microsoft Office

Question #11

Share Report

Which view or master layout in MS PowerPoint is used to edit universal design themes, default fonts, and global slide layouts for an entire presentation file at once?

A. Handout Master

B. Outline Master

C. Notes Master

D. Slide Master

View Answer & Solution Discuss

Get Complete Subject PDF for Computer

Correct Answer: Option D

Explanation:
The Slide Master is the top slide in a hierarchy of slides that stores information about the theme and slide layouts of a presentation. Editing it changes all slides automatically.

This question belongs to: Computer Microsoft Office

Question #12

Share Report

In MS Word, the small customized toolbar that appears immediately next to your cursor after selecting text containing options like bold, italic, and font size is called the:

A. Mini Toolbar

B. Status Bar

C. Quick Access Toolbar

D. Ribbon Explorer

View Answer & Solution Discuss

Get Complete Subject PDF for Computer

Correct Answer: Option A

Explanation:
The Mini Toolbar automatically appears as a semi-transparent overlay when text is selected, offering rapid access to high-frequency formatting options.

This question belongs to: Computer Microsoft Office

Question #13

Share Report

Which MS Excel function returns the serial number of the current system date and time simultaneously?

A. TODAY()

B. NOW()

C. DATE()

D. TIME()

View Answer & Solution Discuss

Get Complete Subject PDF for Computer

Correct Answer: Option B

Explanation:
The NOW() function returns both the current system date and time. In contrast, TODAY() returns only the current system date without the exact time.

This question belongs to: Computer Microsoft Office

Question #14

Share Report

In MS Word, which specific type of indent moves all lines of a paragraph inward from the left margin except for the first line?

A. Negative Indent

B. Right Indent

C. First Line Indent

D. Hanging Indent

View Answer & Solution Discuss

Get Complete Subject PDF for Computer

Correct Answer: Option D

Explanation:
A Hanging Indent leaves the first line of a paragraph flush with the margin, while all subsequent lines are indented or set inward.

This question belongs to: Computer Microsoft Office

Question #15

Share Report

What is the keyboard shortcut to start a presentation slide show directly from the currently active slide instead of the beginning in MS PowerPoint?

A. Ctrl + F5

B. Alt + F5

C. F5

D. Shift + F5

View Answer & Solution Discuss

Get Complete Subject PDF for Computer

Correct Answer: Option D

Explanation:
While pressing F5 runs a presentation from slide one, pressing Shift + F5 initiates the slide show from whichever slide is currently active on your screen.

This question belongs to: Computer Microsoft Office

Question #16

Share Report

Which of the following errors is thrown by MS Excel when a formula attempts to divide a numeric value by zero or an empty cell?

A. #NUM!

B. #VALUE!

C. #DIV/0!

D. #REF!

View Answer & Solution Discuss

Get Complete Subject PDF for Computer

Correct Answer: Option C

Explanation:
The #DIV/0! error is explicitly thrown by Excel whenever a formula attempts division by zero or references an empty cell as the divisor.

This question belongs to: Computer Microsoft Office

Question #17

Share Report

In MS Access, a unique key that prevents duplicate entries and uniquely distinguishes each record or row in a table database is known as the:

A. Candidate Key

B. Primary Key

C. Foreign Key

D. Composite Key

View Answer & Solution Discuss

Get Complete Subject PDF for Computer

Correct Answer: Option B

Explanation:
The Primary Key is a field or combination of fields that uniquely identifies each record in an Access table and cannot contain null or duplicate values.

This question belongs to: Computer Microsoft Office

Question #18

Share Report

What is the maximum number of rows supported natively by an MS Excel worksheet worksheet file since Excel 2007 (.xlsx onwards)?

A. 16,384

B. 1,048,576

C. 524,288

D. 65,536

View Answer & Solution Discuss

Get Complete Subject PDF for Computer

Correct Answer: Option B

Explanation:
Modern versions of MS Excel support exactly 1,048,576 rows and 16,384 columns per worksheet.

This question belongs to: Computer Microsoft Office

Question #19

Share Report

In MS Word, which orientation format flips a document page layout horizontally, making it wider than it is tall?

A. Portrait

B. Landscape

C. Square

D. Vertical

View Answer & Solution Discuss

Get Complete Subject PDF for Computer

Correct Answer: Option B

Explanation:
Landscape orientation lays out a page wider than it is tall, whereas Portrait lays out a page taller than it is wide.

This question belongs to: Computer Microsoft Office

Question #20

Share Report

Which keyboard shortcut opens the 'Find and Replace' dialog box with the 'Replace' tab directly active in MS Word?

A. Ctrl + R

B. Ctrl + F

C. Ctrl + G

D. Ctrl + H

View Answer & Solution Discuss

Get Complete Subject PDF for Computer

Correct Answer: Option D

Explanation:
Ctrl + H opens the Find and Replace dialog box focusing immediately on the Replace tab. Ctrl + F launches the Navigation/Find pane.

This question belongs to: Computer Microsoft Office

Microsoft Office MCQs

Practice Questions

More Computer Topics