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 7 of 60
Question #121
In MS Excel, what type of referencing style is used when a formula contains a cell reference formatted as B$4?
A. Mixed Reference
B. Absolute Reference
C. External reference link
D. Relative Reference
Discuss
Get Complete Subject PDF for Computer

Correct Answer: Option A

Explanation:
A mixed cell reference locks down either the column or the row while leaving the other free to shift relatively during formula copy-paste procedures.
This question belongs to: Computer Microsoft Office
Question #122
Which of the following view layouts in MS PowerPoint is specifically optimized for reviewing presentation slides sequentially as a continuous reading text book script?
A. Notes Page structural mode
B. Master Designer interface
C. Slide Show view
D. Reading View
Discuss
Get Complete Subject PDF for Computer

Correct Answer: Option D

Explanation:
Reading View runs the presentation inside a resizable system window with basic control buttons, making it ideal for checking layout flows without entering a full-screen projection.
This question belongs to: Computer Microsoft Office
Question #123
What is the maximum number of column entries supported within a single MS Excel worksheet cell grid grid since 2007 editions?
A. 16,384
B. 1,048,576
C. 65,536
D. 256
Discuss
Get Complete Subject PDF for Computer

Correct Answer: Option A

Explanation:
MS Excel worksheets support exactly 16,384 columns (extending from column A to XFD) and 1,048,576 rows per worksheet sheet file.
This question belongs to: Computer Microsoft Office
Question #124
In MS Word, which feature enables you to quickly save frequently used text or layout blocks so you can insert them with just a few keystrores?
A. Smart Lookup database
B. Quick Parts (AutoText)
C. Mail Merge fields
D. AutoCorrect table options
Discuss
Get Complete Subject PDF for Computer

Correct Answer: Option B

Explanation:
Quick Parts (including AutoText blocks) allow you to store text snippets, disclaimers, or layout blocks to reuse them across multiple documents.
This question belongs to: Computer Microsoft Office
Question #125
Which feature in MS PowerPoint allows you to pick an active application window on your desktop and record a video clip of your screen to insert onto a slide?
A. Media Player Insert
B. Screen Recording
C. Screen Clipping
D. Screenshot Capture
Discuss
Get Complete Subject PDF for Computer

Correct Answer: Option B

Explanation:
The Screen Recording feature allows you to capture video and audio of actions on your computer screen and embed the recording on a slide.
This question belongs to: Computer Microsoft Office
Question #126
In MS Access, what do you call a field that contains unique data values across all rows and is used to uniquely identify each record in a table?
A. Lookup Index column
B. Foreign Key
C. Primary Key
D. Composite reference field
Discuss
Get Complete Subject PDF for Computer

Correct Answer: Option C

Explanation:
A Primary Key is a designated field that uniquely identifies each record or row inside a database table, and it cannot contain null values.
This question belongs to: Computer Microsoft Office
Question #127
What is the keyboard shortcut to left-align a selected block of text in MS Word?
A. Ctrl + E
B. Ctrl + R
C. Ctrl + Shift + L
D. Ctrl + L
Discuss
Get Complete Subject PDF for Computer

Correct Answer: Option D

Explanation:
Ctrl + L aligns the selected paragraph or text block flush with the left margin boundary.
This question belongs to: Computer Microsoft Office
Question #128
In MS Excel, what function can you use to count the number of empty or unpopulated cells within a specified range?
A. COUNTIF
B. COUNT
C. COUNTA
D. COUNTBLANK
Discuss
Get Complete Subject PDF for Computer

Correct Answer: Option D

Explanation:
COUNTBLANK counts empty cells within a specified cell range.
This question belongs to: Computer Microsoft Office
Question #129
Which command on the MS PowerPoint Insert tab allows you to quickly build visual diagrams like matrix charts, hierarchy trees, or process cycle flows?
A. Shapes collection
B. SmartArt
C. 3D Models layout
D. Charts tool
Discuss
Get Complete Subject PDF for Computer

Correct Answer: Option B

Explanation:
SmartArt graphics provide pre-designed layouts for charts, organizational trees, and flow diagrams to display information visually.
This question belongs to: Computer Microsoft Office
Question #130
In MS Word, which of the following refers to a specific type of page orientation where the page is taller than it is wide?
A. Portrait
B. Landscape
C. Square footprint
D. Horizontal
Discuss
Get Complete Subject PDF for Computer

Correct Answer: Option A

Explanation:
Portrait orientation positions pages vertically so they are taller than they are wide. Landscape positions pages horizontally.
This question belongs to: Computer Microsoft Office
Question #131
What is the shortcut key combination to check the word count, character count, and paragraph metrics of an active document file in MS Word?
A. Alt + Shift + C
B. Ctrl + W
C. Ctrl + F7
D. Ctrl + Shift + G
Discuss
Get Complete Subject PDF for Computer

Correct Answer: Option D

Explanation:
Ctrl + Shift + G opens the Word Count summary pane directly, showing details like page count, character count, and paragraph metrics.
This question belongs to: Computer Microsoft Office
Question #132
Which specialized view or wizard tool in MS Excel displays a step-by-step breakdown of calculations to help troubleshoot nested formulas?
A. Error Checking guide
B. Watch Window tool
C. Evaluate Formula
D. Trace Dependents map
Discuss
Get Complete Subject PDF for Computer

Correct Answer: Option C

Explanation:
The Evaluate Formula tool on the Formulas tab steps through each part of a formula in sequence, showing calculated values at each step to simplify debugging.
This question belongs to: Computer Microsoft Office
Question #133
Which of the following is the correct shortcut key to open the 'Find and Replace' dialog box in MS Word?
A. Ctrl + H
B. Ctrl + F
C. Ctrl + R
D. Ctrl + G
Discuss
Get Complete Subject PDF for Computer

Correct Answer: Option A

Explanation:
In MS Word, Ctrl + H opens the 'Find and Replace' dialog box directly with the Replace tab active. Ctrl + F opens the Navigation pane for find, Ctrl + G opens the Go To tab, and Ctrl + R aligns text to the right.
This question belongs to: Computer Microsoft Office
Question #134
What is the maximum number of columns that can be inserted in a single Excel worksheet (version 2016 and later)?
A. 256
B. 65536
C. 1048576
D. 16384
Discuss
Get Complete Subject PDF for Computer

Correct Answer: Option D

Explanation:
Excel 2007 and later versions support 16,384 columns (up to column XFD) and 1,048,576 rows. Therefore, the correct maximum columns is 16384.
This question belongs to: Computer Microsoft Office
Question #135
In MS PowerPoint, which view is used to add, delete, or rearrange slides in a presentation?
A. Normal View
B. Reading View
C. Slide Sorter View
D. Outline View
Discuss
Get Complete Subject PDF for Computer

Correct Answer: Option C

Explanation:
Slide Sorter View displays thumbnails of all slides and allows easy rearrangement, addition, or deletion of slides. Normal View is for editing individual slides, Outline View shows text outline, and Reading View is for presenting.
This question belongs to: Computer Microsoft Office
Question #136
What does the formula =SUM(A1:A10) do in MS Excel?
A. Counts the number of cells with numbers in A1:A10
B. Returns the maximum value in the range
C. Finds the average of numbers in A1:A10
D. Adds all numbers in cells A1 through A10
Discuss
Get Complete Subject PDF for Computer

Correct Answer: Option D

Explanation:
The SUM function adds all numeric values in the specified range. It does not count, average, or find max.
This question belongs to: Computer Microsoft Office
Question #137
In MS Word, which feature allows you to create a document by combining a main document with a data source?
A. Template
B. Style
C. Macro
D. Mail Merge
Discuss
Get Complete Subject PDF for Computer

Correct Answer: Option D

Explanation:
Mail Merge is used to produce multiple documents from a single template and a data source, such as form letters, labels, and envelopes.
This question belongs to: Computer Microsoft Office
Question #138
What is the keyboard shortcut to insert a hyperlink in MS Excel?
A. Ctrl + I
B. Ctrl + H
C. Ctrl + K
D. Ctrl + L
Discuss
Get Complete Subject PDF for Computer

Correct Answer: Option C

Explanation:
Ctrl + K is the universal shortcut to insert a hyperlink in Microsoft Office applications, including Excel, Word, and PowerPoint.
This question belongs to: Computer Microsoft Office
Question #139
In MS PowerPoint, which transition effect causes the current slide to be replaced by the next slide with a vertical or horizontal wipe?
A. Split
B. Fade
C. Wipe
D. Push
Discuss
Get Complete Subject PDF for Computer

Correct Answer: Option C

Explanation:
Wipe transition reveals the new slide with a moving edge (horizontal or vertical). Push pushes the old slide out, Fade is gradual, Split uses two edges.
This question belongs to: Computer Microsoft Office
Question #140
What is the default file extension for a macro-enabled presentation in MS PowerPoint (version 2007 and later)?
A. .potx
B. .pptm
C. .pptx
D. .ppsx
Discuss
Get Complete Subject PDF for Computer

Correct Answer: Option B

Explanation:
.pptm is the extension for PowerPoint macro-enabled presentation. .pptx is standard presentation, .ppsx is slideshow, .potx is template.
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
Microsoft Office 1199 Computer Fundamentals 326 Internet and Web Technologies 461 CPU (Central Processing Unit) 327 Computer Hardware 430
Explore Subjects
Current Affairs 575 English 15164 Static General Knowledge 6362 History GK 3374 Reasoning 1111
Practice Mix
The Macaulay's Minute dealt with:
Which major port is located on the Malabar Coast?
A census provides data that is:
Which of the following is the primary reason for the high rainfall in Cherrapunji?
Choose the correct active voice of: 'Has the mail been sent by the secretary?'