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 42 of 60
Question #821
In MS Word, 'WordArt' is used to:
A. Add 3D models
B. Draw shapes
C. Create decorative text with special effects
D. Insert clip art
Discuss
Get Complete Subject PDF for Computer

Correct Answer: Option C

Explanation:
WordArt applies stylized text effects.
This question belongs to: Computer Microsoft Office
Question #822
In Excel, what does the error '#N/A' mean?
A. Name not recognized
B. Invalid cell reference
C. Division by zero
D. A value is not available to a function or formula
Discuss
Get Complete Subject PDF for Computer

Correct Answer: Option D

Explanation:
#N/A indicates no value available, common in lookup functions.
This question belongs to: Computer Microsoft Office
Question #823
In PowerPoint, which option allows you to apply a custom color to all slide backgrounds at once?
A. View -> Slide Master -> Background Styles
B. Design -> Format Background -> Apply to All
C. Home -> Fill Color
D. Both A and B
Discuss
Get Complete Subject PDF for Computer

Correct Answer: Option D

Explanation:
Both methods can set background for all slides: Slide Master or Format Background with Apply to All.
This question belongs to: Computer Microsoft Office
Question #824
In MS Access, to see the SQL code behind a query, switch to:
A. Datasheet View
B. Layout View
C. Design View
D. SQL View
Discuss
Get Complete Subject PDF for Computer

Correct Answer: Option D

Explanation:
SQL View displays the SQL statement.
This question belongs to: Computer Microsoft Office
Question #825
Which of the following shortcut keys is used to open the 'Find and Replace' dialog with Replace tab in MS Word?
A. F5
B. Ctrl + R
C. Ctrl + H
D. Ctrl + F
Discuss
Get Complete Subject PDF for Computer

Correct Answer: Option C

Explanation:
Ctrl+H opens Replace. Ctrl+F Find.
This question belongs to: Computer Microsoft Office
Question #826
In Excel, the function =MID("EXAMINATION",4,3) returns:
A. INA
B. EXA
C. AMI
D. MIN
Discuss
Get Complete Subject PDF for Computer

Correct Answer: Option D

Explanation:
MID starting at position 4 for length 3: characters 4='A',5='I',6='N'? Wait, EXAMINATION: 1 E,2 X,3 A,4 M,5 I,6 N,7 A,8 T,9 I,10 O,11 N. So position 4 is M, so string M, I, N -> MIN. Yes.
This question belongs to: Computer Microsoft Office
Question #827
In MS Word, 'SmartArt' is used to:
A. Create visual representations like lists, processes, and hierarchies
B. Add mathematical equations
C. Insert copyright-free images
D. Create charts
Discuss
Get Complete Subject PDF for Computer

Correct Answer: Option A

Explanation:
SmartArt provides pre-designed diagram templates.
This question belongs to: Computer Microsoft Office
Question #828
In PowerPoint, the keyboard shortcut to bring the selected object one step forward is:
A. Ctrl + ]
B. Alt + F
C. Ctrl + Shift + F
D. Ctrl + F
Discuss
Get Complete Subject PDF for Computer

Correct Answer: Option C

Explanation:
Ctrl+Shift+F brings object forward (bring forward). Ctrl+Shift+B sends backward.
This question belongs to: Computer Microsoft Office
Question #829
In MS Access, the 'Lookup Wizard' is used to:
A. Find duplicate records
B. Create a field that allows selecting a value from a list or another table
C. Import data from Excel
D. Search for a specific record
Discuss
Get Complete Subject PDF for Computer

Correct Answer: Option B

Explanation:
Lookup Wizard helps create a lookup field.
This question belongs to: Computer Microsoft Office
Question #830
Which tab is used to set margins in MS Word?
A. Layout
B. Design
C. Insert
D. Home
Discuss
Get Complete Subject PDF for Computer

Correct Answer: Option A

Explanation:
Margins are set in the Layout tab (Page Setup group).
This question belongs to: Computer Microsoft Office
Question #831
In Excel, the intersection operator is:
A. Colon (:)
B. Comma (,)
C. Semicolon (;)
D. Space
Discuss
Get Complete Subject PDF for Computer

Correct Answer: Option D

Explanation:
A space between two ranges returns their intersection. Comma is union, colon is range.
This question belongs to: Computer Microsoft Office
Question #832
Which of the following is a type of slide transition in PowerPoint?
A. Spin
B. Grow/Shrink
C. Fly In
D. Fade
Discuss
Get Complete Subject PDF for Computer

Correct Answer: Option D

Explanation:
Fade is a transition. Fly In, Spin, Grow/Shrink are animations.
This question belongs to: Computer Microsoft Office
Question #833
In MS Access, to open a form in read-only mode (preventing edits), set the form's property:
A. Allow Edits to No
B. Record Locks to All Records
C. Enabled to No
D. Data Entry to Yes
Discuss
Get Complete Subject PDF for Computer

Correct Answer: Option A

Explanation:
Setting Allow Edits, Allow Deletions, Allow Additions to No makes the form read-only.
This question belongs to: Computer Microsoft Office
Question #834
The shortcut to minimize the ribbon in MS Office is:
A. Shift + F1
B. Ctrl + F1
C. Alt + F1
D. F11
Discuss
Get Complete Subject PDF for Computer

Correct Answer: Option B

Explanation:
Ctrl+F1 toggles ribbon minimization.
This question belongs to: Computer Microsoft Office
Question #835
In MS Word, 'AutoCorrect' is used to:
A. Check grammar
B. Auto-format headings
C. Translate text to another language
D. Automatically correct common spelling and typing mistakes as you type
Discuss
Get Complete Subject PDF for Computer

Correct Answer: Option D

Explanation:
AutoCorrect fixes typos (e.g., 'teh' to 'the').
This question belongs to: Computer Microsoft Office
Question #836
In Excel, the formula =SUMPRODUCT(A1:A3, B1:B3) multiplies corresponding components and returns the sum. If A1=2,A2=3,A3=4 and B1=1,B2=2,B3=3, result is:
A. 26
B. 20
C. 18
D. 24
Discuss
Get Complete Subject PDF for Computer

Correct Answer: Option B

Explanation:
2*1 + 3*2 + 4*3 = 2+6+12=20.
This question belongs to: Computer Microsoft Office
Question #837
In PowerPoint, which tool helps you to align objects evenly?
A. Smart Guides
B. Arrange group under Home tab
C. All of the above
D. Align and Distribute tools under Format tab
Discuss
Get Complete Subject PDF for Computer

Correct Answer: Option C

Explanation:
All these options help align and distribute objects evenly.
This question belongs to: Computer Microsoft Office
Question #838
In MS Access, what does the 'Format' property of a field do?
A. Specifies the data type
B. Sets the maximum number of characters
C. Restricts data entry to a pattern
D. Controls how data is displayed, not how it is stored
Discuss
Get Complete Subject PDF for Computer

Correct Answer: Option D

Explanation:
Format property customizes display (e.g., date format).
This question belongs to: Computer Microsoft Office
Question #839
What is the maximum number of worksheets you can have in an Excel workbook?
A. Limited by available memory
B. 1,048,576
C. 3
D. 255
Discuss
Get Complete Subject PDF for Computer

Correct Answer: Option A

Explanation:
There is no fixed limit; it depends on system memory. By default, new workbook has 1 sheet but can be added.
This question belongs to: Computer Microsoft Office
Question #840
In MS Word, the 'Read Aloud' feature is located under which tab?
A. Home
B. View
C. Review
D. Insert
Discuss
Get Complete Subject PDF for Computer

Correct Answer: Option C

Explanation:
Read Aloud is on the Review 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
Microsoft Office 1199 Computer Fundamentals 326 Internet and Web Technologies 461 CPU (Central Processing Unit) 327 Computer Hardware 430
Explore Subjects
Current Affairs 575 English 15164 Static General Knowledge 6362 History GK 3374 Reasoning 1111
Practice Mix
The Macaulay's Minute dealt with:
Which major port is located on the Malabar Coast?
A census provides data that is:
Which of the following is the primary reason for the high rainfall in Cherrapunji?
Choose the correct active voice of: 'Has the mail been sent by the secretary?'