Microsoft Office MCQs

Computer

Microsoft Office MCQs

Practice MS Office MCQs covering MS Word, Excel, PowerPoint, Access, shortcut keys, formatting, formulas and presentations with answers and explanations.

1199
Total Questions

Practice Questions

Page 24 of 60
Question #461
In MS PowerPoint, what occurs if you select an item block and press the shortcut key combination Ctrl + Shift + C?
A. Clones the active slide canvas layout
B. Centers the text alignment within a container bounding box
C. Inserts a comment block on the active presentation slide
D. Copies the formatting and visual style properties of the selected object
Discuss
Get Complete Subject PDF for Computer

Correct Answer: Option D

Explanation:
Ctrl + Shift + C copies only the style formatting properties of a selected object or text block. Pressing Ctrl + Shift + V applies those copied styles to a new selection.
This question belongs to: Computer Microsoft Office
Question #462
Which of the following database tools in MS Access provides a user-friendly layout or digital form explicitly designed to view, input, or navigate individual data records?
A. Query matrix
B. Macro routine
C. Report
D. Form
Discuss
Get Complete Subject PDF for Computer

Correct Answer: Option D

Explanation:
Forms serve as user interface layouts that simplify data entry, record modification, and database navigation tasks for end-users.
This question belongs to: Computer Microsoft Office
Question #463
Which ribbon tab houses the tools for Mail Merge configuration, recipient list filtering, and form field mapping in MS Word?
A. Mailings Tab
B. Insert Tab
C. Review Tab
D. References Tab
Discuss
Get Complete Subject PDF for Computer

Correct Answer: Option A

Explanation:
The Mailings tab centralizes all tools needed to design, configure, execute, and preview Mail Merge automations and document labels.
This question belongs to: Computer Microsoft Office
Question #464
In MS Excel, what is the default keyboard shortcut used to insert a brand-new, empty chart sheet based on the currently highlighted data cells?
A. F2
B. Alt + F1
C. F11
D. F4
Discuss
Get Complete Subject PDF for Computer

Correct Answer: Option C

Explanation:
Pressing F11 creates a new, dedicated Chart Sheet containing a chart generated from the selected cell range. Alt + F1 inserts the chart on the current worksheet.
This question belongs to: Computer Microsoft Office
Question #465
Which view mode in MS PowerPoint displays all presentation slides as small thumbnails arranged in horizontal grids, which is ideal for reordering or deleting slides?
A. Slide Sorter View
B. Reading View interface
C. Presenter View Layout
D. Outline View
Discuss
Get Complete Subject PDF for Computer

Correct Answer: Option A

Explanation:
Slide Sorter View displays thumbnail versions of all slides in a grid, making it easy to reorder, delete, or organize slides into distinct sections.
This question belongs to: Computer Microsoft Office
Question #466
In MS Access, what type of query can combine fields from multiple tables by matching data across shared key rows, without altering the underlying raw data?
A. Update Query
B. Select Query
C. Append Query
D. Delete Query
Discuss
Get Complete Subject PDF for Computer

Correct Answer: Option B

Explanation:
A Select Query extracts and displays information from one or more tables based on user-defined criteria without modifying the source data records.
This question belongs to: Computer Microsoft Office
Question #467
What is the shortcut key sequence to center-align a paragraph block in MS Word?
A. Ctrl + C
B. Ctrl + J
C. Ctrl + Alt + C
D. Ctrl + E
Discuss
Get Complete Subject PDF for Computer

Correct Answer: Option D

Explanation:
Ctrl + E is the standard keyboard shortcut used to apply center alignment to text or paragraphs in MS Word.
This question belongs to: Computer Microsoft Office
Question #468
In MS Word, which of the following refers to a customizable toolbar that appears near the mouse cursor when text is selected, offering quick access to formatting options?
A. Status Ribbon Layout
B. Mini Toolbar
C. Quick Access Toolbar
D. Task Pane menu
Discuss
Get Complete Subject PDF for Computer

Correct Answer: Option B

Explanation:
The Mini Toolbar is a compact formatting popup that appears automatically near the cursor after a text selection, providing quick access to common styling options.
This question belongs to: Computer Microsoft Office
Question #469
What is the primary action performed by the shortcut key combination Ctrl + N when working inside MS PowerPoint?
A. Inserts a new slide into the active presentation file
B. Minimizes the current display window
C. Opens a brand-new, blank presentation file window
D. Launches the speaker notes view window
Discuss
Get Complete Subject PDF for Computer

Correct Answer: Option C

Explanation:
In MS PowerPoint, Ctrl + N opens a brand-new, blank presentation file. To insert a new slide into the current file, the shortcut is Ctrl + M.
This question belongs to: Computer Microsoft Office
Question #470
In MS Access, which relationship layout constraint ensures that records cannot be deleted from a parent table if matching child records exist in a linked table?
A. Data Validation constraints
B. Input Mask validation
C. Referential Integrity
D. Cascade Update property
Discuss
Get Complete Subject PDF for Computer

Correct Answer: Option C

Explanation:
Enforcing Referential Integrity ensures that relationships between tables stay consistent, preventing orphan records by blocking deletions in a parent table when linked child rows exist.
This question belongs to: Computer Microsoft Office
Question #471
What will be the output of the MS Excel formula =LARGE(A1:A4, 2) if cell records carry A1=10, A2=50, A3=30, and A4=40?
A. #VALUE!
B. 30
C. 50
D. 40
Discuss
Get Complete Subject PDF for Computer

Correct Answer: Option D

Explanation:
The LARGE function returns the k-th largest value in a dataset range. Sorting the range {10, 50, 30, 40} in descending order gives {50, 40, 30, 10}, where the 2nd largest value is 40.
This question belongs to: Computer Microsoft Office
Question #472
Which of the following indents adjusts the margin layout boundary of all lines inside a paragraph block except for the very first line in MS Word?
A. First Line Indent
B. Left Indent
C. Hanging Indent
D. Right Page Indent
Discuss
Get Complete Subject PDF for Computer

Correct Answer: Option C

Explanation:
A hanging indent keeps the first line of a paragraph at the default margin, while indenting all subsequent lines inward from the left boundary.
This question belongs to: Computer Microsoft Office
Question #473
What type of validation error code is returned by MS Excel if a cell formula uses an unrecognized function name, such as =SUUM(A1:A2)?
A. #REF!
B. #VALUE!
C. #NULL!
D. #NAME?
Discuss
Get Complete Subject PDF for Computer

Correct Answer: Option D

Explanation:
The #NAME? error occurs when Excel does not recognize text within a formula, which is typically caused by a misspelled function name or a missing quote around a text string.
This question belongs to: Computer Microsoft Office
Question #474
In MS PowerPoint, which tool allows you to pick specific slides from an active presentation and save them as an alternate sequence tailored to a particular audience?
A. Presenter View Setup
B. Slide Master Layout
C. Rehearsed Timings loop
D. Custom Slide Show
Discuss
Get Complete Subject PDF for Computer

Correct Answer: Option D

Explanation:
A Custom Slide Show lets presenters select specific slides from an existing presentation to create a tailored sequence without changing or splitting the main presentation file.
This question belongs to: Computer Microsoft Office
Question #475
Which field data type property in MS Access is ideal for fields that store long descriptions or logs that exceed 255 characters?
A. Short Text
B. Long Text
C. OLE Object Data Type
D. Hyperlink text block
Discuss
Get Complete Subject PDF for Computer

Correct Answer: Option B

Explanation:
In modern versions of MS Access, the 'Long Text' data type (previously known as Memo) stores up to 1 gigabyte of alphanumeric characters, whereas 'Short Text' is capped at 255 characters.
This question belongs to: Computer Microsoft Office
Question #476
What is the shortcut key sequence used to open the 'Find and Replace' dialog box with the 'Replace' tab directly active in MS Word?
A. Ctrl + H
B. Ctrl + F
C. Ctrl + R
D. Ctrl + G
Discuss
Get Complete Subject PDF for Computer

Correct Answer: Option A

Explanation:
Ctrl + H opens the Find and Replace dialog box with the Replace tab active. Ctrl + F opens the Find pane, and Ctrl + G opens the Go To tab.
This question belongs to: Computer Microsoft Office
Question #477
Which design master in MS PowerPoint controls the universal background themes, default font layouts, and placeholder grids for all slides in a presentation?
A. Notes Master
B. Design Ribbon View
C. Handout Master
D. Slide Master
Discuss
Get Complete Subject PDF for Computer

Correct Answer: Option D

Explanation:
The Slide Master is the foundational layout template in a presentation hierarchy. Editing the Slide Master automatically applies those design updates across all slides.
This question belongs to: Computer Microsoft Office
Question #478
In MS Word, what is the default line spacing configuration applied to a brand-new blank document based on the standard 'Normal.dotm' template in modern versions?
A. 1.15 lines
B. 1.5 lines
C. 1.0 lines
D. 2.0 lines
Discuss
Get Complete Subject PDF for Computer

Correct Answer: Option A

Explanation:
Modern versions of MS Word apply a default paragraph line spacing configuration of 1.15 lines, along with an 8-point spacing buffer after paragraphs.
This question belongs to: Computer Microsoft Office
Question #479
In MS Excel, which feature enables users to lock row or column headers in place so they stay visible on screen while scrolling through large datasets?
A. Freeze Panes
B. Cell Lock utility
C. Split Windows
D. Data Validation boundaries
Discuss
Get Complete Subject PDF for Computer

Correct Answer: Option A

Explanation:
The Freeze Panes tool locks selected rows or columns in place, keeping them visible on screen as you scroll through the rest of the worksheet.
This question belongs to: Computer Microsoft Office
Question #480
What is the keyboard shortcut to insert a hard page break at the cursor position in MS Word?
A. Ctrl + Shift + Enter
B. Alt + Enter
C. Shift + Enter
D. Ctrl + Enter
Discuss
Get Complete Subject PDF for Computer

Correct Answer: Option D

Explanation:
Ctrl + Enter inserts a manual page break at the cursor position, moving any trailing text to the top of the next page. Shift + Enter inserts a soft line break.
This question belongs to: Computer Microsoft Office

More Computer Topics

Computer Abbreviations MCQs
Computer Fundamentals MCQs
Computer Hardware MCQs
Computer Networking MCQs
Computer Software MCQs
CPU (Central Processing Unit) MCQs
Cyber Security MCQs
Database Management System (DBMS) MCQs
Internet and Web Technologies MCQs
Memory and Storage Devices MCQs
Operating Systems MCQs
Programming Languages MCQs
Today's Top Topics
Microsoft Office 1199 Computer Fundamentals 326 Internet and Web Technologies 461 CPU (Central Processing Unit) 327 Computer Hardware 430
Explore Subjects
Current Affairs 575 English 15164 Static General Knowledge 6362 History GK 3374 Reasoning 1111
Practice Mix
The Macaulay's Minute dealt with:
Which major port is located on the Malabar Coast?
A census provides data that is:
Which of the following is the primary reason for the high rainfall in Cherrapunji?
Choose the correct active voice of: 'Has the mail been sent by the secretary?'