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 26 of 60
Question #501
Which tab on the main MS Word ribbon houses the commands to build an automatic Table of Contents, manage citations, and insert a bibliography?
A. Review Tab
B. References Tab
C. Design Tab
D. Insert Tab
Discuss
Get Complete Subject PDF for Computer

Correct Answer: Option B

Explanation:
The References tab centralizes all academic document tools, including table of contents builders, footnote managers, and index compilation utilities.
This question belongs to: Computer Microsoft Office
Question #502
In MS PowerPoint, what is the default keyboard shortcut used to insert a brand-new, blank slide into the active presentation file?
A. Ctrl + Shift + N
B. Ctrl + M
C. Ctrl + S
D. Ctrl + N
Discuss
Get Complete Subject PDF for Computer

Correct Answer: Option B

Explanation:
Ctrl + M inserts a new slide into the active presentation file. Ctrl + N opens a brand-new, blank presentation file window.
This question belongs to: Computer Microsoft Office
Question #503
What is the keyboard shortcut to double-underline a highlighted block of text characters in MS Word?
A. Ctrl + Shift + D
B. Alt + Shift + D
C. Ctrl + Shift + U
D. Ctrl + U
Discuss
Get Complete Subject PDF for Computer

Correct Answer: Option A

Explanation:
Ctrl + Shift + D applies double-underline formatting to the selected text. Ctrl + U applies a standard single underline.
This question belongs to: Computer Microsoft Office
Question #504
In MS Excel, what type of cell reference style is used when a formula contains a cell formatted as $C$5?
A. Relative Cell Reference
B. External sheet reference link
C. Mixed Cell Reference
D. Absolute Cell Reference
Discuss
Get Complete Subject PDF for Computer

Correct Answer: Option D

Explanation:
An absolute cell reference locks both the column letter and the row number with dollar signs ($C$5), ensuring that the reference does not change when the formula is copied to another cell.
This question belongs to: Computer Microsoft Office
Question #505
Which option under the MS PowerPoint Slide Show tab allows a presenter to configure presentation screens to run continuously in an automated loop at a public kiosk?
A. Custom Slide Show
B. Rehearse Timings tool
C. Presenter View properties
D. Set Up Slide Show
Discuss
Get Complete Subject PDF for Computer

Correct Answer: Option D

Explanation:
The 'Set Up Slide Show' dialog box contains configuration options to set the presentation type to 'Browsed at a kiosk (full screen)', which runs the slide show in a continuous loop until Esc is pressed.
This question belongs to: Computer Microsoft Office
Question #506
In MS Access, what field property constraint must be activated to ensure that users cannot leave a specific field blank when entering a new data record?
A. Required
B. Indexed field size
C. Validation Rule
D. Input Mask properties
Discuss
Get Complete Subject PDF for Computer

Correct Answer: Option A

Explanation:
Setting the 'Required' field property to 'Yes' enforces a data validation constraint that prevents a record from being saved if that specific field is left blank or null.
This question belongs to: Computer Microsoft Office
Question #507
What is the function of the keyboard shortcut Ctrl + K across Microsoft Word, Excel, and PowerPoint applications?
A. Launches the spell checker tool
B. Deletes the selected paragraph line block
C. Opens the Insert Hyperlink dialog box window
D. Applies an italic style formatting layer
Discuss
Get Complete Subject PDF for Computer

Correct Answer: Option C

Explanation:
Ctrl + K is the standard keyboard shortcut used to open the Insert Hyperlink dialog box across Microsoft Office applications, allowing users to link to files or web pages.
This question belongs to: Computer Microsoft Office
Question #508
In MS Word, what type of section break moves the section split marker onto the next page layout boundary, forcing new text onto a new sheet?
A. Even Page Section Split
B. Column Page Break Layout
C. Continuous Section Break
D. Next Page Section Break
Discuss
Get Complete Subject PDF for Computer

Correct Answer: Option D

Explanation:
A 'Next Page' section break starts the new section on the following page, while a 'Continuous' section break starts the new section on the same page.
This question belongs to: Computer Microsoft Office
Question #509
Which of the following built-in tools in MS Excel allows users to apply conditional color fills, data bars, or icons to cells based on the numerical values they hold?
A. Conditional Formatting
B. AutoFormat wizard
C. Format Painter tool
D. Cell Styles manager
Discuss
Get Complete Subject PDF for Computer

Correct Answer: Option A

Explanation:
Conditional Formatting changes the visual presentation of cells (such as fill color, border styles, or icon sets) dynamically based on user-defined logical rules or values.
This question belongs to: Computer Microsoft Office
Question #510
In MS PowerPoint, what is the default keyboard shortcut used to start a presentation slide show directly from the currently active slide instead of the beginning?
A. Alt + F5
B. Shift + F5
C. F5
D. Ctrl + F5
Discuss
Get Complete Subject PDF for Computer

Correct Answer: Option B

Explanation:
Shift + F5 launches the slide show from the currently active slide. Pressing F5 launches the presentation from the very first slide.
This question belongs to: Computer Microsoft Office
Question #511
Which object query language is natively used behind the graphical interface layout to filter and extract records in MS Access tables?
A. HyperText Markup Language (HTML)
B. Extensible Markup Language (XML)
C. Structured Query Language (SQL)
D. Unified Modeling Language (UML)
Discuss
Get Complete Subject PDF for Computer

Correct Answer: Option C

Explanation:
MS Access uses SQL (Structured Query Language) behind its graphical Query Design view to communicate with, query, and manipulate relational databases.
This question belongs to: Computer Microsoft Office
Question #512
What is the function of the keyboard shortcut Ctrl + Equal Sign (=) when a block of text characters is highlighted in MS Word?
A. Applies a subscript text formatting layer
B. Applies a superscript text formatting layer
C. Inserts an automated calculation formula field
D. Resets the font size to the default preset sizing
Discuss
Get Complete Subject PDF for Computer

Correct Answer: Option A

Explanation:
Ctrl + Equal Sign (=) applies subscript formatting to the selected text, lowering it below the baseline. Ctrl + Shift + Plus Sign (+) applies superscript formatting.
This question belongs to: Computer Microsoft Office
Question #513
What will be the output of the MS Excel formula =CEILING.MATH(22.1, 5)?
A. 30
B. 22
C. 20
D. 25
Discuss
Get Complete Subject PDF for Computer

Correct Answer: Option D

Explanation:
The CEILING.MATH function rounds a specified number upward to the nearest integer multiple of significance. The nearest multiple of 5 greater than or equal to 22.1 is 25.
This question belongs to: Computer Microsoft Office
Question #514
In MS PowerPoint, what are the motion pathways that dictate how an object changes its physical position on a slide canvas during an animation timeline?
A. Transition Tracks
B. Motion Paths
C. Emphasis Animations
D. Entrance Effects Layout
Discuss
Get Complete Subject PDF for Computer

Correct Answer: Option B

Explanation:
Motion Paths allow design assets to animate along custom curved tracks, lines, or geometric paths across the slide canvas area.
This question belongs to: Computer Microsoft Office
Question #515
Which reference citation indexing tool in MS Word displays short, descriptive identifier labels immediately below table objects or image figures?
A. Footnote
B. Endnote summary
C. Bibliography list
D. Caption
Discuss
Get Complete Subject PDF for Computer

Correct Answer: Option D

Explanation:
The 'Insert Caption' tool generates numbered reference titles (such as 'Figure 1' or 'Table A') directly below or above graphic assets or tables.
This question belongs to: Computer Microsoft Office
Question #516
In MS Excel, what does the error code '#NULL!' indicate?
A. A function name contains a typographical misspelling mistake.
B. A formula attempts to divide a numeric value by an empty cell row.
C. A required lookup key value cannot be located inside a range array.
D. A formula specifies an intersection of two cell ranges that do not intersect.
Discuss
Get Complete Subject PDF for Computer

Correct Answer: Option D

Explanation:
The #NULL! error occurs when a space operator is used between two ranges that do not intersect, such as evaluating =SUM(A1:A2 B1:B2) instead of using a comma operator.
This question belongs to: Computer Microsoft Office
Question #517
What is the function of the keyboard shortcut Ctrl + W across Microsoft Office applications like Word and Excel?
A. Exits the entire parent software application system
B. Launches the web browser lookup helper tool
C. Closes the currently active document or workbook window
D. Saves the file and opens a blank document layout
Discuss
Get Complete Subject PDF for Computer

Correct Answer: Option C

Explanation:
Ctrl + W closes the currently active file, document, or workbook window without closing the main parent application shell. Alt + F4 exits the entire application.
This question belongs to: Computer Microsoft Office
Question #518
Which pane in MS PowerPoint allows authors to manage the playback sequence, timings, delays, and trigger rules of individual slide animations?
A. Transition Configuration panel
B. Animation Pane
C. Selection Pane
D. Format Background properties sheet
Discuss
Get Complete Subject PDF for Computer

Correct Answer: Option B

Explanation:
The Animation Pane opens on the right side of the workspace, providing a timeline layout to view, reorder, adjust timings, and configure triggers for all animations on the slide.
This question belongs to: Computer Microsoft Office
Question #519
In MS Access, what type of table relationship layout is formed when a single record in Table A matches multiple records in Table B, but a record in Table B matches only one record in Table A?
A. One-to-Many Relationship
B. Many-to-Many Relationship
C. One-to-One Relationship
D. Self-Referential database link
Discuss
Get Complete Subject PDF for Computer

Correct Answer: Option A

Explanation:
A One-to-Many relationship is the most common relationship type in relational databases, where a primary key record in one table links to multiple foreign key records in another table.
This question belongs to: Computer Microsoft Office
Question #520
What is the keyboard shortcut to apply a hanging indent to a selected paragraph block in MS Word?
A. Ctrl + H
B. Ctrl + Shift + H
C. Ctrl + T
D. Ctrl + M
Discuss
Get Complete Subject PDF for Computer

Correct Answer: Option C

Explanation:
Ctrl + T applies a hanging indent to the selected paragraph. Pressing Ctrl + Shift + T removes or reduces the hanging indent. Ctrl + M applies a standard left indent.
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?'