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 57 of 60
Question #1121
In MS Word, the shortcut to increase indent by one level is:
A. Ctrl + M
B. Tab
C. Alt + Shift + Right Arrow (for list indent)
D. Both A and B (depending on context)

Correct Answer: Option A


Explanation:
Ctrl+M increases left indent. Tab may increase list level.

This question belongs to: Computer Microsoft Office
Question #1122
In PowerPoint, which of the following is NOT a valid option for starting a slide show?
A. From Beginning (F5)
B. From Current Slide (Shift+F5)
C. Custom Slide Show
D. From Selected Slide (Ctrl+F5)

Correct Answer: Option D


Explanation:
There is no 'From Selected Slide' shortcut; you can start from current slide.

This question belongs to: Computer Microsoft Office
Question #1123
In MS Access, what is the maximum number of characters in an OLE Object field name?
A. 64
B. 128
C. 255
D. 32

Correct Answer: Option A


Explanation:
All field names max 64 characters.

This question belongs to: Computer Microsoft Office
Question #1124
To open a new document in MS Word, press:
A. Ctrl + S
B. Ctrl + N
C. Ctrl + Alt + N
D. Ctrl + O

Correct Answer: Option B


Explanation:
Ctrl+N new document.

This question belongs to: Computer Microsoft Office
Question #1125
In Excel, the function =LARGE(A1:A10, 2) returns:
A. The average of top two
B. The second largest value in the range
C. The largest value
D. The smallest value

Correct Answer: Option B


Explanation:
LARGE(array, k) returns k-th largest.

This question belongs to: Computer Microsoft Office
Question #1126
In MS Word, 'Text Effects and Typography' is available under:
A. Design tab
B. Both A and B
C. Home tab -> Font group
D. Insert tab -> WordArt

Correct Answer: Option C


Explanation:
Text Effects button is in the Font group on Home tab (glowing A).

This question belongs to: Computer Microsoft Office
Question #1127
In PowerPoint, what does the 'Esc' key do during a slide show?
A. Goes to previous slide
B. Ends the slide show
C. Pauses the show
D. Shows a black screen

Correct Answer: Option B


Explanation:
Esc exits slide show.

This question belongs to: Computer Microsoft Office
Question #1128
In MS Access, which data type is used to store binary data such as sound or video?
A. Hyperlink
B. Attachment
C. OLE Object
D. Both A and B

Correct Answer: Option D


Explanation:
Both can store multimedia, but Attachment is preferred.

This question belongs to: Computer Microsoft Office
Question #1129
Which shortcut is used to close an open menu without selecting any command?
A. Alt
B. F10
C. Tab
D. Esc

Correct Answer: Option D


Explanation:
Esc closes a menu.

This question belongs to: Computer Microsoft Office
Question #1130
In MS Word, to open the 'Clipboard' pane, press:
A. Ctrl + Shift + C
B. Ctrl + V
C. Alt + H, F, O (or click launcher)
D. Ctrl + C

Correct Answer: Option C


Explanation:
No direct shortcut; you can click Clipboard launcher on Home tab. Alt+H,F,O opens it.

This question belongs to: Computer Microsoft Office
Question #1131
In Excel, the shortcut to create a table (Ctrl+T) will:
A. Convert a range into an Excel table with filters
B. Sort data
C. Create a chart
D. Open a new tab

Correct Answer: Option A


Explanation:
Ctrl+T formats data as a table.

This question belongs to: Computer Microsoft Office
Question #1132
In PowerPoint, which key toggles between Normal and Outline view?
A. Ctrl + F6
B. There is no single shortcut; use View tab
C. Ctrl + Shift + Tab (in some versions)
D. F6

Correct Answer: Option B


Explanation:
No direct toggle; you switch in the View tab. I'll rephrase: In PowerPoint, which view displays only text in an outline format? Answer: Outline view (accessible from View tab). So I'll ask: In PowerPoint, to see only the text content of slides in a structured list, use Outline view. That's fine.

This question belongs to: Computer Microsoft Office
Question #1133
In MS Access, the 'Field Size' property for a Number field can be:
A. Text, Memo
B. Currency
C. Byte, Integer, Long Integer, Single, Double, Decimal
D. Yes/No

Correct Answer: Option C


Explanation:
Number field size options include those.

This question belongs to: Computer Microsoft Office
Question #1134
Which of the following is a valid file format for saving a Word document with macros?
A. .docx
B. .dotx
C. .docm
D. .doc

Correct Answer: Option C


Explanation:
.docm is macro-enabled document.

This question belongs to: Computer Microsoft Office
Question #1135
In Excel, the 'Sort & Filter' group is on which tab?
A. Data
B. Home
C. Formulas
D. View

Correct Answer: Option A


Explanation:
Data tab has Sort & Filter.

This question belongs to: Computer Microsoft Office
Question #1136
In MS Word, the 'Ctrl + K' shortcut inserts:
A. A cross-reference
B. A bookmark
C. A comment
D. A hyperlink

Correct Answer: Option D


Explanation:
Ctrl+K inserts hyperlink.

This question belongs to: Computer Microsoft Office
Question #1137
In PowerPoint, to save a presentation as a template, choose:
A. .ppsx
B. .pptx
C. .pptm
D. .potx

Correct Answer: Option D


Explanation:
Template extension .potx.

This question belongs to: Computer Microsoft Office
Question #1138
In MS Access, what is the function of the 'Lookup Wizard'?
A. Imports data
B. Creates relationships
C. Searches for records
D. Creates a field that provides a dropdown list of values

Correct Answer: Option D


Explanation:
Lookup Wizard creates a lookup field.

This question belongs to: Computer Microsoft Office
Question #1139
To go to the end of a line in MS Word, press:
A. Ctrl + Home
B. End
C. Ctrl + End
D. Home

Correct Answer: Option B


Explanation:
End moves to end of line.

This question belongs to: Computer Microsoft Office
Question #1140
In PowerPoint, which tab allows you to add a video from YouTube?
A. Insert -> Video -> Online Video
B. Animations -> Video
C. Slide Show -> Video
D. Design -> Video

Correct Answer: Option A


Explanation:
Online Video is in Insert tab.

This question belongs to: Computer Microsoft Office