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 16 of 60
Question #301
In MS PowerPoint, which of the following is not a valid way to start a slideshow?
A. Alt + F5
B. Shift + F5
C. F5
D. Slide Show > From Beginning
Discuss
Get Complete Subject PDF for Computer

Correct Answer: Option A

Explanation:
Alt+F5 is not a standard shortcut for starting slideshow. F5 starts from beginning, Shift+F5 from current slide, and the menu option works.
This question belongs to: Computer Microsoft Office
Question #302
In Excel, which function is used to calculate the internal rate of return for a series of cash flows?
A. PV
B. RATE
C. NPV
D. IRR
Discuss
Get Complete Subject PDF for Computer

Correct Answer: Option D

Explanation:
IRR calculates the internal rate of return. NPV calculates net present value, PV present value, RATE interest rate.
This question belongs to: Computer Microsoft Office
Question #303
In MS Word, which of the following features is used to create an envelope or label?
A. Insert > Envelope
B. Mailings > Envelopes and Labels
C. Review > Envelopes
D. Home > Envelopes
Discuss
Get Complete Subject PDF for Computer

Correct Answer: Option B

Explanation:
Envelopes and Labels are under the Mailings tab.
This question belongs to: Computer Microsoft Office
Question #304
In Access, what is the purpose of the 'Validation Rule' property?
A. To restrict the values that can be entered in a field
B. To set a default value
C. To define a relationship
D. To format the field display
Discuss
Get Complete Subject PDF for Computer

Correct Answer: Option A

Explanation:
Validation Rule limits the data that can be entered, e.g., >0. Default Value sets initial value, Format controls display, Relationship links tables.
This question belongs to: Computer Microsoft Office
Question #305
What is the shortcut key to create a new document in MS Word?
A. Ctrl + N
B. Ctrl + S
C. Ctrl + O
D. Ctrl + P
Discuss
Get Complete Subject PDF for Computer

Correct Answer: Option A

Explanation:
Ctrl+N creates a new blank document. Ctrl+O opens, Ctrl+S saves, Ctrl+P prints.
This question belongs to: Computer Microsoft Office
Question #306
In Excel, which function is used to find the position of a substring within a string?
A. FIND
B. Both A and B
C. POSITION
D. SEARCH
Discuss
Get Complete Subject PDF for Computer

Correct Answer: Option B

Explanation:
FIND and SEARCH both return the position of a substring; FIND is case-sensitive, SEARCH is not. Both are valid.
This question belongs to: Computer Microsoft Office
Question #307
In MS PowerPoint, which option is used to group objects together so they can be moved or resized as one?
A. Combine
B. Ungroup
C. Merge
D. Group
Discuss
Get Complete Subject PDF for Computer

Correct Answer: Option D

Explanation:
Grouping objects allows them to be treated as a single object. Ungroup separates them.
This question belongs to: Computer Microsoft Office
Question #308
In MS Word, which of the following is used to create a table of contents based on heading styles?
A. References > Table of Contents
B. Review > Table of Contents
C. View > Table of Contents
D. Insert > Table of Contents
Discuss
Get Complete Subject PDF for Computer

Correct Answer: Option A

Explanation:
Table of Contents is under the References tab.
This question belongs to: Computer Microsoft Office
Question #309
In Excel, which function is used to calculate the present value of an annuity?
A. PV
B. PMT
C. FV
D. NPER
Discuss
Get Complete Subject PDF for Computer

Correct Answer: Option A

Explanation:
PV calculates present value, FV future value, PMT payment, NPER number of periods.
This question belongs to: Computer Microsoft Office
Question #310
In MS Access, which of the following is a valid query type that adds records from one table to another?
A. Append Query
B. Delete Query
C. Update Query
D. Make-Table Query
Discuss
Get Complete Subject PDF for Computer

Correct Answer: Option A

Explanation:
Append Query adds records from one table to another. Update modifies existing, Delete removes, Make-Table creates a new table.
This question belongs to: Computer Microsoft Office
Question #311
What is the shortcut key to open the 'Thesaurus' in MS Word?
A. F7
B. Ctrl + F7
C. Alt + F7
D. Shift + F7
Discuss
Get Complete Subject PDF for Computer

Correct Answer: Option D

Explanation:
Shift+F7 opens the Thesaurus. F7 runs spell check.
This question belongs to: Computer Microsoft Office
Question #312
In Excel, which chart type is used to show the relationship between two variables?
A. Bar Chart
B. Scatter Chart
C. Pie Chart
D. Line Chart
Discuss
Get Complete Subject PDF for Computer

Correct Answer: Option B

Explanation:
Scatter (or XY) charts show the relationship or correlation between two numeric variables. Line charts show trends, bar compare categories, pie proportions.
This question belongs to: Computer Microsoft Office
Question #313
In MS PowerPoint, which of the following is used to add a hyperlink to a shape or text?
A. All of the above
B. Right-click > Hyperlink
C. Insert > Link
D. Ctrl + K
Discuss
Get Complete Subject PDF for Computer

Correct Answer: Option A

Explanation:
All methods can insert a hyperlink: Insert > Link, Ctrl+K, or right-click and select Hyperlink.
This question belongs to: Computer Microsoft Office
Question #314
In MS Word, which of the following is not a feature of the 'Mail Merge'?
A. Letters
B. Envelopes
C. Spreadsheets
D. Labels
Discuss
Get Complete Subject PDF for Computer

Correct Answer: Option C

Explanation:
Mail Merge can create letters, labels, envelopes, and emails. Spreadsheets are data sources, not output.
This question belongs to: Computer Microsoft Office
Question #315
In Access, which of the following is used to create a calculated field in a query?
A. Field row with a calculated expression
B. Design View only
C. Both A and B
D. Expression Builder
Discuss
Get Complete Subject PDF for Computer

Correct Answer: Option C

Explanation:
You can create calculated fields by typing an expression in the Field row of the query design grid, or using the Expression Builder. Both are valid.
This question belongs to: Computer Microsoft Office
Question #316
What is the shortcut key to open the 'Replace' dialog in MS Excel?
A. Ctrl + G
B. F5
C. Ctrl + H
D. Ctrl + F
Discuss
Get Complete Subject PDF for Computer

Correct Answer: Option C

Explanation:
Ctrl+H opens Find and Replace with Replace tab active. Ctrl+F opens Find, Ctrl+G is Go To.
This question belongs to: Computer Microsoft Office
Question #317
In MS PowerPoint, which feature allows you to create a photo album presentation?
A. Insert > Pictures
B. Insert > Photo Album
C. Design > Photo Album
D. Photo Album
Discuss
Get Complete Subject PDF for Computer

Correct Answer: Option D

Explanation:
PowerPoint has a 'Photo Album' feature under Insert > Photo Album (in some versions) or File > New > Photo Album. It automates creating a presentation with pictures.
This question belongs to: Computer Microsoft Office
Question #318
In Excel, which function is used to calculate the future value of an investment?
A. PMT
B. NPER
C. FV
D. PV
Discuss
Get Complete Subject PDF for Computer

Correct Answer: Option C

Explanation:
FV calculates future value based on periodic payments and interest.
This question belongs to: Computer Microsoft Office
Question #319
In MS Word, which of the following is a type of section break?
A. Next Page
B. Continuous
C. Even Page
D. All of the above
Discuss
Get Complete Subject PDF for Computer

Correct Answer: Option D

Explanation:
Word provides Next Page, Continuous, Even Page, and Odd Page section breaks.
This question belongs to: Computer Microsoft Office
Question #320
In Access, which of the following is a valid data type for storing yes/no values?
A. All of the above
B. Yes/No
C. Logical
D. Boolean
Discuss
Get Complete Subject PDF for Computer

Correct Answer: Option B

Explanation:
The data type in Access is called 'Yes/No' (or sometimes 'Boolean' in other databases). Access uses Yes/No. So B is correct.
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?'