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. Slide Sorter View
C. All of the above
D. Normal View
Discuss
Get Complete Subject PDF for Computer

Correct Answer: Option B

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. Design > Columns
B. Layout > Columns
C. Insert > Columns
D. Home > Columns
Discuss
Get Complete Subject PDF for Computer

Correct Answer: Option B

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. Cascade Delete Related Records
B. Cascade Update Related Fields
C. Both A and B
D. Neither
Discuss
Get Complete Subject PDF for Computer

Correct Answer: Option C

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. F4
B. Ctrl + Shift + C and Ctrl + Shift + V
C. There is no direct shortcut
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. PMT
B. IRR
C. RATE
D. NPER
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 > Table
B. Insert > Chart
C. Insert > Shapes
D. Insert > SmartArt
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. Insert > Numbering
B. Review > 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. AutoNumber
B. Image
C. Currency
D. Yes/No
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 + G
B. Both A and B
C. F5
D. Ctrl + H
Discuss
Get Complete Subject PDF for Computer

Correct Answer: Option B

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. MAXA
B. LARGE
C. MAXIFS
D. MAX
Discuss
Get Complete Subject PDF for Computer

Correct Answer: Option C

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. Design > Background Styles
C. Both A and C
D. Insert > Picture
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. Review > Mail Merge
B. References > Mail Merge
C. Mailings > Start Mail Merge
D. Insert > Mail Merge
Discuss
Get Complete Subject PDF for Computer

Correct Answer: Option C

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. Select Query
B. Parameter Query
C. Action Query
D. Crosstab 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. Shift + F11
C. Alt + I, W
D. Ctrl + Shift + N
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. Animations tab
B. Design tab
C. Slide Show tab
D. Transitions tab
Discuss
Get Complete Subject PDF for Computer

Correct Answer: Option A

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. Both A and B
C. File > Options > Proofing > Show readability statistics
D. View > Readability
Discuss
Get Complete Subject PDF for Computer

Correct Answer: Option B

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. All of the above
B. LINEST
C. INTERCEPT
D. SLOPE
Discuss
Get Complete Subject PDF for Computer

Correct Answer: Option A

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. Create > Report Wizard
B. All of the above
C. Create > Report Design
D. Create > Report
Discuss
Get Complete Subject PDF for Computer

Correct Answer: Option B

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 + F2
B. All of the above
C. Ctrl + P
D. Alt + F, P
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. Insert > SmartArt
D. Both A and B
Discuss
Get Complete Subject PDF for Computer

Correct Answer: Option D

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
Computer Hardware 430 Operating Systems 510 Programming Languages 0 Cyber Security 269 Database Management System (DBMS) 278
Explore Subjects
Reasoning 2064 Science 4430 Accountancy and Statistics 3179 Economy GK 2220 Computer 5279
Practice Mix
Which national park in Himachal Pradesh is known for its high-altitude grasslands and is a key habitat for the Himalayan Tahr?
Who was the first Indian to be the Coordination Secretary?
Which of the following is an example of an animal cell that lacks a nucleus in its mature form?
What is the primary limitation of configuring a network using a point-to-point Full Mesh Topology as the number of nodes scales high?
Double fertilization in angiosperms was discovered by: