MS Office MCQs with Answers and Explanations

Question #521

In MS Word, the automated reference assistant feature that scans across an entire document to build a hyperlinked directory map of heading milestones is called:

A. Navigation Pane

B. Bookmark registry

C. Cross-reference guide

D. Smart Lookup framework

View Answer & Solution Discuss

Get Complete Subject PDF for Computer

Correct Answer: Option A

Explanation:
The Navigation Pane indexes document headings (formatted with Heading styles), creating an interactive, click-to-jump directory outline map on the left side of the screen.

This question belongs to: Computer Microsoft Office

Question #522

Share Report

What type of special validation error alert is thrown by MS Excel if a formula attempts to divide a numeric value by zero or references an unpopulated empty cell as a divisor?

A. #DIV/0!

B. #NUM!

C. #REF!

D. #VALUE!

View Answer & Solution Discuss

Get Complete Subject PDF for Computer

Correct Answer: Option A

Explanation:
The #DIV/0! error is thrown by Excel whenever a formula attempts to divide a number by zero or by a cell that contains no value.

This question belongs to: Computer Microsoft Office

Question #523

Share Report

What is the keyboard shortcut to extend a cell selection block from the active cursor position down to the very last populated cell in that column in MS Excel?

A. Ctrl + Shift + End

B. Shift + Page Down

C. Ctrl + Shift + Down Arrow

D. Alt + Shift + Down Arrow

View Answer & Solution Discuss

Get Complete Subject PDF for Computer

Correct Answer: Option C

Explanation:
Ctrl + Shift + Down Arrow extends the selection range down to the last non-blank cell in that column. Pressing Ctrl + Down Arrow jumps to that cell without selecting the range.

This question belongs to: Computer Microsoft Office

Question #524

Share Report

In MS PowerPoint, what occurs if you select an image asset or text box on a slide layout and press the keyboard shortcut Ctrl + Y?

A. Deletes the selected asset container block

B. Redoes or repeats the last formatting action that was reversed

C. Undoes the last layout adjustment step

D. Clones the active presentation slide

View Answer & Solution Discuss

Get Complete Subject PDF for Computer

Correct Answer: Option B

Explanation:
Ctrl + Y is the universal shortcut to Redo or repeat an action that was reversed via the Undo (Ctrl + Z) command.

This question belongs to: Computer Microsoft Office

Question #525

Share Report

Which property under an MS Access query design matrix allows database administrators to filter records to show only those matching a specific range, such as values between 100 and 500?

A. Criteria Row

B. Show checkbox parameter

C. Field Identifier alignment

D. Sort Row

View Answer & Solution Discuss

Get Complete Subject PDF for Computer

Correct Answer: Option A

Explanation:
The Criteria row in the Query Design grid is where you input logical expressions (such as 'Between 100 And 500') to filter the records extracted from the database.

This question belongs to: Computer Microsoft Office

Question #526

Share Report

What is the function of the keyboard shortcut Ctrl + M when working inside an active document in MS Word?

A. Applies a strikethrough character formatting layout

B. Opens the Mail Merge configuration helper pane

C. Indents the paragraph from the left margin boundary

D. Inserts a new manual page break line split

View Answer & Solution Discuss

Get Complete Subject PDF for Computer

Correct Answer: Option C

Explanation:
Ctrl + M increases the left indent of the selected paragraph, moving it inward from the margin. Pressing Ctrl + Shift + M removes or reduces the left indent.

This question belongs to: Computer Microsoft Office

Question #527

Share Report

What will be the output of the MS Excel formula =NETWORKDAYS(DATE(2026,6,15), DATE(2026,6,19)) if there are no holidays during this period?

A. #VALUE!

B. 5

C. 4

D. 3

View Answer & Solution Discuss

Get Complete Subject PDF for Computer

Correct Answer: Option B

Explanation:
The NETWORKDAYS function calculates the number of working days (Monday through Friday) between two dates, inclusive of both start and end dates. June 15, 2026 (Monday) to June 19, 2026 (Friday) is exactly 5 business days.

This question belongs to: Computer Microsoft Office

Question #528

Share Report

Which presentation view in MS PowerPoint is optimized to display speaker notes on a secondary screen while projecting clean slides to the audience?

A. Presenter View

B. Notes Page View Layout

C. Reading View optimization

D. Slide Sorter Interface

View Answer & Solution Discuss

Get Complete Subject PDF for Computer

Correct Answer: Option A

Explanation:
Presenter View provides a dedicated dual-screen layout that shows the current slide, upcoming thumbnails, speaker notes, and an active timer on the presenter's monitor while projecting only the slide artwork to the audience.

This question belongs to: Computer Microsoft Office

Question #529

Share Report

Which action query type in MS Access allows a database administrator to permanently remove a specific group of records from an underlying table based on criteria filters?

A. Make-Table Query

B. Update Query

C. Append Query

D. Delete Query

View Answer & Solution Discuss

Get Complete Subject PDF for Computer

Correct Answer: Option D

Explanation:
A Delete Query targets records that match specified criteria filters and permanently deletes those rows from the database table.

This question belongs to: Computer Microsoft Office

Question #530

Share Report

What is the maximum zoom scale percentage supported natively within the workspace window of Microsoft Excel?

A. 200%

B. 1000%

C. 400%

D. 500%

View Answer & Solution Discuss

Get Complete Subject PDF for Computer

Correct Answer: Option C

Explanation:
MS Excel and MS PowerPoint support a maximum zoom scale of 400%, while MS Word allows zooming up to 500%.

This question belongs to: Computer Microsoft Office

Question #531

Share Report

Which feature in MS Word allows users to create standardized form letters or labels by combining a master template document with an external address list database?

A. Mail Merge

B. Track Changes framework

C. Quick Parts automation

D. Style Separator compilation

View Answer & Solution Discuss

Get Complete Subject PDF for Computer

Correct Answer: Option A

Explanation:
Mail Merge is an automation tool that merges a standardized template document with an external data source (such as an Excel spreadsheet or Access table) to bulk-generate personalized mass mailings or labels.

This question belongs to: Computer Microsoft Office

Question #532

Share Report

In MS PowerPoint, what type of animation asset controls how an object behaves or changes its visual properties while remaining active on the slide canvas?

A. Motion Paths trajectory

B. Exit Effects track

C. Entrance Effects Layout

D. Emphasis Effects

View Answer & Solution Discuss

Get Complete Subject PDF for Computer

Correct Answer: Option D

Explanation:
Emphasis effects animate objects that are already on the slide (such as making them spin, pulse, or change color), whereas Entrance effects control how they arrive on the slide.

This question belongs to: Computer Microsoft Office

Question #533

Share Report

In MS Access, what field property rule can be used to set a static default value that automatically populates a field whenever a new record row is appended?

A. Input Mask editor

B. Validation Text

C. Format property configurations

D. Default Value

View Answer & Solution Discuss

Get Complete Subject PDF for Computer

Correct Answer: Option D

Explanation:
The Default Value property specifies a value that is automatically entered into a field whenever a new record is created, reducing manual entry for common values.

This question belongs to: Computer Microsoft Office

Question #534

Share Report

What is the function of the keyboard shortcut Ctrl + Shift + G when editing an active document layout in MS Word?

A. Inserts a automated hyperlink field

B. Converts selected lowercase text blocks to uppercase

C. Opens the Word Count summary dialog box

D. Activates the gridlines alignment layer

View Answer & Solution Discuss

Get Complete Subject PDF for Computer

Correct Answer: Option C

Explanation:
Ctrl + Shift + G directly opens the Word Count statistics dialog box, providing real-time data on pages, words, characters, paragraphs, and lines.

This question belongs to: Computer Microsoft Office

Question #535

Share Report

What will be the output of the MS Excel formula =MATCH(30, {10, 20, 30, 40}, 0)?

A. #N/A

B. 3

C. 30

D. 2

View Answer & Solution Discuss

Get Complete Subject PDF for Computer

Correct Answer: Option B

Explanation:
The MATCH function searches for a specified value in an array and returns its relative position. In the array {10, 20, 30, 40}, the lookup value 30 is at position 3.

This question belongs to: Computer Microsoft Office

Question #536

Share Report

Which of the following elements in an MS Word window status bar allows users to quickly change the workspace magnification scale?

A. The Zoom Slider

B. The Scroll Lock indicator bar

C. The Quick Access Toolbar commands

D. The Ribbon layout tabs

View Answer & Solution Discuss

Get Complete Subject PDF for Computer

Correct Answer: Option A

Explanation:
The Zoom Slider, located at the bottom-right corner of the Status Bar, allows users to increase or decrease the workspace magnification level quickly.

This question belongs to: Computer Microsoft Office

Question #537

Share Report

In MS PowerPoint, which tool allows authors to organize slides into logical grouped sections to easily manage large presentation decks?

A. Custom Slide Show layout

B. Add Section

C. Selection Pane grouping

D. Slide Master sections

View Answer & Solution Discuss

Get Complete Subject PDF for Computer

Correct Answer: Option B

Explanation:
The 'Add Section' command lets you group slides into distinct, named sections within the slide thumbnail list, which simplifies navigation and management of large decks.

This question belongs to: Computer Microsoft Office

Question #538

Share Report

In MS Access, what field property specifies that text inside a field should always be displayed in uppercase regardless of how it was typed?

A. Field Size constraint management

B. Validation Rule set to UPPER

C. Input Mask set to >

D. Format set to >

View Answer & Solution Discuss

Get Complete Subject PDF for Computer

Correct Answer: Option D

Explanation:
In the Format property of a text field, entering the greater-than symbol (>) forces Access to display all characters in uppercase, without altering the underlying raw data records.

This question belongs to: Computer Microsoft Office

Question #539

Share Report

What is the keyboard shortcut to left-align a selected block of text characters or an active paragraph in MS Word?

A. Ctrl + J

B. Ctrl + E

C. Ctrl + L

D. Ctrl + R

View Answer & Solution Discuss

Get Complete Subject PDF for Computer

Correct Answer: Option C

Explanation:
Ctrl + L is the standard keyboard shortcut used to apply left alignment to selected text or paragraphs in MS Word.

This question belongs to: Computer Microsoft Office

Question #540

Share Report

Which feature in MS PowerPoint allows you to pick an active application window on your desktop and insert a static snapshot image of it directly onto a slide?

A. Cameo live video stream

B. Screen Recording video

C. Screenshot

D. SmartArt graphic layout

View Answer & Solution Discuss

Get Complete Subject PDF for Computer

Correct Answer: Option C

Explanation:
The Screenshot tool captures a static image snapshot of any open window on your desktop and embeds it directly onto the active presentation slide.

This question belongs to: Computer Microsoft Office

Microsoft Office MCQs

Practice Questions

More Computer Topics