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. Launches the web browser lookup helper
B. Applies a bold style format to the active word block
C. Closes the currently active document window
D. Saves the current document and opens a blank document
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. Morphing
B. Transition
C. Entrance Effect
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. Header
B. Endnote
C. Watermark
D. Footnote
Discuss
Get Complete Subject PDF for Computer

Correct Answer: Option A

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. Prevents formulas from performing background recalculations
B. Keeps rows or columns visible on screen while scrolling down the rest of the worksheet
C. Hides the formula visibility bar from the upper toolbar interface
D. Locks down specific cells to prevent unauthorized editing changes
Discuss
Get Complete Subject PDF for Computer

Correct Answer: Option B

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. .xls
B. .xlsx
C. .xlsm
D. .xltx
Discuss
Get Complete Subject PDF for Computer

Correct Answer: Option B

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. Undoes the last action performed
B. Cuts the selected item block
C. Inserts a time index stamp
D. Redoes or repeats the last action performed
Discuss
Get Complete Subject PDF for Computer

Correct Answer: Option D

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. AND
B. IF
C. CHOOSE
D. OR
Discuss
Get Complete Subject PDF for Computer

Correct Answer: Option B

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. Outline Print Setup
B. Slide Sorter Setup
C. Handout Master
D. Notes Page Layout
Discuss
Get Complete Subject PDF for Computer

Correct Answer: Option C

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. Format Parameter
B. Default Value
C. Input Mask
D. Validation Text
Discuss
Get Complete Subject PDF for Computer

Correct Answer: Option C

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. Decreases the font size of selected text by 1 point
B. Aligns the paragraph to the left edge
C. Increases the font size of selected text by 1 point
D. Inserts an opening square bracket block
Discuss
Get Complete Subject PDF for Computer

Correct Answer: Option A

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. What-If Analysis (Scenario Manager)
B. Data Validation
C. Consolidate tool
D. Flash Fill
Discuss
Get Complete Subject PDF for Computer

Correct Answer: Option A

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. Distributed Layout
B. Justify Alignment
C. Left Alignment
D. Center Alignment
Discuss
Get Complete Subject PDF for Computer

Correct Answer: Option B

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. A new empty column gets inserted between them
C. The column auto-fits its width to match its longest data entry string
D. The columns are combined together
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. Footnote
B. Caption index
C. Bibliography
D. Endnote
Discuss
Get Complete Subject PDF for Computer

Correct Answer: Option A

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. 20
C. #VALUE!
D. 30
Discuss
Get Complete Subject PDF for Computer

Correct Answer: Option B

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. Enter
B. Backspace
C. Esc
D. Spacebar
Discuss
Get Complete Subject PDF for Computer

Correct Answer: Option C

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. Executes an Array Formula enclosed in curly braces
C. Deletes active row entries
D. Inserts a new sheet layout
Discuss
Get Complete Subject PDF for Computer

Correct Answer: Option B

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. Images embedded in lines
B. Text contents alone
C. Both text and formatting combined
D. Formatting and style configurations alone
Discuss
Get Complete Subject PDF for Computer

Correct Answer: Option D

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 Internet and Web Technologies 461 Computer Fundamentals 326 Microsoft Office 1199 CPU (Central Processing Unit) 327
Explore Subjects
Computer 5279 Static General Knowledge 6362 English 15164 Current Affairs 575 History GK 3374
Practice Mix
The difference between simple interest and compound interest on a certain sum of money for 2 years at 9% per annum is Rs. 81. Find the sum.
The process by which plants lose water in the form of liquid droplets is:
The 'Vote on Account' is used to:
Software programs that are custom engineered for banking automated teller machines (ATMs) to connect securely to institutional transaction ledger networks are classified as:
Which is the capital of South Africa (legislative)?