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 60 of 60
Question #1181
In MS Word, the 'Ctrl + Shift + A' shortcut:
A. Applies bold
B. Selects all
C. Toggles all caps
D. Opens font dialog
Discuss
Get Complete Subject PDF for Computer

Correct Answer: Option C

Explanation:
Ctrl+Shift+A toggles UPPERCASE.
This question belongs to: Computer Microsoft Office
Question #1182
In PowerPoint, the 'Morph' transition requires:
A. A video file
B. An add-in
C. Two slides with common objects that change position, size, or formatting
D. A 3D model
Discuss
Get Complete Subject PDF for Computer

Correct Answer: Option C

Explanation:
Morph animates smooth changes between slides with same objects.
This question belongs to: Computer Microsoft Office
Question #1183
In MS Access, the 'Allow Zero Length' property is relevant for:
A. Date fields
B. Number fields
C. All fields
D. Text and Memo (Long Text) fields
Discuss
Get Complete Subject PDF for Computer

Correct Answer: Option D

Explanation:
Only text-based fields.
This question belongs to: Computer Microsoft Office
Question #1184
Which of the following is the default file extension for a Word template?
A. .doc
B. .dotx
C. .docx
D. .dot
Discuss
Get Complete Subject PDF for Computer

Correct Answer: Option B

Explanation:
.dotx is Word template.
This question belongs to: Computer Microsoft Office
Question #1185
In Excel, the 'Paste Special' option 'Values' pastes:
A. Formulas only
B. Formatting only
C. Comments only
D. Only the values, not formulas or formatting
Discuss
Get Complete Subject PDF for Computer

Correct Answer: Option D

Explanation:
Values pastes the results of formulas.
This question belongs to: Computer Microsoft Office
Question #1186
In MS Word, the 'Ctrl + Alt + 1' shortcut applies:
A. Heading 1 style
B. Font size 1
C. Bullet list
D. Single line spacing
Discuss
Get Complete Subject PDF for Computer

Correct Answer: Option A

Explanation:
Ctrl+Alt+1 applies Heading 1, Ctrl+Alt+2 Heading 2, etc.
This question belongs to: Computer Microsoft Office
Question #1187
In PowerPoint, to add a sound that plays across multiple slides, use:
A. Audio Tools Playback -> Play Across Slides
B. Insert -> Audio -> Play Across
C. Transitions -> Sound
D. Animations -> Sound
Discuss
Get Complete Subject PDF for Computer

Correct Answer: Option A

Explanation:
Play Across Slides under Playback tab.
This question belongs to: Computer Microsoft Office
Question #1188
In MS Access, the 'Format' property for a Yes/No field can display:
A. Both A and C
B. True/False, Yes/No, or On/Off
C. 0/1 only
D. Checked/Unchecked
Discuss
Get Complete Subject PDF for Computer

Correct Answer: Option B

Explanation:
Format property controls display.
This question belongs to: Computer Microsoft Office
Question #1189
What is the shortcut to maximize a document window in MS Word?
A. Ctrl + F12
B. Ctrl + F10
C. F11
D. Alt + F10
Discuss
Get Complete Subject PDF for Computer

Correct Answer: Option B

Explanation:
Ctrl+F10 maximizes document window.
This question belongs to: Computer Microsoft Office
Question #1190
In Excel, the 'Goal Seek' tool is found under:
A. Formulas tab
B. Insert tab
C. Review tab
D. Data tab -> What-If Analysis -> Goal Seek
Discuss
Get Complete Subject PDF for Computer

Correct Answer: Option D

Explanation:
Goal Seek is under Data > What-If Analysis.
This question belongs to: Computer Microsoft Office
Question #1191
In MS Word, the 'Ctrl + ]' shortcut:
A. Increases indent
B. Applies superscript
C. Increases line spacing
D. Increases font size by 1 point
Discuss
Get Complete Subject PDF for Computer

Correct Answer: Option D

Explanation:
Ctrl+] grows font 1 point.
This question belongs to: Computer Microsoft Office
Question #1192
In PowerPoint, which of the following is NOT a standard slide layout?
A. Section Header
B. Chart Slide
C. Title and 2 Content
D. Comparison
Discuss
Get Complete Subject PDF for Computer

Correct Answer: Option B

Explanation:
Chart Slide is not a built-in layout.
This question belongs to: Computer Microsoft Office
Question #1193
In MS Access, a 'Table' object stores data in:
A. Pages
B. Rows (records) and columns (fields)
C. Forms
D. Reports
Discuss
Get Complete Subject PDF for Computer

Correct Answer: Option B

Explanation:
Table structure is rows and columns.
This question belongs to: Computer Microsoft Office
Question #1194
Which of the following is the correct keyboard shortcut to open the 'Format Cells' dialog in Excel?
A. Ctrl + 1
B. Both A and B
C. Ctrl + 2
D. Ctrl + Shift + F
Discuss
Get Complete Subject PDF for Computer

Correct Answer: Option B

Explanation:
Both open Format Cells, but Ctrl+1 opens main, Ctrl+Shift+F opens Font tab.
This question belongs to: Computer Microsoft Office
Question #1195
In MS Word, the 'Ctrl + Alt + N' shortcut switches to:
A. Normal view (deprecated)
B. Draft view
C. Outline view
D. Print Layout view
Discuss
Get Complete Subject PDF for Computer

Correct Answer: Option B

Explanation:
Ctrl+Alt+N switches to Draft view.
This question belongs to: Computer Microsoft Office
Question #1196
In Excel, the function =VLOOKUP(102, A2:C10, 2, FALSE) searches for 102 in:
A. The row 102
B. The first column of the range A2:C10
C. The second column
D. The entire range
Discuss
Get Complete Subject PDF for Computer

Correct Answer: Option B

Explanation:
VLOOKUP searches the first column of the table_array.
This question belongs to: Computer Microsoft Office
Question #1197
In PowerPoint, which key can be used to jump to a specific slide number during a slide show?
A. Shift + slide number
B. Type slide number and press Enter
C. Alt + slide number
D. Ctrl + G
Discuss
Get Complete Subject PDF for Computer

Correct Answer: Option B

Explanation:
During slide show, type number and Enter to go to that slide.
This question belongs to: Computer Microsoft Office
Question #1198
In MS Access, what is the default data type for a field when you create a new table in Datasheet View?
A. Long Text
B. Short Text
C. Number
D. AutoNumber
Discuss
Get Complete Subject PDF for Computer

Correct Answer: Option B

Explanation:
When you enter data directly, Access assigns Short Text by default.
This question belongs to: Computer Microsoft Office
Question #1199
In PowerPoint, to see only the text content of slides in a structured list, use:
A. Normal view
B. Notes Page
C. Slide Sorter
D. Outline view
Discuss
Get Complete Subject PDF for Computer

Correct Answer: Option D

Explanation:
Outline view shows slide text only.
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 Networking 325 Database Management System (DBMS) 278 Computer Software 347 Memory and Storage Devices 438 Cyber Security 269
Explore Subjects
Geography GK 6121 Economy GK 2220 Computer 5279 Maths 5575 Accountancy and Statistics 3179
Practice Mix
The 'Tarapur' is famous for:
The rate at which Rs. 36000 amounts to Rs. 46800 in 3 years is
The 'Gandhian Plan' for economic development was formulated by?
Average of 12 numbers 620. If average of 8 is 615, average of remaining 4?
Only ___ minority of students failed.