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 15 of 60
Question #281
What is the shortcut key to insert a new slide in MS PowerPoint?
A. Ctrl + D
B. Ctrl + N
C. Ctrl + Shift + N
D. Ctrl + M
Discuss
Get Complete Subject PDF for Computer

Correct Answer: Option D

Explanation:
Ctrl+M inserts a new slide. Ctrl+N creates a new presentation. Ctrl+D duplicates slide.
This question belongs to: Computer Microsoft Office
Question #282
In Excel, which function is used to convert a number to text with a specific format?
A. FORMAT
B. TEXT
C. VALUE
D. NUMBER
Discuss
Get Complete Subject PDF for Computer

Correct Answer: Option B

Explanation:
TEXT converts a numeric value to text with a specified number format. VALUE converts text to number.
This question belongs to: Computer Microsoft Office
Question #283
In MS Word, what is the purpose of the 'Style' feature?
A. To change the document's font
B. To apply consistent formatting to headings and other elements
C. To create a table of contents
D. To add a watermark
Discuss
Get Complete Subject PDF for Computer

Correct Answer: Option B

Explanation:
Styles are sets of formatting attributes that can be applied to text for consistency and to enable features like Table of Contents.
This question belongs to: Computer Microsoft Office
Question #284
In MS Access, which of the following is used to create a user interface for data entry?
A. Query
B. Form
C. Macro
D. Report
Discuss
Get Complete Subject PDF for Computer

Correct Answer: Option B

Explanation:
Forms are the primary interface for data entry and editing. Reports are for output, queries for data retrieval, macros for automation.
This question belongs to: Computer Microsoft Office
Question #285
What is the shortcut key to undo the last action in MS Office?
A. Ctrl + Z
B. Both A and C
C. Ctrl + Y
D. Alt + Backspace
Discuss
Get Complete Subject PDF for Computer

Correct Answer: Option B

Explanation:
Ctrl+Z is the standard undo, and Alt+Backspace also works in many Office apps as undo. So both are valid.
This question belongs to: Computer Microsoft Office
Question #286
In Excel, which function is used to calculate the average of a set of numbers but ignores zero values?
A. AVERAGEA
B. AVERAGEIF
C. MEDIAN
D. AVERAGE
Discuss
Get Complete Subject PDF for Computer

Correct Answer: Option B

Explanation:
AVERAGEIF can exclude zero by using criteria 0. AVERAGE includes zeros, AVERAGEA includes logicals, MEDIAN is middle value.
This question belongs to: Computer Microsoft Office
Question #287
In MS PowerPoint, which pane allows you to add speaker notes?
A. Task pane
B. Slides pane
C. Outline pane
D. Notes pane
Discuss
Get Complete Subject PDF for Computer

Correct Answer: Option D

Explanation:
The Notes pane (below the slide in Normal view) is where you type speaker notes. Outline pane shows text outline.
This question belongs to: Computer Microsoft Office
Question #288
In MS Word, which of the following is used to insert a comment?
A. Ctrl + Alt + M
B. Review > New Comment
C. All of the above
D. Insert > Comment
Discuss
Get Complete Subject PDF for Computer

Correct Answer: Option C

Explanation:
You can insert a comment via Review > New Comment, or Insert > Comment (in some versions), or the shortcut Ctrl+Alt+M. So all are valid.
This question belongs to: Computer Microsoft Office
Question #289
In MS Access, which of the following is not a valid field property?
A. Sort Order
B. Field Size
C. Caption
D. Format
Discuss
Get Complete Subject PDF for Computer

Correct Answer: Option A

Explanation:
Field properties include Field Size, Format, Caption, Default Value, etc. Sort Order is not a field property; sorting is applied in queries or tables via the Sort row.
This question belongs to: Computer Microsoft Office
Question #290
What is the shortcut key to open the 'Symbol' dialog in MS Word?
A. Alt + Ctrl + S
B. Both A and B
C. Insert > Symbol
D. Alt + N, U, S
Discuss
Get Complete Subject PDF for Computer

Correct Answer: Option B

Explanation:
You can insert symbol via Insert > Symbol, and the keyboard shortcut Alt+N,U,S (or Alt+I,S in older versions) opens the Symbol dialog. So both are valid.
This question belongs to: Computer Microsoft Office
Question #291
In Excel, which function is used to return the number of rows in a range?
A. COLUMNS
B. COUNT
C. ROWS
D. ROW
Discuss
Get Complete Subject PDF for Computer

Correct Answer: Option C

Explanation:
ROWS returns the count of rows in a reference. ROW returns the row number of a reference. COLUMNS returns column count.
This question belongs to: Computer Microsoft Office
Question #292
In MS PowerPoint, which option is used to hide a slide during a presentation?
A. Ignore Slide
B. Skip Slide
C. Mute Slide
D. Hide Slide
Discuss
Get Complete Subject PDF for Computer

Correct Answer: Option D

Explanation:
You can right-click a slide in the thumbnail pane and select 'Hide Slide' to skip it during the slideshow. It remains in the file but not shown.
This question belongs to: Computer Microsoft Office
Question #293
In MS Word, which of the following is used to create a mail merge document?
A. Mailings tab
B. Insert tab
C. Review tab
D. References tab
Discuss
Get Complete Subject PDF for Computer

Correct Answer: Option A

Explanation:
Mail Merge features are located under the Mailings tab in Word.
This question belongs to: Computer Microsoft Office
Question #294
In Access, which of the following is a valid expression for a query criterion?
A. Like 'S*'
B. Between #1/1/2020# And #12/31/2020#
C. >100
D. All of the above
Discuss
Get Complete Subject PDF for Computer

Correct Answer: Option D

Explanation:
All are valid criteria expressions in Access queries.
This question belongs to: Computer Microsoft Office
Question #295
What is the shortcut key to insert a hyperlink in MS Word?
A. Ctrl + I
B. Ctrl + L
C. Ctrl + K
D. Ctrl + H
Discuss
Get Complete Subject PDF for Computer

Correct Answer: Option C

Explanation:
Ctrl + K inserts a hyperlink in Word, Excel, and PowerPoint.
This question belongs to: Computer Microsoft Office
Question #296
In Excel, which function is used to calculate the standard deviation of a sample?
A. Both A and C
B. STDEV
C. STDEV.S
D. STDEV.P
Discuss
Get Complete Subject PDF for Computer

Correct Answer: Option A

Explanation:
STDEV.S calculates sample standard deviation; STDEV is the older version that also does sample. STDEV.P is population standard deviation.
This question belongs to: Computer Microsoft Office
Question #297
In MS PowerPoint, which option allows you to add a transition effect to a slide?
A. Slide Show tab
B. Animations tab
C. Design tab
D. Transitions tab
Discuss
Get Complete Subject PDF for Computer

Correct Answer: Option D

Explanation:
Slide transitions are on the Transitions tab. Animations are for objects within slides.
This question belongs to: Computer Microsoft Office
Question #298
In MS Word, the 'Thesaurus' command is under which group in the Review tab?
A. Comments
B. Proofing
C. Tracking
D. Language
Discuss
Get Complete Subject PDF for Computer

Correct Answer: Option B

Explanation:
The Thesaurus is in the Proofing group along with Spelling & Grammar, Word Count, etc.
This question belongs to: Computer Microsoft Office
Question #299
In Access, which of the following is a valid way to create a relationship between two tables?
A. Use the Relationships window
B. Create a query that joins them
C. Drag the primary key field from one table to the foreign key field in another
D. Both A and B
Discuss
Get Complete Subject PDF for Computer

Correct Answer: Option D

Explanation:
You can create relationships by dragging fields in the Relationships window, or use the Relationships window to add tables and define relationships. Queries join tables but don't enforce relationships.
This question belongs to: Computer Microsoft Office
Question #300
What is the shortcut key to open the 'Find' dialog in MS Excel?
A. Ctrl + H
B. Ctrl + F
C. Ctrl + G
D. F5
Discuss
Get Complete Subject PDF for Computer

Correct Answer: Option B

Explanation:
Ctrl+F opens Find and Replace with Find tab. Ctrl+G is Go To, Ctrl+H is Replace, F5 also Go To.
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?'