MS Office MCQs with Answers and Explanations

Question #421

In MS Access, which join type in a Query design screen extracts all records from Table A and only those records from Table B that have matching key values?

A. Inner Join

B. Full Cross Join

C. Right Outer Join

D. Left Outer Join

View Answer & Solution Discuss

Get Complete Subject PDF for Computer

Correct Answer: Option D

Explanation:
A Left Outer Join includes all records from the left table (Table A) and matching rows from the right table (Table B). If no match exists, NULL values appear on the right side.

This question belongs to: Computer Microsoft Office

Question #422

Share Report

Which view mode in MS PowerPoint isolates text content exclusively into a nested tree structure on the left pane, allowing developers to manage slides purely by text flow?

A. Notes Page View

B. Outline View

C. Slide Sorter View

D. Reading View

View Answer & Solution Discuss

Get Complete Subject PDF for Computer

Correct Answer: Option B

Explanation:
Outline View displays only the titles and body text of the slides in an outline form, stripping away visual background graphics or image boxes for rapid textual organization.

This question belongs to: Computer Microsoft Office

Question #423

Share Report

In MS Word, the feature that automatically scales down a document layout to fit text precisely onto one less physical sheet if it overflows by just a few trailing lines is:

A. Shrink One Page

B. AutoFit Window

C. Compact Layout margins

D. Page Setup Optimizer

View Answer & Solution Discuss

Get Complete Subject PDF for Computer

Correct Answer: Option A

Explanation:
The 'Shrink One Page' (or Shrink to Fit) command decreases the size of text and margins slightly to fit the document's content onto one less page than it currently occupies.

This question belongs to: Computer Microsoft Office

Question #424

Share Report

Which chart type in MS Excel tracks distinct coordinates across two separate numeric axes ($X$ and $Y$) to evaluate correlation patterns between two variable data structures?

A. Area Chart

B. Scatter (XY) Chart

C. Radar Chart

D. Line Chart

View Answer & Solution Discuss

Get Complete Subject PDF for Computer

Correct Answer: Option B

Explanation:
A Scatter (XY) chart plots numeric values along horizontal ($X$) and vertical ($Y$) axes to visually expose mathematical relationships or scientific data correlations.

This question belongs to: Computer Microsoft Office

Question #425

Share Report

In MS PowerPoint, what occurs if you select an animation entry item in the Animation Pane and click 'Trigger'?

A. It forces the slide to move instantly to the next chronological presentation layout.

B. It records custom audio narratives over that design asset.

C. It associates the animation sequence to run only when a specific asset on the slide is clicked.

D. It maps the animation to run automatically inside an infinite timing loop.

View Answer & Solution Discuss

Get Complete Subject PDF for Computer

Correct Answer: Option C

Explanation:
An animation 'Trigger' sets a specific condition or click target on a slide, so the animation executes only when that specific object is selected by the user during a show.

This question belongs to: Computer Microsoft Office

Question #426

Share Report

What is the primary function of the built-in field property 'Validation Text' in an MS Access table designer screen?

A. It functions as a placeholder pattern to guide manual typists.

B. It sets the default value displayed inside the datasheet cell field.

C. It specifies the custom error message displayed to users when data violates a Validation Rule.

D. It defines the calculation rule used to verify alphanumeric formats.

View Answer & Solution Discuss

Get Complete Subject PDF for Computer

Correct Answer: Option C

Explanation:
Validation Text contains the custom error message that alerts users when an invalid entry violates the data constraints specified in the Validation Rule property.

This question belongs to: Computer Microsoft Office

Question #427

Share Report

What is the keyboard shortcut to apply a 1.5 line spacing format to a selected paragraph block in MS Word?

A. Ctrl + 2

B. Ctrl + 1

C. Ctrl + Shift + 5

D. Ctrl + 5

View Answer & Solution Discuss

Get Complete Subject PDF for Computer

Correct Answer: Option D

Explanation:
In MS Word, the paragraph spacing shortcuts are: Ctrl + 1 for single spacing, Ctrl + 2 for double spacing, and Ctrl + 5 for 1.5 line spacing.

This question belongs to: Computer Microsoft Office

Question #428

Share Report

Which native view layout option in MS Word strips out all pagination, margins, headers, and backgrounds, displaying text lines as a continuous flat page layout similar to a web browser window?

A. Print Layout View

B. Draft structural mode

C. Web Layout View

D. Read Mode view

View Answer & Solution Discuss

Get Complete Subject PDF for Computer

Correct Answer: Option C

Explanation:
Web Layout view wraps text lines to match the boundaries of the application window, hiding physical page breaks and structural margin configurations.

This question belongs to: Computer Microsoft Office

Question #429

Share Report

What error code is returned by an MS Excel cell formula if a required lookup value cannot be matched or found inside a VLOOKUP search block?

A. #REF!

B. #NAME?

C. #N/A

D. #VALUE!

View Answer & Solution Discuss

Get Complete Subject PDF for Computer

Correct Answer: Option C

Explanation:
The #N/A (Not Available) error occurs when a formula or function cannot locate the target data requested, such as an exact match lookup missing from a reference table.

This question belongs to: Computer Microsoft Office

Question #430

Share Report

In MS PowerPoint, what does the 'Morph' feature refer to?

A. An compression wizard that shrinks video dimensions down.

B. A specialized tool that automatically translates slide texts across different languages.

C. A drawing assistant that converts pen drawings into clean vector geometric layouts.

D. A slide transition effect that animates seamless movement of objects from one slide layout to the next.

View Answer & Solution Discuss

Get Complete Subject PDF for Computer

Correct Answer: Option D

Explanation:
Morph is a powerful transition effect that tracks objects across adjacent slides, smoothly transforming their size, position, orientation, or color to create a fluid animation.

This question belongs to: Computer Microsoft Office

Question #431

Share Report

Which of the following field types in MS Access supports linking external multimedia structures, files, or objects created in third-party software applications directly into a table row?

A. OLE Object

B. Hyperlink

C. Calculated field type

D. Attachment

View Answer & Solution Discuss

Get Complete Subject PDF for Computer

Correct Answer: Option A

Explanation:
OLE Object (Object Linking and Embedding) allows files like spreadsheets, images, sounds, or document structures created in external applications to be embedded inside Access databases.

This question belongs to: Computer Microsoft Office

Question #432

Share Report

What is the shortcut key sequence used to split an active document window view into two separate scrollable panes inside MS Word?

A. Alt + Shift + S

B. Ctrl + Shift + V

C. Alt + Ctrl + S

D. Ctrl + Split

View Answer & Solution Discuss

Get Complete Subject PDF for Computer

Correct Answer: Option C

Explanation:
Alt + Ctrl + S toggles a split window view in MS Word, allowing users to scroll and review two different parts of the same document simultaneously.

This question belongs to: Computer Microsoft Office

Question #433

Share Report

In MS Excel, what is the value returned if you run the formula =FLOOR.MATH(18.9, 5)?

A. 18

B. 20

C. 15

D. 19

View Answer & Solution Discuss

Get Complete Subject PDF for Computer

Correct Answer: Option C

Explanation:
The FLOOR.MATH function rounds a specified number downward to the nearest integer multiple of significance. The nearest multiple of 5 below 18.9 is 15.

This question belongs to: Computer Microsoft Office

Question #434

Share Report

Which layout master in MS PowerPoint is responsible for controlling the design properties, placeholder placements, header boundaries, and layout fields of printed slide notes sheets?

A. Slide Master

B. Presentation Blueprint Layout

C. Notes Master

D. Handout Master

View Answer & Solution Discuss

Get Complete Subject PDF for Computer

Correct Answer: Option C

Explanation:
The Notes Master governs the design format rules, font selections, and alignment grids applied to speaker notes pages when printed out.

This question belongs to: Computer Microsoft Office

Question #435

Share Report

Which component of an MS Access window workspace displays all available database objects like tables, queries, reports, and forms for double-click retrieval?

A. Properties Sheet window

B. Quick Access Panel

C. Status Ribbon bar

D. Navigation Pane

View Answer & Solution Discuss

Get Complete Subject PDF for Computer

Correct Answer: Option D

Explanation:
The Navigation Pane on the left side of the screen provides central access to open, edit, or delete any object within the database file.

This question belongs to: Computer Microsoft Office

Question #436

Share Report

What happens when you select text in MS Word and press the keyboard shortcut Ctrl + G?

A. Applies a green color highlight layer

B. Groups multiple paragraphs into a structural container block

C. Opens the 'Find and Replace' dialog box focusing directly on the 'Go To' tab

D. Launches the online research reference dictionary lookup helper

View Answer & Solution Discuss

Get Complete Subject PDF for Computer

Correct Answer: Option C

Explanation:
Ctrl + G (or F5) launches the Find and Replace window with the 'Go To' tab selected, which allows jumping to specific pages, sections, or line items.

This question belongs to: Computer Microsoft Office

Question #437

Share Report

In MS Excel, which of the following expressions is a valid syntax structure to calculate a logical conditional sum using multiple column criteria limits simultaneously?

A. =SUM.IF.MULTIPLE(Criteria_Range1, Criteria1, ...)

B. =SUMIF(Criteria_Range, Criteria, Sum_Range)

C. =MULTISUM(Sum_Range, Criteria_List)

D. =SUMIFS(Sum_Range, Criteria_Range1, Criteria1, Criteria_Range2, Criteria2)

View Answer & Solution Discuss

Get Complete Subject PDF for Computer

Correct Answer: Option D

Explanation:
The SUMIFS function evaluates multiple criteria fields. Its syntax differs from SUMIF because it places the 'Sum_Range' as the very first argument.

This question belongs to: Computer Microsoft Office

Question #438

Share Report

In MS PowerPoint, what is the default orientation applied to presentation slides upon initial file creation in modern 2026 software environments?

A. Square configuration matrix

B. A4 printable grid setup

C. Portrait (4:3 ratio standard format)

D. Landscape (16:9 widescreen format layout)

View Answer & Solution Discuss

Get Complete Subject PDF for Computer

Correct Answer: Option D

Explanation:
Modern versions of MS PowerPoint deploy Landscape orientation using a 16:9 widescreen aspect ratio layout as the default preset.

This question belongs to: Computer Microsoft Office

Question #439

Share Report

Which option under the MS Word table layout properties allows you to configure a row of text data cells to repeat across consecutive vertical sheets if a table splits?

A. AutoFit Row dimensions

B. Repeat Header Rows

C. Distribute Rows Uniformly

D. Keep Text Row Together

View Answer & Solution Discuss

Get Complete Subject PDF for Computer

Correct Answer: Option B

Explanation:
The 'Repeat Header Rows' feature under Table Tools automatically duplicates selected top header labels on every new page that the table spans.

This question belongs to: Computer Microsoft Office

Question #440

Share Report

What is the primary technical function of an 'Index' property within an MS Access database table field designer?

A. It links child fields to external web hyperlinks automatically.

B. It hides specified columns from being extracted by query layouts.

C. It converts plain text entries into encrypted binary string records.

D. It speeds up data searches and retrieval operations on that field while optionally preventing duplicate values.

View Answer & Solution Discuss

Get Complete Subject PDF for Computer

Correct Answer: Option D

Explanation:
Indexes optimize search efficiency and data sorting steps in a database field, though they can increase processing time slightly during record insertion updates.

This question belongs to: Computer Microsoft Office

Microsoft Office MCQs

Practice Questions

More Computer Topics