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 4 of 60
Question #61
In MS Word, what does pressing the 'Ctrl + W' shortcut key combination do?
A. Applies a bold style format to the active word block
B. Saves the current document and opens a blank document
C. Closes the currently active document window
D. Launches the web browser lookup helper
Discuss
Get Complete Subject PDF for Computer

Correct Answer: Option C

Explanation:
Ctrl + W closes the active document or file window in most MS Office suites without exiting the core parent software program altogether.
This question belongs to: Computer Microsoft Office
Question #62
What type of special motion visual effect occurs when transitioning from one slide display to another during a slide show in MS PowerPoint?
A. Entrance Effect
B. Transition
C. Morphing
D. Animation
Discuss
Get Complete Subject PDF for Computer

Correct Answer: Option B

Explanation:
Transitions control the cinematic visual effects that execute during movement between slides, while Animations control motions inside a single slide.
This question belongs to: Computer Microsoft Office
Question #63
In MS Word, which feature enables you to repeat headings across the top edge of every single physical printed sheet automatically?
A. Watermark
B. Footnote
C. Endnote
D. Header
Discuss
Get Complete Subject PDF for Computer

Correct Answer: Option D

Explanation:
A Header is a specialized layout zone positioned within the top margins of a document to display titles or page indexes uniformly.
This question belongs to: Computer Microsoft Office
Question #64
In MS Excel, what does the 'Freeze Panes' utility option accomplish?
A. Locks down specific cells to prevent unauthorized editing changes
B. Hides the formula visibility bar from the upper toolbar interface
C. Prevents formulas from performing background recalculations
D. Keeps rows or columns visible on screen while scrolling down the rest of the worksheet
Discuss
Get Complete Subject PDF for Computer

Correct Answer: Option D

Explanation:
Freeze Panes locks rows or columns in place, so they remain fully viewable while navigating through deep rows or long columns.
This question belongs to: Computer Microsoft Office
Question #65
Which of the following is the default native file extension format for workbook files saved in MS Excel from 2007 onwards?
A. .xlsx
B. .xls
C. .xlsm
D. .xltx
Discuss
Get Complete Subject PDF for Computer

Correct Answer: Option A

Explanation:
Modern versions of Excel use the open XML-based file format extension '.xlsx' as their default native structural save extension.
This question belongs to: Computer Microsoft Office
Question #66
What is the function of the keyboard shortcut Ctrl + Y in MS Word?
A. Cuts the selected item block
B. Undoes the last action performed
C. Redoes or repeats the last action performed
D. Inserts a time index stamp
Discuss
Get Complete Subject PDF for Computer

Correct Answer: Option C

Explanation:
Ctrl + Y is the shortcut to Redo or repeat an action that was reversed via the Undo (Ctrl + Z) command.
This question belongs to: Computer Microsoft Office
Question #67
Which specific MS Excel function evaluates whether a condition is satisfied and outputs one value if true, and a different designated value if false?
A. IF
B. AND
C. OR
D. CHOOSE
Discuss
Get Complete Subject PDF for Computer

Correct Answer: Option A

Explanation:
The IF function executes logical truth tests, handling conditional output behaviors cleanly across standard data records.
This question belongs to: Computer Microsoft Office
Question #68
In MS PowerPoint, which tool allows you to select customized layout options to output 2, 3, 6, or 9 small presentation slides onto a single paper sheet for distribution?
A. Slide Sorter Setup
B. Outline Print Setup
C. Notes Page Layout
D. Handout Master
Discuss
Get Complete Subject PDF for Computer

Correct Answer: Option D

Explanation:
The Handout Master edits layouts for physical paper prints meant for audiences, containing custom configurations for multiple slides per sheet.
This question belongs to: Computer Microsoft Office
Question #69
In MS Access, what field property specifies a pattern format rule (e.g., '(000) 000-0000') that users must strictly follow when entering data?
A. Default Value
B. Input Mask
C. Validation Text
D. Format Parameter
Discuss
Get Complete Subject PDF for Computer

Correct Answer: Option B

Explanation:
An Input Mask creates a placeholder pattern constraint that guides formatting layout directly during manual data entry steps.
This question belongs to: Computer Microsoft Office
Question #70
What is the function of the shortcut key combination Ctrl + [ in MS Word?
A. Increases the font size of selected text by 1 point
B. Inserts an opening square bracket block
C. Aligns the paragraph to the left edge
D. Decreases the font size of selected text by 1 point
Discuss
Get Complete Subject PDF for Computer

Correct Answer: Option D

Explanation:
Ctrl + [ decreases the font size of selected characters by exactly 1 point size, whereas Ctrl + ] increases it by 1 point.
This question belongs to: Computer Microsoft Office
Question #71
Which Excel tool can substitute multiple varying values into formulas to assess how different parameters alter the final financial projections?
A. Consolidate tool
B. Data Validation
C. Flash Fill
D. What-If Analysis (Scenario Manager)
Discuss
Get Complete Subject PDF for Computer

Correct Answer: Option D

Explanation:
What-If Analysis (including Scenario Manager and Goal Seek) lets you vary parameters within formulas to preview alternative outcomes.
This question belongs to: Computer Microsoft Office
Question #72
What is the native presentation file save format extension for MS PowerPoint versions 2007 and newer?
A. .ppsx
B. .pptx
C. .ppt
D. .potx
Discuss
Get Complete Subject PDF for Computer

Correct Answer: Option B

Explanation:
.pptx is the standard XML-based default file extension format for PowerPoint files since 2007.
This question belongs to: Computer Microsoft Office
Question #73
Which of the following aligns both the left and right edges of a text block smoothly against page margins in MS Word, adding adaptive spacing between words?
A. Justify Alignment
B. Distributed Layout
C. Center Alignment
D. Left Alignment
Discuss
Get Complete Subject PDF for Computer

Correct Answer: Option A

Explanation:
Justification (Ctrl + J) stretches spacing between words so text aligns flush with both the left and right margins.
This question belongs to: Computer Microsoft Office
Question #74
In MS Excel, what occurs if you double-click on the boundary line dividing two column header letters?
A. The column is automatically hidden from view
B. The columns are combined together
C. The column auto-fits its width to match its longest data entry string
D. A new empty column gets inserted between them
Discuss
Get Complete Subject PDF for Computer

Correct Answer: Option C

Explanation:
Double-clicking a column boundary line triggers the AutoFit feature, adjusting the column width to fit its longest content entry perfectly.
This question belongs to: Computer Microsoft Office
Question #75
In MS Word, which reference tool places short citations at the bottom boundary of the same page where a number indicator reference was added?
A. Caption index
B. Endnote
C. Footnote
D. Bibliography
Discuss
Get Complete Subject PDF for Computer

Correct Answer: Option C

Explanation:
Footnotes reside at the bottom base of the active page. Endnotes are compiled at the end of the entire document.
This question belongs to: Computer Microsoft Office
Question #76
What will be the result of the MS Excel formula =AVERAGE(10, 20, 30) if entered into a modern worksheet?
A. 15
B. #VALUE!
C. 30
D. 20
Discuss
Get Complete Subject PDF for Computer

Correct Answer: Option D

Explanation:
When passed directly as individual arguments inside a formula, numeric strings are parsed into numbers. Thus, (10 + 20 + 30) / 3 = 20.
This question belongs to: Computer Microsoft Office
Question #77
Which shortcut key exits a live running slide show presentation immediately and returns to the workspace interface in MS PowerPoint?
A. Esc
B. Backspace
C. Enter
D. Spacebar
Discuss
Get Complete Subject PDF for Computer

Correct Answer: Option A

Explanation:
The Escape (Esc) key terminates an active presentation run immediately, safely dropping back into the designer workspace.
This question belongs to: Computer Microsoft Office
Question #78
Which database action or layout object in MS Access is optimized to print structured data cleanly on paper sheets?
A. Form
B. Query
C. Report
D. Table
Discuss
Get Complete Subject PDF for Computer

Correct Answer: Option C

Explanation:
Reports are explicitly configured to organize, format, summarize, and display data for printing or professional document delivery.
This question belongs to: Computer Microsoft Office
Question #79
What is the function of the keyboard shortcut Ctrl + Shift + Enter in MS Excel?
A. Forces a text wrap inside a cell
B. Deletes active row entries
C. Inserts a new sheet layout
D. Executes an Array Formula enclosed in curly braces
Discuss
Get Complete Subject PDF for Computer

Correct Answer: Option D

Explanation:
Ctrl + Shift + Enter is the legacy keystroke used to execute array formulas, enclosing the target formula in curly braces { }.
This question belongs to: Computer Microsoft Office
Question #80
In MS Word, what does the 'Format Painter' tool copy?
A. Both text and formatting combined
B. Text contents alone
C. Formatting and style configurations alone
D. Images embedded in lines
Discuss
Get Complete Subject PDF for Computer

Correct Answer: Option C

Explanation:
Format Painter copies only visual formatting settings (fonts, colorations, spacing) from a source selection and applies them to a target.
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.'