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 49 of 60
Question #961
Which of the following is NOT a SmartArt category in MS Office?
A. Cycle
B. Hierarchy
C. Graphic Design
D. Relationship
Discuss
Get Complete Subject PDF for Computer

Correct Answer: Option C

Explanation:
SmartArt categories: List, Process, Cycle, Hierarchy, Relationship, Matrix, Pyramid, Picture, etc. Graphic Design is not a category.
This question belongs to: Computer Microsoft Office
Question #962
In MS Access, to set a field as the primary key, use:
A. Create tab -> Primary Key
B. Table Design view -> select field -> Primary Key button
C. Database Tools -> Relationships
D. Datasheet view -> right-click -> Primary Key
Discuss
Get Complete Subject PDF for Computer

Correct Answer: Option B

Explanation:
Primary Key is set in Design view.
This question belongs to: Computer Microsoft Office
Question #963
In MS Word, the 'Ctrl + Shift + L' shortcut applies:
A. Numbered list
B. Line spacing
C. Bullet style (toggles bullet list)
D. Left alignment
Discuss
Get Complete Subject PDF for Computer

Correct Answer: Option C

Explanation:
Ctrl+Shift+L applies or removes bullet formatting.
This question belongs to: Computer Microsoft Office
Question #964
In PowerPoint, the 'Handout Master' is used to:
A. Insert multimedia
B. Edit slide transitions
C. Design slide backgrounds
D. Define the layout of printed handouts for the audience
Discuss
Get Complete Subject PDF for Computer

Correct Answer: Option D

Explanation:
Handout Master formats printed handout pages.
This question belongs to: Computer Microsoft Office
Question #965
In MS Access, what is the purpose of the 'Relationship' window?
A. Define connections between tables and enforce referential integrity
B. Design queries
C. Create forms
D. Set user permissions
Discuss
Get Complete Subject PDF for Computer

Correct Answer: Option A

Explanation:
Relationships window links tables.
This question belongs to: Computer Microsoft Office
Question #966
Which key should be pressed to edit a selected chart in Excel?
A. Ctrl + F
B. Alt + F1
C. F2 (if chart element is selected) or right-click
D. F11
Discuss
Get Complete Subject PDF for Computer

Correct Answer: Option C

Explanation:
F2 may activate editing, but typically you click or right-click. I'll rephrase: To edit chart title directly, click twice or press F2. So answer A.
This question belongs to: Computer Microsoft Office
Question #967
In MS Word, the 'Cover Page' feature inserts a:
A. Title only
B. Blank page at the beginning
C. Table of contents
D. Pre-designed first page with placeholders
Discuss
Get Complete Subject PDF for Computer

Correct Answer: Option D

Explanation:
Cover Page provides styled title pages.
This question belongs to: Computer Microsoft Office
Question #968
In Excel, the function =NETWORKDAYS(start, end) returns:
A. Number of calendar days
B. Days including holidays
C. Number of working days (excluding weekends) between dates
D. Total days between dates
Discuss
Get Complete Subject PDF for Computer

Correct Answer: Option C

Explanation:
NETWORKDAYS excludes Saturdays and Sundays and optionally holidays.
This question belongs to: Computer Microsoft Office
Question #969
In PowerPoint, what is the function of the 'Reuse Slides' option?
A. Reformat all slides
B. Insert slides from another presentation without copying manually
C. Reset slide layout
D. Duplicate the current slide
Discuss
Get Complete Subject PDF for Computer

Correct Answer: Option B

Explanation:
Reuse Slides (Home tab -> New Slide dropdown) imports slides from other presentations.
This question belongs to: Computer Microsoft Office
Question #970
In MS Access, which of the following is an example of an action query?
A. Parameter query
B. Select query
C. Crosstab query
D. Update query
Discuss
Get Complete Subject PDF for Computer

Correct Answer: Option D

Explanation:
Action queries: Update, Delete, Append, Make-Table.
This question belongs to: Computer Microsoft Office
Question #971
To close a presentation in PowerPoint, press:
A. Alt + F4
B. Both A and B
C. Ctrl + W
D. Ctrl + F4
Discuss
Get Complete Subject PDF for Computer

Correct Answer: Option B

Explanation:
Ctrl+W or Ctrl+F4 closes the active presentation window. Alt+F4 exits PowerPoint.
This question belongs to: Computer Microsoft Office
Question #972
In MS Word, to insert the current date that updates automatically, use:
A. Press Alt + Shift + D
B. Both A and B
C. Insert -> Date & Time -> Update automatically
D. Type DATE()
Discuss
Get Complete Subject PDF for Computer

Correct Answer: Option B

Explanation:
Insert Date & Time with Update automatically inserts a field. Alt+Shift+D inserts a DATE field.
This question belongs to: Computer Microsoft Office
Question #973
In Excel, which of the following is NOT a valid data validation criteria?
A. List
B. Decimal
C. Formula only
D. Whole number
Discuss
Get Complete Subject PDF for Computer

Correct Answer: Option C

Explanation:
Data validation allows Any value, Whole number, Decimal, List, Date, Time, Text length, Custom. There is no 'Formula only'.
This question belongs to: Computer Microsoft Office
Question #974
In PowerPoint, to add a footer to all slides, go to:
A. Design -> Slide Size
B. View -> Slide Master -> Insert Footer
C. Transitions -> Footer
D. Insert -> Header & Footer
Discuss
Get Complete Subject PDF for Computer

Correct Answer: Option D

Explanation:
Header & Footer dialog adds date, slide number, custom text.
This question belongs to: Computer Microsoft Office
Question #975
In MS Access, which property makes a text field accept only uppercase letters?
A. Validation Rule
B. Both A and B
C. Format property set to >
D. Input Mask with >
Discuss
Get Complete Subject PDF for Computer

Correct Answer: Option B

Explanation:
Format > displays uppercase. Input mask > forces entry to uppercase. Both can achieve.
This question belongs to: Computer Microsoft Office
Question #976
What is the shortcut to quickly switch between the open document windows in MS Word?
A. Ctrl + F6
B. Alt + F6
C. Ctrl + Tab
D. Both A and C
Discuss
Get Complete Subject PDF for Computer

Correct Answer: Option D

Explanation:
Ctrl+F6 and Ctrl+Tab cycle through open document windows.
This question belongs to: Computer Microsoft Office
Question #977
In Excel, the chart type 'Combo' allows:
A. Combining two different chart types in one chart (e.g., column and line)
B. Grouping multiple charts together
C. Adding a secondary axis
D. Creating a chart from multiple sheets
Discuss
Get Complete Subject PDF for Computer

Correct Answer: Option A

Explanation:
Combo charts mix different chart types for different data series.
This question belongs to: Computer Microsoft Office
Question #978
In PowerPoint, which key can be used to zoom in on a slide during editing?
A. Alt + Plus
B. Both A and B
C. Ctrl + Mouse wheel up
D. Ctrl + Plus (+)
Discuss
Get Complete Subject PDF for Computer

Correct Answer: Option B

Explanation:
Ctrl+Plus or Ctrl+Scroll up zooms in.
This question belongs to: Computer Microsoft Office
Question #979
In MS Access, which data type stores a calculated value that depends on other fields?
A. Memo
B. Number
C. Calculated
D. AutoNumber
Discuss
Get Complete Subject PDF for Computer

Correct Answer: Option C

Explanation:
Calculated data type creates a field whose value is computed.
This question belongs to: Computer Microsoft Office
Question #980
To apply double line spacing in MS Word, press:
A. Ctrl + 5
B. Ctrl + 2
C. Ctrl + D
D. Ctrl + 1
Discuss
Get Complete Subject PDF for Computer

Correct Answer: Option B

Explanation:
Ctrl+2 double spacing.
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 Software 347 CPU (Central Processing Unit) 327 Memory and Storage Devices 438 Programming Languages 0 Cyber Security 269
Explore Subjects
Computer 5279 History GK 3374 Maths 5575 Accountancy and Statistics 3179 Current Affairs 575
Practice Mix
Find the word most OPPOSITE in meaning to 'OPAQUE'.
Which organization focuses on protecting global biological diversity?
Which of these is the most recently formed national park in India among the options provided?
A mixture of two immiscible liquids can be separated by:
The 'Gol Gumbaz' in Bijapur has a whispering gallery. This architectural feature is an example of: