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 3 of 60
Question #41
Which field property in MS Access ensures that a user cannot leave a specific field blank when entering a new database record?
A. Required
B. Validation Rule
C. Input Mask
D. Indexed
Discuss
Get Complete Subject PDF for Computer

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.
This question belongs to: Computer Microsoft Office
Question #42
What is the maximum zoom percentage scale allowed natively in Microsoft Word?
A. 500%
B. 200%
C. 1000%
D. 400%
Discuss
Get Complete Subject PDF for Computer

Correct Answer: Option A

Explanation:
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
What will be the output of the MS Excel formula =CEILING.MATH(14.2, 5)?
A. 15
B. 20
C. 14
D. 10
Discuss
Get Complete Subject PDF for Computer

Correct Answer: Option A

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.
This question belongs to: Computer Microsoft Office
Question #44
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?
A. Reading View
B. Presenter View
C. Outline View
D. Notes Page View
Discuss
Get Complete Subject PDF for Computer

Correct Answer: Option B

Explanation:
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
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?
A. One-to-Many
B. Self-Referential
C. One-to-One
D. Many-to-Many
Discuss
Get Complete Subject PDF for Computer

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.
This question belongs to: Computer Microsoft Office
Question #46
Which features in MS Word are used to divide a single document into separate formatting zones for columns, page numbering styles, or custom margins?
A. Style Sets
B. Page Breaks
C. Section Breaks
D. Paragraph Indents
Discuss
Get Complete Subject PDF for Computer

Correct Answer: Option C

Explanation:
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
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?
A. Alt + Shift + Right Arrow
B. Ctrl + Shift + End
C. Shift + Page Down
D. Ctrl + Shift + Right Arrow
Discuss
Get Complete Subject PDF for Computer

Correct Answer: Option D

Explanation:
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
What is the primary function of the F7 function key across MS Office applications like Word and PowerPoint?
A. Opens the macro recording pane
B. Launches the Spelling and Grammar check
C. Saves the file as a PDF
D. Inserts an automatic table of contents
Discuss
Get Complete Subject PDF for Computer

Correct Answer: Option B

Explanation:
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
In MS PowerPoint, which pane is used to alter the sequence order, adjust triggers, or apply delays to individual slide entry animations?
A. Animation Pane
B. Transition Properties
C. Slide Master Layout
D. Selection Pane
Discuss
Get Complete Subject PDF for Computer

Correct Answer: Option A

Explanation:
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
In MS Word, what does the 'Gutter Margin' refer to?
A. Margin space added to the binding side of a document to prevent text coverage during binding
B. The footer section containing page counts and file metrics
C. The empty gap between two lines of text inside a paragraph
D. Margin space reserved on the right to accommodate comments
Discuss
Get Complete Subject PDF for Computer

Correct Answer: Option A

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.
This question belongs to: Computer Microsoft Office
Question #51
In MS PowerPoint, what key should you hold down while drawing a shape with the mouse cursor to ensure a perfect square or uniform circle is created?
A. Alt
B. Spacebar
C. Shift
D. Ctrl
Discuss
Get Complete Subject PDF for Computer

Correct Answer: Option C

Explanation:
Holding the Shift key down constraints the aspect ratio, forcing rectangles to become squares and ovals to become perfect circles.
This question belongs to: Computer Microsoft Office
Question #52
Which field type in an MS Access table automatically generates a brand new sequential or randomized number every time a new row is appended?
A. OLE Object
B. Number
C. Calculated
D. AutoNumber
Discuss
Get Complete Subject PDF for Computer

Correct Answer: Option D

Explanation:
The AutoNumber data type automatically inserts a unique, incremented numeric value whenever a new record is added to the table database.
This question belongs to: Computer Microsoft Office
Question #53
Which command feature in MS Word is used to replace misspelled words automatically with pre-programmed choices while typing?
A. Track Changes
B. Smart Lookup
C. AutoText
D. AutoCorrect
Discuss
Get Complete Subject PDF for Computer

Correct Answer: Option D

Explanation:
AutoCorrect corrects typos, misspelled words, and syntax automatically using a pre-defined database list of common mistakes.
This question belongs to: Computer Microsoft Office
Question #54
What type of chart in MS Excel displays data points connected by line intervals to illustrate long-term trends over continuous intervals?
A. Pie Chart
B. Radar Chart
C. Bar Chart
D. Line Chart
Discuss
Get Complete Subject PDF for Computer

Correct Answer: Option D

Explanation:
Line charts map out changes over time, tracking continuous shifts in numerical values across defined chronological periods.
This question belongs to: Computer Microsoft Office
Question #55
What is the shortcut key sequence to toggle selected text between Uppercase, Lowercase, and Title Case in MS Word?
A. Shift + F3
B. Ctrl + Shift + A
C. Alt + F3
D. Ctrl + F3
Discuss
Get Complete Subject PDF for Computer

Correct Answer: Option A

Explanation:
Pressing Shift + F3 rotates the casing of the highlighted text selection through UPPERCASE, lowercase, and Capitalize Each Word.
This question belongs to: Computer Microsoft Office
Question #56
Which layout object in MS PowerPoint controls the global background colors, slide layout footprints, default paragraph sizes, and alignment rules for standard text blocks?
A. Handout Master
B. Design Ribbon
C. Notes Master
D. Slide Master
Discuss
Get Complete Subject PDF for Computer

Correct Answer: Option D

Explanation:
The Slide Master is the foundational blueprint that controls style formatting rules and structural layouts for every slide inside a presentation.
This question belongs to: Computer Microsoft Office
Question #57
In MS Excel, what does the error message '#NULL!' typically indicate?
A. A cell contains an invalid division calculation
B. A numeric value is outside of the expected bounds
C. A required parameter in a formula is missing
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 appears when a space operator is used between two ranges that do not actually cross paths or intersect (e.g., =SUM(A1:A2 B1:B2)).
This question belongs to: Computer Microsoft Office
Question #58
In MS Word, which of the following is an example of a font style or character decoration attribute?
A. Margins
B. Strikethrough
C. Calibri
D. 12 pt
Discuss
Get Complete Subject PDF for Computer

Correct Answer: Option B

Explanation:
Strikethrough is an explicitly selectable character effect attribute, whereas Calibri is a font family, and 12 pt represents font size metric sizing.
This question belongs to: Computer Microsoft Office
Question #59
Which view mode should be used in MS PowerPoint to view text content hierarchy and structure exclusively, hiding all images, drawings, and transition animations?
A. Outline View
B. Reading View
C. Normal View
D. Slide Sorter View
Discuss
Get Complete Subject PDF for Computer

Correct Answer: Option A

Explanation:
Outline View simplifies the presentation window to show text contents exclusively, letting you review the textual narrative flow clearly.
This question belongs to: Computer Microsoft Office
Question #60
Which of the following database tools in MS Access is explicitly used to extract selective records matching specific criteria across multiple underlying tables?
A. Form
B. Query
C. Macro
D. Report
Discuss
Get Complete Subject PDF for Computer

Correct Answer: Option B

Explanation:
Queries extract, compile, and filter specific records from multiple interconnected database tables depending on targeted user constraints.
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 Software 347 Computer Abbreviations 369 Operating Systems 510 Computer Networking 325 Microsoft Office 1199
Explore Subjects
Computer 5279 Science 4430 Geography GK 6121 Current Affairs 575 Static General Knowledge 6362
Practice Mix
The street ______ I live on is quiet.
What is the capacity unit for modern RAM modules?
Which of the following is a Rabi millet?
An object moving with uniform circular motion has
Identify the error: 'You are senior than me.'