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 19 of 60
Question #361
In MS PowerPoint, which option is used to change the order of slides?
A. Outline View
B. Normal View
C. Slide Sorter View
D. All of the above
Discuss
Get Complete Subject PDF for Computer

Correct Answer: Option C

Explanation:
Slide Sorter View is specifically for rearranging slides, but you can also drag in Normal View or Outline. However, Slide Sorter is the primary view for reordering.
This question belongs to: Computer Microsoft Office
Question #362
In Word, which of the following is used to create a column layout?
A. Layout > Columns
B. Design > Columns
C. Insert > Columns
D. Home > Columns
Discuss
Get Complete Subject PDF for Computer

Correct Answer: Option A

Explanation:
Columns are under the Layout tab (Page Setup group). In newer versions it's Layout > Columns.
This question belongs to: Computer Microsoft Office
Question #363
In Access, which of the following is a valid way to enforce referential integrity?
A. Both A and B
B. Cascade Update Related Fields
C. Neither
D. Cascade Delete Related Records
Discuss
Get Complete Subject PDF for Computer

Correct Answer: Option A

Explanation:
When defining a relationship, you can set referential integrity and optionally cascade update/delete. Both are options.
This question belongs to: Computer Microsoft Office
Question #364
What is the shortcut key to open the 'Format Painter' in MS Office?
A. There is no direct shortcut
B. Ctrl + Shift + C and Ctrl + Shift + V
C. F4
D. Alt + Ctrl + C
Discuss
Get Complete Subject PDF for Computer

Correct Answer: Option B

Explanation:
You can copy formatting with Ctrl+Shift+C and paste with Ctrl+Shift+V. There is no single shortcut for Format Painter.
This question belongs to: Computer Microsoft Office
Question #365
In Excel, which function is used to calculate the interest rate per period of a loan?
A. NPER
B. IRR
C. RATE
D. PMT
Discuss
Get Complete Subject PDF for Computer

Correct Answer: Option C

Explanation:
RATE calculates interest rate per period.
This question belongs to: Computer Microsoft Office
Question #366
In MS PowerPoint, which of the following is used to add a chart?
A. Insert > SmartArt
B. Insert > Chart
C. Insert > Shapes
D. Insert > Table
Discuss
Get Complete Subject PDF for Computer

Correct Answer: Option B

Explanation:
Chart is under Insert > Chart.
This question belongs to: Computer Microsoft Office
Question #367
In Word, which of the following is used to apply numbering to a list?
A. Review > Numbering
B. Insert > Numbering
C. References > Numbering
D. Home > Numbering
Discuss
Get Complete Subject PDF for Computer

Correct Answer: Option D

Explanation:
Numbering is in the Home tab, Paragraph group.
This question belongs to: Computer Microsoft Office
Question #368
In Access, which of the following is not a valid data type for a field?
A. Currency
B. Image
C. Yes/No
D. AutoNumber
Discuss
Get Complete Subject PDF for Computer

Correct Answer: Option B

Explanation:
There is no 'Image' data type; you use Attachment or OLE Object to store images.
This question belongs to: Computer Microsoft Office
Question #369
What is the shortcut key to open the 'Go To' dialog in MS Word?
A. Ctrl + H
B. Ctrl + G
C. Both A and B
D. F5
Discuss
Get Complete Subject PDF for Computer

Correct Answer: Option C

Explanation:
F5 and Ctrl+G both open the Go To dialog in Word.
This question belongs to: Computer Microsoft Office
Question #370
In Excel, which function is used to find the largest value that meets a condition?
A. MAXIFS
B. MAXA
C. MAX
D. LARGE
Discuss
Get Complete Subject PDF for Computer

Correct Answer: Option A

Explanation:
MAXIFS returns the maximum value based on criteria.
This question belongs to: Computer Microsoft Office
Question #371
In MS PowerPoint, which option is used to add a slide background picture?
A. Format Background > Picture or texture fill
B. Insert > Picture
C. Both A and C
D. Design > Background Styles
Discuss
Get Complete Subject PDF for Computer

Correct Answer: Option C

Explanation:
You can set a background picture via Format Background (right-click slide) or via Design > Background Styles > Format Background. Both lead to the same pane.
This question belongs to: Computer Microsoft Office
Question #372
In Word, which of the following is used to create a mail merge?
A. References > Mail Merge
B. Mailings > Start Mail Merge
C. Review > Mail Merge
D. Insert > Mail Merge
Discuss
Get Complete Subject PDF for Computer

Correct Answer: Option B

Explanation:
Mail Merge is under the Mailings tab.
This question belongs to: Computer Microsoft Office
Question #373
In Access, which of the following is used to create a query that asks for user input?
A. Action Query
B. Parameter Query
C. Crosstab Query
D. Select Query
Discuss
Get Complete Subject PDF for Computer

Correct Answer: Option B

Explanation:
Parameter queries prompt for input.
This question belongs to: Computer Microsoft Office
Question #374
What is the shortcut key to insert a new worksheet in Excel?
A. Both A and B
B. Alt + I, W
C. Ctrl + Shift + N
D. Shift + F11
Discuss
Get Complete Subject PDF for Computer

Correct Answer: Option A

Explanation:
Shift+F11 inserts a new worksheet, and Alt+I,W is the old menu shortcut. So both are valid.
This question belongs to: Computer Microsoft Office
Question #375
In MS PowerPoint, which of the following is used to animate an object on a slide?
A. Transitions tab
B. Design tab
C. Animations tab
D. Slide Show tab
Discuss
Get Complete Subject PDF for Computer

Correct Answer: Option C

Explanation:
Object animations are on the Animations tab.
This question belongs to: Computer Microsoft Office
Question #376
In Word, which of the following is used to check the readability statistics?
A. Review > Spelling & Grammar > Options > Show readability statistics
B. File > Options > Proofing > Show readability statistics
C. View > Readability
D. Both A and B
Discuss
Get Complete Subject PDF for Computer

Correct Answer: Option D

Explanation:
You enable readability statistics in File > Options > Proofing, and then run Spelling & Grammar to see them. So both A and B are part of the process.
This question belongs to: Computer Microsoft Office
Question #377
In Excel, which function is used to calculate the slope of a linear regression line?
A. INTERCEPT
B. All of the above
C. SLOPE
D. LINEST
Discuss
Get Complete Subject PDF for Computer

Correct Answer: Option B

Explanation:
SLOPE, INTERCEPT, and LINEST can all be used for linear regression analysis (LINEST returns array).
This question belongs to: Computer Microsoft Office
Question #378
In Access, which of the following is a valid way to create a report?
A. All of the above
B. Create > Report
C. Create > Report Wizard
D. Create > Report Design
Discuss
Get Complete Subject PDF for Computer

Correct Answer: Option A

Explanation:
All methods create reports.
This question belongs to: Computer Microsoft Office
Question #379
What is the shortcut key to open the 'Print' preview in MS Office?
A. Ctrl + P
B. All of the above
C. Alt + F, P
D. Ctrl + F2
Discuss
Get Complete Subject PDF for Computer

Correct Answer: Option B

Explanation:
Ctrl+F2 opens print preview in some apps, Ctrl+P opens print dialog/backstage, Alt+F,P also opens print. So all are valid.
This question belongs to: Computer Microsoft Office
Question #380
In MS PowerPoint, which of the following is used to insert a SmartArt graphic?
A. Insert > Illustrations > SmartArt
B. Insert > Graphic
C. Both A and B
D. Insert > SmartArt
Discuss
Get Complete Subject PDF for Computer

Correct Answer: Option C

Explanation:
SmartArt is under Insert > SmartArt or Insert > Illustrations > SmartArt.
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?'