MS Office MCQs with Answers and Explanations

Question #441

Which keyboard shortcut allows an operator to insert an automatic line break inside an individual cell grid without moving the active cursor down into a new cell box in MS Excel?

A. Ctrl + Enter

B. Alt + Enter

C. Shift + Enter

D. Ctrl + Shift + Enter

View Answer & Solution Discuss

Get Complete Subject PDF for Computer

Correct Answer: Option B

Explanation:
Pressing Alt + Enter inserts a manual line break (starts a new line of text) inside the current cell, automatically enabling text wrapping.

This question belongs to: Computer Microsoft Office

Question #442

Share Report

In MS Word, which specific structural margin layout flips alternating side boundaries on odd and even pages so documents can be bound cleanly as a double-sided book format?

A. Mirror Margins

B. Book Fold Indents

C. Moderate Layout spacing

D. Normal Margins

View Answer & Solution Discuss

Get Complete Subject PDF for Computer

Correct Answer: Option A

Explanation:
Mirror Margins match the inside and outside margin sizes on facing pages, ensuring equal binding buffers when documents are printed back-to-back.

This question belongs to: Computer Microsoft Office

Question #443

Share Report

In MS PowerPoint, which tool captures precise rehearsed presentation loops, recording how long slides run to help automate slide presentation delivery timelines?

A. Rehearse Timings

B. Animation Painter tool

C. Presenter Coach dashboard

D. Slide Sorter setup

View Answer & Solution Discuss

Get Complete Subject PDF for Computer

Correct Answer: Option A

Explanation:
The Rehearse Timings feature launches full-screen slide delivery with an on-screen timer to track slide durations, saving those timestamps to automate future playback.

This question belongs to: Computer Microsoft Office

Question #444

Share Report

Which data type field property option in MS Access lets you create a drop-down choice list that pulls options either from an existing table source or a hardcoded value set?

A. Attachment properties

B. Lookup Wizard

C. Hyperlink Field Type

D. Calculated Field choice

View Answer & Solution Discuss

Get Complete Subject PDF for Computer

Correct Answer: Option B

Explanation:
The Lookup Wizard establishes a lookup field that displays a clean dropdown list of choices derived dynamically from another database table reference or static list parameter.

This question belongs to: Computer Microsoft Office

Question #445

Share Report

What is the keyboard shortcut to right-align text inside an active cell or text line in MS Word?

A. Ctrl + E

B. Ctrl + R

C. Ctrl + J

D. Ctrl + L

View Answer & Solution Discuss

Get Complete Subject PDF for Computer

Correct Answer: Option B

Explanation:
Ctrl + R is the universal shortcut to right-align selected text, paragraphs, or active layout structures flush against the right margin in MS Word.

This question belongs to: Computer Microsoft Office

Question #446

Share Report

In MS PowerPoint, which keyboard combination can be pressed to instantly clone or duplicate any selected asset, drawing, or slide layout block?

A. Alt + D

B. Ctrl + Shift + C

C. Ctrl + C

D. Ctrl + D

View Answer & Solution Discuss

Get Complete Subject PDF for Computer

Correct Answer: Option D

Explanation:
Ctrl + D functions as a rapid shortcut to duplicate a selected object, text container, shape, or slide layout instantly within PowerPoint without using separate copy and paste commands.

This question belongs to: Computer Microsoft Office

Question #447

Share Report

Which section reference indicator in MS Word is placed at the absolute trailing end of an entire document file to compile long-form reference bibliography source origins?

A. Header line text

B. Footnote

C. Caption citation

D. Endnote

View Answer & Solution Discuss

Get Complete Subject PDF for Computer

Correct Answer: Option D

Explanation:
Endnotes compile at the very end of a document or section block to document source citations. Footnotes appear at the bottom margin of the page where the reference was cited.

This question belongs to: Computer Microsoft Office

Question #448

Share Report

In MS Access, what field property constraint must be deployed to guarantee that an auto-incremented database table row cannot hold duplicate records?

A. Input Mask application

B. Validation Rule mapping

C. Required set to 'No'

D. Indexed set to 'Yes (No Duplicates)'

View Answer & Solution Discuss

Get Complete Subject PDF for Computer

Correct Answer: Option D

Explanation:
Setting the Indexed property to 'Yes (No Duplicates)' establishes a unique constraint rule index that prevents identical values from being entered into that field.

This question belongs to: Computer Microsoft Office

Question #449

Share Report

What will be the output of the MS Excel formula =COUNTIF(A1:A4, >10) if cell entries are A1=5, A2=10, A3=15, and A4=20?

A. 3

B. 1

C. 4

D. 2

View Answer & Solution Discuss

Get Complete Subject PDF for Computer

Correct Answer: Option D

Explanation:
The formula filters for numbers strictly greater than 10. Out of the given values, 15 and 20 satisfy the condition, so the function returns 2.

This question belongs to: Computer Microsoft Office

Question #450

Share Report

Which of the following describes the behavior of a 'Hanging Indent' applied to a paragraph block layout in MS Word?

A. Both the left and right margins are squeezed equally inward towards the center point.

B. The first line aligns flush with the left page margin, while all subsequent lines are set inward.

C. The first line is set inward, while all trailing text lines align flush with the left page margin.

D. Text elements are spaced to align cleanly with the right side of the page.

View Answer & Solution Discuss

Get Complete Subject PDF for Computer

Correct Answer: Option B

Explanation:
A hanging indent keeps the first line of a paragraph at the margin, while indenting all subsequent lines inward. This layout is commonly used for bibliographies and reference lists.

This question belongs to: Computer Microsoft Office

Question #451

Share Report

What type of special validation error alert is thrown by MS Excel if a formula includes an invalid numeric argument or out-of-bounds parameter, such as finding the square root of a negative number via =SQRT(-9)?

A. #NUM!

B. #NAME?

C. #DIV/0!

D. #VALUE!

View Answer & Solution Discuss

Get Complete Subject PDF for Computer

Correct Answer: Option A

Explanation:
The #NUM! error indicates a problem with a number in a formula, such as an argument that falls outside a function's supported domain (e.g., performing a square root on a negative number).

This question belongs to: Computer Microsoft Office

Question #452

Share Report

In MS PowerPoint, what key should a presenter hold down while using the pen tool during a live show to draw rigid horizontal or vertical annotation lines?

A. Ctrl

B. Shift

C. Tab

D. Alt

View Answer & Solution Discuss

Get Complete Subject PDF for Computer

Correct Answer: Option B

Explanation:
Holding the Shift key during a presentation slide delivery locks the integrated pen tool tracking into perfect horizontal or vertical lines.

This question belongs to: Computer Microsoft Office

Question #453

Share Report

Which action query type in MS Access copies selected data rows from one or more existing source tables and creates a brand-new table with those records?

A. Update Query

B. Append Query

C. Crosstab Query

D. Make-Table Query

View Answer & Solution Discuss

Get Complete Subject PDF for Computer

Correct Answer: Option D

Explanation:
A Make-Table Query extracts specific records from existing source fields and uses them to create a brand-new table in the database file.

This question belongs to: Computer Microsoft Office

Question #454

Share Report

What is the function of the keyboard shortcut Ctrl + Backspace when editing a document in MS Word?

A. Deletes the entire word immediately to the left of the cursor

B. Deletes the entire active row block layout

C. Deletes the single character immediately to the left of the cursor

D. Clears all clipboard memories

View Answer & Solution Discuss

Get Complete Subject PDF for Computer

Correct Answer: Option A

Explanation:
While Backspace removes text character-by-character, pressing Ctrl + Backspace deletes the entire word to the left of the cursor position.

This question belongs to: Computer Microsoft Office

Question #455

Share Report

Which of the following function syntaxes is correct in MS Excel to extract the current system date alone, without any time stamps?

A. =CURRENTDATE()

B. =DATEVALUE(NOW)

C. =NOW()

D. =TODAY()

View Answer & Solution Discuss

Get Complete Subject PDF for Computer

Correct Answer: Option D

Explanation:
=TODAY() returns the current system date as a serial number date format without any time data, whereas =NOW() returns both the current date and time.

This question belongs to: Computer Microsoft Office

Question #456

Share Report

In MS PowerPoint, which tool allows an author to capture formatting configurations, borders, and effects from an image and apply those same properties to another image asset?

A. Theme Styles manager

B. Design Master

C. Format Painter

D. Animation Painter

View Answer & Solution Discuss

Get Complete Subject PDF for Computer

Correct Answer: Option C

Explanation:
The Format Painter tool copies visual style formatting (such as borders, shadows, and fills) from a selected object and applies it to another asset with a single click.

This question belongs to: Computer Microsoft Office

Question #457

Share Report

What is the native file extension format for database files saved in modern editions of Microsoft Access?

A. .accdb

B. .accde

C. .dbf

D. .mdb

View Answer & Solution Discuss

Get Complete Subject PDF for Computer

Correct Answer: Option A

Explanation:
.accdb is the standard native database file extension for MS Access files since the 2007 version, replacing the legacy .mdb format.

This question belongs to: Computer Microsoft Office

Question #458

Share Report

What is the function of the keyboard shortcut Ctrl + F2 across Microsoft Word and Excel applications?

A. Launches the automated spelling check wizard

B. Opens the Save As file dialog menu window

C. Displays the Print Preview layout tab screen

D. Minimizes the core active parent window application

View Answer & Solution Discuss

Get Complete Subject PDF for Computer

Correct Answer: Option C

Explanation:
Ctrl + F2 is the traditional keyboard shortcut to launch the Print Preview screen, allowing users to check document layouts before physical printing.

This question belongs to: Computer Microsoft Office

Question #459

Share Report

In MS Excel, what is the value returned by the formula =MID(COMPETITIVE, 4, 3)?

A. PETI

B. COMP

C. ETI

D. PET

View Answer & Solution Discuss

Get Complete Subject PDF for Computer

Correct Answer: Option D

Explanation:
The MID function extracts characters from the middle of a text string. Starting at position 4 of COMPETITIVE ('P') and extracting 3 characters yields PET.

This question belongs to: Computer Microsoft Office

Question #460

Share Report

Which feature in MS Word tracks edits, deletions, insertions, and formatting adjustments made to a shared document by multiple collaborators?

A. Compare Documents wizard

B. Smart Lookup monitoring

C. Track Changes

D. AutoCorrect registry

View Answer & Solution Discuss

Get Complete Subject PDF for Computer

Correct Answer: Option C

Explanation:
Track Changes logs every modification made to a document, allowing authors to review, accept, or reject specific edits later.

This question belongs to: Computer Microsoft Office

Microsoft Office MCQs

Practice Questions

More Computer Topics