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 22 of 60
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. Right Outer Join
B. Left Outer Join
C. Inner Join
D. Full Cross Join
Discuss
Get Complete Subject PDF for Computer

Correct Answer: Option B

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
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. Outline View
B. Notes Page View
C. Slide Sorter View
D. Reading View
Discuss
Get Complete Subject PDF for Computer

Correct Answer: Option A

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
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. Page Setup Optimizer
B. Shrink One Page
C. Compact Layout margins
D. AutoFit Window
Discuss
Get Complete Subject PDF for Computer

Correct Answer: Option B

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
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. Radar Chart
B. Area Chart
C. Line Chart
D. Scatter (XY) Chart
Discuss
Get Complete Subject PDF for Computer

Correct Answer: Option D

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
In MS PowerPoint, what occurs if you select an animation entry item in the Animation Pane and click 'Trigger'?
A. It maps the animation to run automatically inside an infinite timing loop.
B. It forces the slide to move instantly to the next chronological presentation layout.
C. It associates the animation sequence to run only when a specific asset on the slide is clicked.
D. It records custom audio narratives over that design asset.
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
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 specifies the custom error message displayed to users when data violates a Validation Rule.
C. It defines the calculation rule used to verify alphanumeric formats.
D. It sets the default value displayed inside the datasheet cell field.
Discuss
Get Complete Subject PDF for Computer

Correct Answer: Option B

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
What is the keyboard shortcut to apply a 1.5 line spacing format to a selected paragraph block in MS Word?
A. Ctrl + Shift + 5
B. Ctrl + 5
C. Ctrl + 1
D. Ctrl + 2
Discuss
Get Complete Subject PDF for Computer

Correct Answer: Option B

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
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. Read Mode view
B. Web Layout View
C. Draft structural mode
D. Print Layout View
Discuss
Get Complete Subject PDF for Computer

Correct Answer: Option B

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
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. #VALUE!
B. #REF!
C. #N/A
D. #NAME?
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
In MS PowerPoint, what does the 'Morph' feature refer to?
A. A drawing assistant that converts pen drawings into clean vector geometric layouts.
B. A specialized tool that automatically translates slide texts across different languages.
C. A slide transition effect that animates seamless movement of objects from one slide layout to the next.
D. An compression wizard that shrinks video dimensions down.
Discuss
Get Complete Subject PDF for Computer

Correct Answer: Option C

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
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. Attachment
B. OLE Object
C. Hyperlink
D. Calculated field type
Discuss
Get Complete Subject PDF for Computer

Correct Answer: Option B

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
What is the shortcut key sequence used to split an active document window view into two separate scrollable panes inside MS Word?
A. Ctrl + Shift + V
B. Alt + Shift + S
C. Ctrl + Split
D. Alt + Ctrl + S
Discuss
Get Complete Subject PDF for Computer

Correct Answer: Option D

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
In MS Excel, what is the value returned if you run the formula =FLOOR.MATH(18.9, 5)?
A. 15
B. 20
C. 19
D. 18
Discuss
Get Complete Subject PDF for Computer

Correct Answer: Option A

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
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. Notes Master
C. Presentation Blueprint Layout
D. Handout Master
Discuss
Get Complete Subject PDF for Computer

Correct Answer: Option B

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
Which component of an MS Access window workspace displays all available database objects like tables, queries, reports, and forms for double-click retrieval?
A. Quick Access Panel
B. Properties Sheet window
C. Navigation Pane
D. Status Ribbon bar
Discuss
Get Complete Subject PDF for Computer

Correct Answer: Option C

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
What happens when you select text in MS Word and press the keyboard shortcut Ctrl + G?
A. Groups multiple paragraphs into a structural container block
B. Launches the online research reference dictionary lookup helper
C. Opens the 'Find and Replace' dialog box focusing directly on the 'Go To' tab
D. Applies a green color highlight layer
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
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. =SUMIF(Criteria_Range, Criteria, Sum_Range)
B. =SUM.IF.MULTIPLE(Criteria_Range1, Criteria1, ...)
C. =SUMIFS(Sum_Range, Criteria_Range1, Criteria1, Criteria_Range2, Criteria2)
D. =MULTISUM(Sum_Range, Criteria_List)
Discuss
Get Complete Subject PDF for Computer

Correct Answer: Option C

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
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. Landscape (16:9 widescreen format layout)
C. Portrait (4:3 ratio standard format)
D. A4 printable grid setup
Discuss
Get Complete Subject PDF for Computer

Correct Answer: Option B

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
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. Repeat Header Rows
B. AutoFit Row dimensions
C. Distribute Rows Uniformly
D. Keep Text Row Together
Discuss
Get Complete Subject PDF for Computer

Correct Answer: Option A

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
What is the primary technical function of an 'Index' property within an MS Access database table field designer?
A. It hides specified columns from being extracted by query layouts.
B. It links child fields to external web hyperlinks automatically.
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.
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

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
Computer Hardware 430 Operating Systems 510 Programming Languages 0 Cyber Security 269 Database Management System (DBMS) 278
Explore Subjects
Reasoning 2064 Science 4430 Accountancy and Statistics 3179 Economy GK 2220 Computer 5279
Practice Mix
Which national park in Himachal Pradesh is known for its high-altitude grasslands and is a key habitat for the Himalayan Tahr?
Who was the first Indian to be the Coordination Secretary?
Which of the following is an example of an animal cell that lacks a nucleus in its mature form?
What is the primary limitation of configuring a network using a point-to-point Full Mesh Topology as the number of nodes scales high?
Double fertilization in angiosperms was discovered by: