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 45 of 60
Question #881
In MS Word, the feature that automatically creates a border when you type three hyphens and press Enter is:
A. AutoCorrect
B. Smart Lookup
C. AutoFormat As You Type
D. Quick Styles
Discuss
Get Complete Subject PDF for Computer

Correct Answer: Option C

Explanation:
Typing three hyphens, underscores, or equal signs and Enter triggers automatic border creation.
This question belongs to: Computer Microsoft Office
Question #882
In Excel, what is the shortcut to enter an array formula?
A. Ctrl + Shift + Enter
B. Shift + Enter
C. Alt + Enter
D. Ctrl + Enter
Discuss
Get Complete Subject PDF for Computer

Correct Answer: Option A

Explanation:
Array formulas in older Excel require Ctrl+Shift+Enter. In Excel 365, dynamic arrays don't require it, but traditionally it's that.
This question belongs to: Computer Microsoft Office
Question #883
In PowerPoint, which of the following can be inserted as a slide background?
A. Texture
B. Picture
C. Gradient fill
D. All of these
Discuss
Get Complete Subject PDF for Computer

Correct Answer: Option D

Explanation:
Background fill options include solid, gradient, picture, texture, pattern.
This question belongs to: Computer Microsoft Office
Question #884
In MS Access, which query is used to find duplicate records in a table?
A. Select query with GROUP BY and HAVING COUNT(*)>1
B. Find Duplicates Query Wizard
C. Crosstab query
D. Both A and B
Discuss
Get Complete Subject PDF for Computer

Correct Answer: Option D

Explanation:
Both the wizard and a totals query can identify duplicates.
This question belongs to: Computer Microsoft Office
Question #885
In MS Word, what is the function of the 'Insert' key?
A. Toggles between Insert and Overtype mode
B. Opens the Insert tab
C. Inserts the current date
D. Inserts a new page
Discuss
Get Complete Subject PDF for Computer

Correct Answer: Option A

Explanation:
Insert key toggles overtype mode.
This question belongs to: Computer Microsoft Office
Question #886
Which of the following Excel functions is used to rank a number in a list?
A. RANK.AVG()
B. RANK.EQ()
C. RANK()
D. All of these
Discuss
Get Complete Subject PDF for Computer

Correct Answer: Option D

Explanation:
RANK (old), RANK.EQ, RANK.AVG are all ranking functions.
This question belongs to: Computer Microsoft Office
Question #887
In PowerPoint, the 'Notes Page' includes:
A. Only speaker notes
B. A miniature of the slide and space for speaker notes
C. Slide thumbnails and transitions
D. Audience handouts
Discuss
Get Complete Subject PDF for Computer

Correct Answer: Option B

Explanation:
Notes Page shows a small slide image and a notes area.
This question belongs to: Computer Microsoft Office
Question #888
In MS Access, the 'Caption' property is used to:
A. Set the label displayed for the field in forms and reports
B. Set the default value
C. Define the input mask
D. Set the field size
Discuss
Get Complete Subject PDF for Computer

Correct Answer: Option A

Explanation:
Caption provides an alternate name for the field for display.
This question belongs to: Computer Microsoft Office
Question #889
What is the maximum file size for a Word document?
A. 2 GB
B. 1 GB
C. No limit
D. 32 MB for text only, 512 MB with images (but practically no hard limit)
Discuss
Get Complete Subject PDF for Computer

Correct Answer: Option D

Explanation:
Word document maximum size is 32 MB for text, but can be larger with images; however, official limit is 32 MB of text.
This question belongs to: Computer Microsoft Office
Question #890
In Excel, to create a drop-down list in a cell, use:
A. Data Validation -> List
B. Home -> Sort & Filter
C. Conditional Formatting -> List
D. Insert -> Drop-down
Discuss
Get Complete Subject PDF for Computer

Correct Answer: Option A

Explanation:
Data Validation with List restriction creates a drop-down.
This question belongs to: Computer Microsoft Office
Question #891
In PowerPoint, to apply the same transition to all slides, click:
A. Apply To All in the Transitions tab
B. Animation Painter
C. Copy transition and paste to all
D. Slide Master -> Transition
Discuss
Get Complete Subject PDF for Computer

Correct Answer: Option A

Explanation:
Apply To All button sets the selected transition for every slide.
This question belongs to: Computer Microsoft Office
Question #892
In MS Access, which of the following is NOT a field data type?
A. Calculated
B. Lookup
C. Long Text
D. Memo
Discuss
Get Complete Subject PDF for Computer

Correct Answer: Option B

Explanation:
Lookup is not a data type; it's a field property (using Lookup Wizard). Data types include Short Text, Long Text, Number, Date/Time, Currency, AutoNumber, Yes/No, OLE Object, Hyperlink, Attachment, Calculated.
This question belongs to: Computer Microsoft Office
Question #893
To activate the menu bar in MS Office applications, press:
A. F10
B. Alt
C. Shift
D. Ctrl
Discuss
Get Complete Subject PDF for Computer

Correct Answer: Option B

Explanation:
Pressing Alt activates the Ribbon shortcut keys (Key Tips). F10 also activates the menu bar.
This question belongs to: Computer Microsoft Office
Question #894
In MS Word, 'Kerning for fonts' can be set from:
A. Styles
B. Paragraph dialog
C. Page Setup
D. Font dialog -> Advanced tab
Discuss
Get Complete Subject PDF for Computer

Correct Answer: Option D

Explanation:
Kerning is under Font -> Advanced.
This question belongs to: Computer Microsoft Office
Question #895
In Excel, which formula will return the number of characters in cell A1?
A. =COUNT(A1)
B. =CHAR(A1)
C. =LENGTH(A1)
D. =LEN(A1)
Discuss
Get Complete Subject PDF for Computer

Correct Answer: Option D

Explanation:
LEN returns character count.
This question belongs to: Computer Microsoft Office
Question #896
In PowerPoint, which of the following is a motion path animation?
A. Grow/Shrink
B. Fly In
C. Fade
D. Arc
Discuss
Get Complete Subject PDF for Computer

Correct Answer: Option D

Explanation:
Arc is a motion path. Fade is entrance, Fly In is entrance, Grow/Shrink is emphasis.
This question belongs to: Computer Microsoft Office
Question #897
In MS Access, what is a 'subform'?
A. A form without a record source
B. A form embedded within another form, usually to display related records
C. A form that opens when a button is clicked
D. A form used only for data entry
Discuss
Get Complete Subject PDF for Computer

Correct Answer: Option B

Explanation:
Subform displays related data from a one-to-many relationship.
This question belongs to: Computer Microsoft Office
Question #898
Which of the following shortcuts inserts a line break (soft return) in MS Word?
A. Enter
B. Alt + Enter
C. Shift + Enter
D. Ctrl + Enter
Discuss
Get Complete Subject PDF for Computer

Correct Answer: Option C

Explanation:
Shift+Enter creates a new line without a new paragraph.
This question belongs to: Computer Microsoft Office
Question #899
In Excel, the 'Trace Precedents' feature shows:
A. Cells that depend on the selected cell
B. Errors in the formula
C. Arrows indicating which cells provide data to the selected formula
D. The formula in a separate window
Discuss
Get Complete Subject PDF for Computer

Correct Answer: Option C

Explanation:
Trace Precedents (Formulas tab) draws arrows from cells that feed into the active cell.
This question belongs to: Computer Microsoft Office
Question #900
In PowerPoint, to record a slide show with narration and timings, go to:
A. Insert tab -> Audio -> Record
B. Animations tab -> Record
C. Slide Show tab -> Record Slide Show
D. Transitions tab -> Timing
Discuss
Get Complete Subject PDF for Computer

Correct Answer: Option C

Explanation:
Record Slide Show is under Slide Show tab.
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: