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. COUNTBLANK
B. COUNT
C. COUNTA
D. COUNTIF
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. Animation Effect
C. Emphasis Effect Layout
D. Slide Transition
Discuss
Get Complete Subject PDF for Computer

Correct Answer: Option D

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. Format properties sheet
B. Validation Rule
C. Input Mask editor
D. Default Value mapping
Discuss
Get Complete Subject PDF for Computer

Correct Answer: Option B

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. Clears all manual character formatting from the selected text
B. Highlights the entire document page layout
C. Applies double line spacing to the paragraph
D. Inserts a non-breaking space character
Discuss
Get Complete Subject PDF for Computer

Correct Answer: Option A

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. 3
B. #VALUE!
C. 2
D. 1
Discuss
Get Complete Subject PDF for Computer

Correct Answer: Option C

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

Correct Answer: Option B

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. F1
B. Shift + F5
C. F5
D. Ctrl + F5
Discuss
Get Complete Subject PDF for Computer

Correct Answer: Option C

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. Form
B. Query setup
C. Report
D. Macro asset
Discuss
Get Complete Subject PDF for Computer

Correct Answer: Option C

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 vertical spacing buffer separating two columns of text data.
B. The extra margin space added to the binding side of a document to prevent text coverage during binding.
C. The bottom layout margin reserved for footnote entries.
D. The empty space located at the outer margins of headers.
Discuss
Get Complete Subject PDF for Computer

Correct Answer: Option B

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. .xlsm
B. .xlsx
C. .xltx
D. .xls
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. Format constraint
B. Validation Rule
C. Input Mask
D. Required field size
Discuss
Get Complete Subject PDF for Computer

Correct Answer: Option C

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 + G
B. Ctrl + F
C. Ctrl + H
D. Ctrl + N
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. Data Validation wizard
B. Consolidate tool
C. Text to Columns
D. Flash Fill
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. Alt
B. Shift
C. Ctrl
D. Spacebar
Discuss
Get Complete Subject PDF for Computer

Correct Answer: Option B

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. Indents the paragraph from the left page margin
B. Applies center alignment formatting to the paragraph
C. Inserts a clear hyperlink text reference field
D. Justifies the text alignment flush with both margins
Discuss
Get Complete Subject PDF for Computer

Correct Answer: Option D

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. Blacks out the screen display completely
B. Whites out the screen display completely
C. Launches the drawing pen annotation tool
D. Moves the presentation instantly to the previous slide layout
Discuss
Get Complete Subject PDF for Computer

Correct Answer: Option A

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. AutoNumber
B. OLE Object data properties
C. Number
D. Calculated Field Type
Discuss
Get Complete Subject PDF for Computer

Correct Answer: Option A

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. Alt + F2
B. Shift + F12
C. Ctrl + S
D. F12
Discuss
Get Complete Subject PDF for Computer

Correct Answer: Option D

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
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?'