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 5 of 60
Question #81
In MS PowerPoint, what feature allows you to display a small floating video panel of the presenter alongside the slides?
A. SmartArt
B. Presenter Coach
C. Cameo
D. Screen Recording
Discuss
Get Complete Subject PDF for Computer

Correct Answer: Option C

Explanation:
The Cameo feature inserts a live camera feed directly onto a presentation slide, allowing presenters to integrate video into the layout.
This question belongs to: Computer Microsoft Office
Question #82
Which of the following formulas is valid in MS Excel to find the highest value from cells A1 through A10?
A. =MAX(A1:A10)
B. =MAXIMUM(A1:A10)
C. =TOP(A1:A10)
D. =HIGH(A1:A10)
Discuss
Get Complete Subject PDF for Computer

Correct Answer: Option A

Explanation:
The native function name to extract the maximum number from a given range of cells in Excel is MAX.
This question belongs to: Computer Microsoft Office
Question #83
What is the keyboard shortcut to create a new blank document file across almost all Microsoft Office applications?
A. Ctrl + N
B. Ctrl + B
C. Ctrl + M
D. Ctrl + O
Discuss
Get Complete Subject PDF for Computer

Correct Answer: Option A

Explanation:
Ctrl + N initiates a new blank document, worksheet, or presentation file from scratch based on default templates.
This question belongs to: Computer Microsoft Office
Question #84
In MS Word, which of the following layout spacing choices can be accessed via the paragraph properties menu?
A. Tracking metrics
B. Line Spacing
C. Kerning settings
D. Pitch limits
Discuss
Get Complete Subject PDF for Computer

Correct Answer: Option B

Explanation:
Line Spacing controls the vertical spacing distance separating text rows inside a single paragraph block.
This question belongs to: Computer Microsoft Office
Question #85
In MS PowerPoint, which views show only text entries within a slide structure without any shape objects, drawings, or image boxes?
A. Slide Show
B. Reading View
C. Outline View
D. Normal View
Discuss
Get Complete Subject PDF for Computer

Correct Answer: Option C

Explanation:
Outline View presents text structured hierarchically, stripping away graphics to let you audit textual flow.
This question belongs to: Computer Microsoft Office
Question #86
Which of the following field keys in MS Access links a child table record to a primary key in a parent table?
A. Foreign Key
B. Candidate Key
C. Super Key
D. Composite Key
Discuss
Get Complete Subject PDF for Computer

Correct Answer: Option A

Explanation:
A Foreign Key matches the primary key field of another table to form relational links between distinct data records.
This question belongs to: Computer Microsoft Office
Question #87
What is the purpose of the keyboard shortcut Ctrl + P across MS Office?
A. Inserts a page break line
B. Opens the Paragraph styling pane
C. Pastes clipboard contents
D. Launches the Print configuration window
Discuss
Get Complete Subject PDF for Computer

Correct Answer: Option D

Explanation:
Ctrl + P opens the Print pane, displaying print settings along with a real-time layout preview.
This question belongs to: Computer Microsoft Office
Question #88
What is the result of the Excel formula =LEN("MS Excel 2026")?
A. 10
B. 13
C. 12
D. 11
Discuss
Get Complete Subject PDF for Computer

Correct Answer: Option B

Explanation:
The LEN function counts all characters within a text string, including alphanumeric digits, spaces, and special symbols. "MS Excel 2026" contains exactly 13 characters.
This question belongs to: Computer Microsoft Office
Question #89
In MS PowerPoint, which feature can draw a user's attention to a specific spot on a slide during a live presentation by turning the cursor into a glowing pointer?
A. Magnifier Tool
B. Highlight Tool
C. Ink Pen Annotator
D. Laser Pointer
Discuss
Get Complete Subject PDF for Computer

Correct Answer: Option D

Explanation:
Holding Ctrl and left-clicking during a slide show activates the built-in Laser Pointer feature to guide audience focus.
This question belongs to: Computer Microsoft Office
Question #90
What is the native extension of an MS Word Document template file?
A. .dotx
B. .wrd
C. .docm
D. .docx
Discuss
Get Complete Subject PDF for Computer

Correct Answer: Option A

Explanation:
.dotx represents a standard macro-free MS Word Document Template layout used to distribute base layouts.
This question belongs to: Computer Microsoft Office
Question #91
Which feature in MS Excel automatically fills adjacent cells when it recognizes a clear data pattern, such as combining first and last names?
A. Consolidate
B. Flash Fill
C. Data Validation
D. AutoCorrect
Discuss
Get Complete Subject PDF for Computer

Correct Answer: Option B

Explanation:
Flash Fill recognizes structural text patterns and completes data entry down an entire column automatically.
This question belongs to: Computer Microsoft Office
Question #92
In MS Word, which toolbar can be customized to keep your most frequently used commands visible, regardless of which ribbon tab is currently active?
A. Status Bar
B. Mini Toolbar
C. Task Pane Layout
D. Quick Access Toolbar
Discuss
Get Complete Subject PDF for Computer

Correct Answer: Option D

Explanation:
The Quick Access Toolbar (QAT) can be populated with user-selected commands so they stay accessible at the top of the interface.
This question belongs to: Computer Microsoft Office
Question #93
What will be the result of the MS Excel formula =COUNTA(A1:A4) if cell A1=10, A2="Text", A3=EMPTY, and A4=0?
A. 1
B. 4
C. 2
D. 3
Discuss
Get Complete Subject PDF for Computer

Correct Answer: Option D

Explanation:
The COUNTA function counts any non-empty cells within a range. Out of four cells, three are occupied (10, "Text", 0) and one is blank, yielding 3.
This question belongs to: Computer Microsoft Office
Question #94
In MS Access, which field size validation rule limits a Short Text entry to contain at most 50 characters?
A. Field Size
B. Validation Rule
C. Input Mask
D. Format Limit
Discuss
Get Complete Subject PDF for Computer

Correct Answer: Option A

Explanation:
The Field Size property specifies the maximum character storage capacity limit allowed for Short Text fields.
This question belongs to: Computer Microsoft Office
Question #95
What is the shortcut key combination to double-underline a selected block of text in MS Word?
A. Ctrl + Shift + U
B. Ctrl + Shift + D
C. Alt + Shift + D
D. Ctrl + U
Discuss
Get Complete Subject PDF for Computer

Correct Answer: Option B

Explanation:
Ctrl + Shift + D applies a double-line underline style to selected text blocks in MS Word, while Ctrl + U applies a single underline.
This question belongs to: Computer Microsoft Office
Question #96
Which command tool in MS Excel removes duplicate rows from a selected data worksheet based on chosen columns?
A. Remove Duplicates
B. Consolidate Data
C. Data Validation
D. Text to Columns
Discuss
Get Complete Subject PDF for Computer

Correct Answer: Option A

Explanation:
The 'Remove Duplicates' feature on the Data tab analyzes selected rows and permanently deletes duplicate entries.
This question belongs to: Computer Microsoft Office
Question #97
In MS PowerPoint, what are the entry effects that control how an object arrives or animates onto a slide during a show?
A. Entrance Effects
B. Emphasis Effects
C. Exit Effects
D. Motion Paths
Discuss
Get Complete Subject PDF for Computer

Correct Answer: Option A

Explanation:
Entrance effects dictate how an item steps onto the slide canvas area during presentation playback steps.
This question belongs to: Computer Microsoft Office
Question #98
Which view mode in MS Word is designed specifically to optimize long-form document reading by replacing edit menus with simple tracking arrows?
A. Web Layout
B. Read Mode
C. Draft View
D. Outline View
Discuss
Get Complete Subject PDF for Computer

Correct Answer: Option B

Explanation:
Read Mode hides editing tools and rearranges document flow into side-by-side horizontal cards for easy reading.
This question belongs to: Computer Microsoft Office
Question #99
What error code is returned by MS Excel if a formula references a cell location that has been completely deleted by removing its row or column?
A. #NUM!
B. #VALUE!
C. #REF!
D. #NAME?
Discuss
Get Complete Subject PDF for Computer

Correct Answer: Option C

Explanation:
The #REF! error signals an invalid cell reference, which typically happens when cells targeted by formulas are deleted from the spreadsheet layout.
This question belongs to: Computer Microsoft Office
Question #100
In MS PowerPoint, what key sequence toggles the blacking out of the projection screen during a live slide show presentation?
A. W
B. B
C. S
D. Esc
Discuss
Get Complete Subject PDF for Computer

Correct Answer: Option B

Explanation:
Pressing the 'B' key during a live presentation blacks out the screen. Pressing 'W' turns the screen completely white.
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)?