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. Hierarchy
B. Graphic Design
C. Relationship
D. Cycle
Discuss
Get Complete Subject PDF for Computer

Correct Answer: Option B

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. Datasheet view -> right-click -> Primary Key
B. Database Tools -> Relationships
C. Create tab -> Primary Key
D. Table Design view -> select field -> Primary Key button
Discuss
Get Complete Subject PDF for Computer

Correct Answer: Option D

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. Bullet style (toggles bullet list)
B. Line spacing
C. Numbered list
D. Left alignment
Discuss
Get Complete Subject PDF for Computer

Correct Answer: Option A

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. Define the layout of printed handouts for the audience
B. Insert multimedia
C. Edit slide transitions
D. Design slide backgrounds
Discuss
Get Complete Subject PDF for Computer

Correct Answer: Option A

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. Design queries
B. Create forms
C. Define connections between tables and enforce referential integrity
D. Set user permissions
Discuss
Get Complete Subject PDF for Computer

Correct Answer: Option C

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. F2 (if chart element is selected) or right-click
B. Ctrl + F
C. F11
D. Alt + F1
Discuss
Get Complete Subject PDF for Computer

Correct Answer: Option A

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. Table of contents
B. Pre-designed first page with placeholders
C. Blank page at the beginning
D. Title only
Discuss
Get Complete Subject PDF for Computer

Correct Answer: Option B

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. Days including holidays
B. Number of calendar days
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. Insert slides from another presentation without copying manually
B. Reformat all slides
C. Reset slide layout
D. Duplicate the current slide
Discuss
Get Complete Subject PDF for Computer

Correct Answer: Option A

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. Crosstab query
B. Update query
C. Select query
D. Parameter query
Discuss
Get Complete Subject PDF for Computer

Correct Answer: Option B

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. Ctrl + F4
C. Both A and B
D. Ctrl + W
Discuss
Get Complete Subject PDF for Computer

Correct Answer: Option C

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. Decimal
B. Formula only
C. List
D. Whole number
Discuss
Get Complete Subject PDF for Computer

Correct Answer: Option B

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. Insert -> Header & Footer
B. Transitions -> Footer
C. Design -> Slide Size
D. View -> Slide Master -> Insert Footer
Discuss
Get Complete Subject PDF for Computer

Correct Answer: Option A

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. Both A and B
B. Validation Rule
C. Input Mask with >
D. Format property set to >
Discuss
Get Complete Subject PDF for Computer

Correct Answer: Option A

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. Both A and C
D. Ctrl + Tab
Discuss
Get Complete Subject PDF for Computer

Correct Answer: Option C

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. Adding a secondary axis
C. Creating a chart from multiple sheets
D. Grouping multiple charts together
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. Ctrl + Plus (+)
C. Both A and B
D. Ctrl + Mouse wheel up
Discuss
Get Complete Subject PDF for Computer

Correct Answer: Option C

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. Number
B. Calculated
C. Memo
D. AutoNumber
Discuss
Get Complete Subject PDF for Computer

Correct Answer: Option B

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 + 1
D. Ctrl + D
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
Internet and Web Technologies 461 Computer Hardware 430 Microsoft Office 1199 Computer Abbreviations 369 Operating Systems 510
Explore Subjects
Static General Knowledge 6362 Reasoning 2064 Current Affairs 575 Science 4430 English 15164
Practice Mix
Which of the following is a major source of tax revenue for the Central Government?
Two numbers are in the ratio 11:5 and their sum is 789. Find the numbers.
Which of the following is a characteristic of the 'Lodi' style of architecture?
In a class of 50 students, 60% are boys. Number of girls is:
Select the most appropriate meaning of the idiom: 'In the doldrums'.