Microsoft Office MCQs
Practice MS Office MCQs covering MS Word, Excel, PowerPoint, Access, shortcut keys, formatting, formulas and presentations with answers and explanations.
Question #41
Report Error
Which field property in MS Access ensures that a user cannot leave a specific field blank when entering a new database record?
Correct Answer: Option A
Explanation:
Setting the 'Required' property to 'Yes' forces the user to enter data into that specific field before saving the record.
Setting the 'Required' property to 'Yes' forces the user to enter data into that specific field before saving the record.
This question belongs to:
Computer
Microsoft Office
Question #42
Report Error
What is the maximum zoom percentage scale allowed natively in Microsoft Word?
Correct Answer: Option A
Explanation:
MS Word allows a maximum document zoom scale of 500%, whereas MS Excel and PowerPoint are capped at 400%.
MS Word allows a maximum document zoom scale of 500%, whereas MS Excel and PowerPoint are capped at 400%.
This question belongs to:
Computer
Microsoft Office
Question #43
Report Error
What will be the output of the MS Excel formula =CEILING.MATH(14.2, 5)?
Correct Answer: Option C
Explanation:
The CEILING.MATH function rounds a number up to the nearest specified multiple. The nearest multiple of 5 greater than or equal to 14.2 is 15.
The CEILING.MATH function rounds a number up to the nearest specified multiple. The nearest multiple of 5 greater than or equal to 14.2 is 15.
This question belongs to:
Computer
Microsoft Office
Question #44
Report Error
Which view in MS PowerPoint displays the speaker notes alongside a large preview of the active slide and a thumbnail preview of the upcoming slide?
Correct Answer: Option D
Explanation:
Presenter View is a dedicated view designed for the presenter when projecting, showing the current slide, next slide, timer, and notes.
Presenter View is a dedicated view designed for the presenter when projecting, showing the current slide, next slide, timer, and notes.
This question belongs to:
Computer
Microsoft Office
Question #45
Report Error
In MS Access, what type of structural relationship is formed between two tables when a unique primary key is linked to a field that is also a primary key in another table?
Correct Answer: Option C
Explanation:
When both linked fields in a database relationship are primary keys or unique indexes, a One-to-One relationship is generated.
When both linked fields in a database relationship are primary keys or unique indexes, a One-to-One relationship is generated.
This question belongs to:
Computer
Microsoft Office
Question #46
Report Error
Which features in MS Word are used to divide a single document into separate formatting zones for columns, page numbering styles, or custom margins?
Correct Answer: Option C
Explanation:
Section breaks allow you to isolate and apply different layouts, headers, footers, and structural configurations within the same document.
Section breaks allow you to isolate and apply different layouts, headers, footers, and structural configurations within the same document.
This question belongs to:
Computer
Microsoft Office
Question #47
Report Error
In MS Excel, which shortcut key combination selects all cells extending from the active cursor position to the very last populated cell in that row?
Correct Answer: Option A
Explanation:
Ctrl + Shift + Right Arrow extends the cell selection block up to the last non-blank cell in the current row direction.
Ctrl + Shift + Right Arrow extends the cell selection block up to the last non-blank cell in the current row direction.
This question belongs to:
Computer
Microsoft Office
Question #48
Report Error
What is the primary function of the F7 function key across MS Office applications like Word and PowerPoint?
Correct Answer: Option C
Explanation:
The F7 function key is the universal shortcut to trigger the built-in Spelling and Grammar checking tool in MS Office.
The F7 function key is the universal shortcut to trigger the built-in Spelling and Grammar checking tool in MS Office.
This question belongs to:
Computer
Microsoft Office
Question #49
Report Error
In MS PowerPoint, which pane is used to alter the sequence order, adjust triggers, or apply delays to individual slide entry animations?
Correct Answer: Option D
Explanation:
The Animation Pane opens on the right side of the screen, allowing users to fine-tune animation timings, ordering, and playback mechanics.
The Animation Pane opens on the right side of the screen, allowing users to fine-tune animation timings, ordering, and playback mechanics.
This question belongs to:
Computer
Microsoft Office
Question #50
Report Error
In MS Word, what does the 'Gutter Margin' refer to?
Correct Answer: Option B
Explanation:
A gutter margin adds extra buffer space to the side or top margin of a document intended for bookbinding, ensuring text remains fully legible.
A gutter margin adds extra buffer space to the side or top margin of a document intended for bookbinding, ensuring text remains fully legible.
This question belongs to:
Computer
Microsoft Office
