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 25 of 60
Question #481
Which function in MS Excel calculates the number of cells within a specified range that contain any type of information, including text, errors, or numeric digits?
A. COUNT
B. COUNTIF
C. COUNTA
D. COUNTBLANK
Discuss
Get Complete Subject PDF for Computer

Correct Answer: Option C

Explanation:
The COUNTA function counts all non-empty cells within a range, regardless of whether they contain numbers, text, or errors. The COUNT function counts cells with numbers only.
This question belongs to: Computer Microsoft Office
Question #482
In MS PowerPoint, what type of cinematic visual effect occurs when transitioning from one slide display layout to another during a slide show?
A. Motion Path animation
B. Slide Transition
C. Animation Effect
D. Emphasis Effect Layout
Discuss
Get Complete Subject PDF for Computer

Correct Answer: Option B

Explanation:
Slide Transitions are the motion effects that play when you move from one slide to another during a presentation. Animations control the movement of individual objects on a single slide.
This question belongs to: Computer Microsoft Office
Question #483
Which component of an MS Access window layout allows database administrators to define specific rules that prevent invalid entries before records are saved?
A. Validation Rule
B. Format properties sheet
C. Default Value mapping
D. Input Mask editor
Discuss
Get Complete Subject PDF for Computer

Correct Answer: Option A

Explanation:
The Validation Rule property evaluates data entries against specified criteria constraints, blocking invalid inputs before they are saved to the database table.
This question belongs to: Computer Microsoft Office
Question #484
What is the function of the shortcut key combination Ctrl + Spacebar when text is highlighted in MS Word?
A. Highlights the entire document page layout
B. Applies double line spacing to the paragraph
C. Inserts a non-breaking space character
D. Clears all manual character formatting from the selected text
Discuss
Get Complete Subject PDF for Computer

Correct Answer: Option D

Explanation:
Ctrl + Spacebar removes all manual character-level formatting (such as bold, italic, or custom font colors) from the selected text, resetting it to the default style.
This question belongs to: Computer Microsoft Office
Question #485
What will be the output of the MS Excel formula =MOD(17, 5)?
A. #VALUE!
B. 1
C. 3
D. 2
Discuss
Get Complete Subject PDF for Computer

Correct Answer: Option D

Explanation:
The MOD function returns the remainder after division. 17 divided by 5 is 3 with a remainder of 2, so the function returns 2.
This question belongs to: Computer Microsoft Office
Question #486
Which view mode in MS Word displays a document exactly as it will appear on physical printed sheets, showing headers, margins, and page boundaries?
A. Print Layout View
B. Draft View
C. Outline View
D. Web Layout View
Discuss
Get Complete Subject PDF for Computer

Correct Answer: Option A

Explanation:
Print Layout view is the default workspace view in MS Word. It displays the document layout exactly as it will appear when printed on paper.
This question belongs to: Computer Microsoft Office
Question #487
In MS PowerPoint, what is the default keyboard shortcut used to launch a full-screen slide show presentation starting from the very first slide?
A. Ctrl + F5
B. F1
C. Shift + F5
D. F5
Discuss
Get Complete Subject PDF for Computer

Correct Answer: Option D

Explanation:
The F5 key launches the slide show from the first slide. Pressing Shift + F5 launches the slide show from the currently active slide.
This question belongs to: Computer Microsoft Office
Question #488
Which of the following database tools in MS Access is designed to summarize, group, and format table information for clear paper printing or digital distribution?
A. Report
B. Form
C. Query setup
D. Macro asset
Discuss
Get Complete Subject PDF for Computer

Correct Answer: Option A

Explanation:
Reports are specialized database objects used to organize, summarize, and format data from tables or queries for printing or professional distribution.
This question belongs to: Computer Microsoft Office
Question #489
In MS Word, what does the 'Gutter Margin' property refer to?
A. The extra margin space added to the binding side of a document to prevent text coverage during binding.
B. The bottom layout margin reserved for footnote entries.
C. The empty space located at the outer margins of headers.
D. The vertical spacing buffer separating two columns of text data.
Discuss
Get Complete Subject PDF for Computer

Correct Answer: Option A

Explanation:
A gutter margin adds extra space to the side or top margin of a document intended for binding, ensuring that text remains fully visible and readable after the document is bound.
This question belongs to: Computer Microsoft Office
Question #490
What is the native file extension format for workbook files saved in modern versions of Microsoft Excel?
A. .xls
B. .xlsx
C. .xlsm
D. .xltx
Discuss
Get Complete Subject PDF for Computer

Correct Answer: Option B

Explanation:
.xlsx is the standard, macro-free XML-based file extension format for MS Excel workbooks since the 2007 version.
This question belongs to: Computer Microsoft Office
Question #491
In MS PowerPoint, which tool allows an author to copy an animation sequence from one design asset and apply it to another object with a single click?
A. Transition Manager properties
B. Trigger configuration
C. Format Painter
D. Animation Painter
Discuss
Get Complete Subject PDF for Computer

Correct Answer: Option D

Explanation:
The Animation Painter tool copies animation effects from a selected object and applies them to another target object, streamlining the design process.
This question belongs to: Computer Microsoft Office
Question #492
Which field property in an MS Access table designer window enforces a specific data entry pattern that users must follow, such as standard phone number formats?
A. Validation Rule
B. Input Mask
C. Format constraint
D. Required field size
Discuss
Get Complete Subject PDF for Computer

Correct Answer: Option B

Explanation:
An Input Mask defines a strict formatting pattern constraint (such as placeholders for phone numbers or postal codes) that guides users during manual data entry.
This question belongs to: Computer Microsoft Office
Question #493
What is the keyboard shortcut to open the Navigation Pane or Find tool in modern versions of MS Word?
A. Ctrl + H
B. Ctrl + F
C. Ctrl + N
D. Ctrl + G
Discuss
Get Complete Subject PDF for Computer

Correct Answer: Option B

Explanation:
Ctrl + F opens the Navigation Pane on the left side of the screen, allowing users to search for text, headings, or pages within the document.
This question belongs to: Computer Microsoft Office
Question #494
Which of the following utility options under the MS Excel Data tab allows developers to split a single column of text data into multiple columns using a delimiter like a comma?
A. Flash Fill
B. Data Validation wizard
C. Text to Columns
D. Consolidate tool
Discuss
Get Complete Subject PDF for Computer

Correct Answer: Option C

Explanation:
The 'Text to Columns' wizard splits text strings from a single cell across multiple columns based on a specified delimiter (such as a tab, comma, or space) or a fixed character width.
This question belongs to: Computer Microsoft Office
Question #495
In MS PowerPoint, what key should you hold down while drawing a geometric shape with the mouse cursor to ensure its aspect ratio stays constrained into a perfect circle or square?
A. Shift
B. Alt
C. Ctrl
D. Spacebar
Discuss
Get Complete Subject PDF for Computer

Correct Answer: Option A

Explanation:
Holding the Shift key down while dragging constrains the aspect ratio of shapes, forcing rectangles to become perfect squares and ovals to become perfect circles.
This question belongs to: Computer Microsoft Office
Question #496
Which of the following fields serves as a foreign key in a relational database layout in MS Access?
A. A field in a child table that points to the primary key field of a parent table.
B. An automatically incremented table row number field.
C. A primary key field that has been encrypted.
D. A field that contains multiple calculated value formulas.
Discuss
Get Complete Subject PDF for Computer

Correct Answer: Option A

Explanation:
A Foreign Key is a field or collection of fields in one table that references the Primary Key of another table, establishing a relational link between the two data structures.
This question belongs to: Computer Microsoft Office
Question #497
What is the function of the keyboard shortcut Ctrl + J when working inside an active document in MS Word?
A. Inserts a clear hyperlink text reference field
B. Indents the paragraph from the left page margin
C. Justifies the text alignment flush with both margins
D. Applies center alignment formatting to the paragraph
Discuss
Get Complete Subject PDF for Computer

Correct Answer: Option C

Explanation:
Ctrl + J applies Justify alignment, distributing spacing between words so that text aligns flush with both the left and right page margins.
This question belongs to: Computer Microsoft Office
Question #498
In MS PowerPoint, what occurs when you click the 'B' key on the keyboard during an active, full-screen slide show presentation?
A. Launches the drawing pen annotation tool
B. Blacks out the screen display completely
C. Whites out the screen display completely
D. Moves the presentation instantly to the previous slide layout
Discuss
Get Complete Subject PDF for Computer

Correct Answer: Option B

Explanation:
Pressing the 'B' key during a live presentation blacks out the screen. Pressing the 'W' key turns the screen completely white. Pressing either key again returns to the slide show.
This question belongs to: Computer Microsoft Office
Question #499
Which field data type in an MS Access table automatically generates a unique sequential number every time a new row record is added?
A. Number
B. OLE Object data properties
C. Calculated Field Type
D. AutoNumber
Discuss
Get Complete Subject PDF for Computer

Correct Answer: Option D

Explanation:
The AutoNumber data type automatically inserts a unique, sequential or randomized numeric value whenever a new record is added to an Access table, making it ideal for primary keys.
This question belongs to: Computer Microsoft Office
Question #500
What is the universal keyboard shortcut to open the traditional 'Save As' dialog box directly across Microsoft Word and Excel?
A. Shift + F12
B. Ctrl + S
C. F12
D. Alt + F2
Discuss
Get Complete Subject PDF for Computer

Correct Answer: Option C

Explanation:
The F12 function key opens the 'Save As' dialog box directly, allowing users to save files under a new name, format extension, or directory path.
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: