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 34 of 60
Question #661
In MS Word, what is the shortcut to apply single line spacing?
A. Ctrl + 0
B. Ctrl + 1
C. Ctrl + 2
D. Ctrl + 5
Discuss
Get Complete Subject PDF for Computer

Correct Answer: Option B

Explanation:
Ctrl+1 single, Ctrl+2 double, Ctrl+5 1.5 line spacing. Ctrl+0 adds/removes space before paragraph.
This question belongs to: Computer Microsoft Office
Question #662
In Excel, which formula will return '5' from the text 'Excel5'?
A. =LEN("Excel5")
B. =MID("Excel5",2,1)
C. =RIGHT("Excel5",1)
D. =LEFT("Excel5",1)
Discuss
Get Complete Subject PDF for Computer

Correct Answer: Option C

Explanation:
RIGHT with 1 character returns '5'. LEFT returns 'E', MID could return 'x'.
This question belongs to: Computer Microsoft Office
Question #663
In PowerPoint, to insert a sound clip, which tab do you use?
A. Animations
B. Insert
C. Design
D. Transitions
Discuss
Get Complete Subject PDF for Computer

Correct Answer: Option B

Explanation:
Audio is inserted via Insert tab -> Media group.
This question belongs to: Computer Microsoft Office
Question #664
In MS Access, which action query permanently deletes records from a table?
A. Append query
B. Make-Table query
C. Update query
D. Delete query
Discuss
Get Complete Subject PDF for Computer

Correct Answer: Option D

Explanation:
Delete query removes records. Update changes values, Append adds records to a table, Make-Table creates a new table.
This question belongs to: Computer Microsoft Office
Question #665
What does the 'Ctrl + Shift + =' shortcut do in MS Word?
A. Increases font size
B. Applies superscript formatting
C. Toggles subscript
D. Opens the Font dialog
Discuss
Get Complete Subject PDF for Computer

Correct Answer: Option B

Explanation:
Ctrl+Shift+= is superscript. Ctrl+= is subscript.
This question belongs to: Computer Microsoft Office
Question #666
In Excel, the formula =SUM(Sheet2:Sheet5!B3) will:
A. Sum cell B3 from Sheet2 through Sheet5
B. Cause an error because of incorrect syntax
C. Sum range B3 on the active sheet
D. Sum all cells named Sheet2 and Sheet5
Discuss
Get Complete Subject PDF for Computer

Correct Answer: Option A

Explanation:
This 3-D reference sums the same cell across multiple worksheets.
This question belongs to: Computer Microsoft Office
Question #667
Which of the following tabs contains the 'Spelling & Grammar' button in MS Word?
A. References
B. Home
C. Review
D. Insert
Discuss
Get Complete Subject PDF for Computer

Correct Answer: Option C

Explanation:
Spelling & Grammar is under the Review tab, also accessible via F7.
This question belongs to: Computer Microsoft Office
Question #668
In PowerPoint, what is the maximum zoom percentage?
A. 500%
B. 400%
C. 200%
D. 300%
Discuss
Get Complete Subject PDF for Computer

Correct Answer: Option B

Explanation:
PowerPoint allows zoom up to 400%.
This question belongs to: Computer Microsoft Office
Question #669
Which Access view allows you to enter or edit data in a table directly, row by row?
A. Datasheet View
B. Design View
C. SQL View
D. PivotTable View
Discuss
Get Complete Subject PDF for Computer

Correct Answer: Option A

Explanation:
Datasheet View displays data in a grid. Design View modifies structure.
This question belongs to: Computer Microsoft Office
Question #670
In MS Word, the key F12 is used to:
A. Open Save As dialog
B. Open the document
C. Save the document
D. Print the document
Discuss
Get Complete Subject PDF for Computer

Correct Answer: Option A

Explanation:
F12 is Save As. Shift+F12 saves (like Ctrl+S).
This question belongs to: Computer Microsoft Office
Question #671
In Excel, what does the formula =TRIM(A1) do?
A. Converts text to proper case
B. Removes all extra spaces from text except single spaces between words
C. Deletes non-printable characters
D. Removes all spaces from the text
Discuss
Get Complete Subject PDF for Computer

Correct Answer: Option B

Explanation:
TRIM removes leading, trailing, and repeated spaces. CLEAN removes non-printable characters.
This question belongs to: Computer Microsoft Office
Question #672
Which of the following is a type of animation in PowerPoint?
A. Slide Master
B. Design Template
C. Motion Paths
D. Slide Transition
Discuss
Get Complete Subject PDF for Computer

Correct Answer: Option C

Explanation:
Motion Paths are animation effects for objects. Transition is not an animation category.
This question belongs to: Computer Microsoft Office
Question #673
In MS Access, what is the default size of a Short Text field?
A. 255 characters
B. 100 characters
C. 50 characters
D. 64 characters
Discuss
Get Complete Subject PDF for Computer

Correct Answer: Option A

Explanation:
Short Text can hold up to 255 characters; default field size is 255 but may be set smaller.
This question belongs to: Computer Microsoft Office
Question #674
The shortcut to close an active document in MS Word is:
A. Ctrl + F4
B. Alt + 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 current document window. Alt+F4 exits the application.
This question belongs to: Computer Microsoft Office
Question #675
In Excel, the function to return the position of a substring within a string is:
A. SEARCH()
B. MATCH()
C. FIND()
D. Both A and B
Discuss
Get Complete Subject PDF for Computer

Correct Answer: Option D

Explanation:
Both FIND and SEARCH return the starting position of a substring. FIND is case-sensitive, SEARCH is not. MATCH is for ranges.
This question belongs to: Computer Microsoft Office
Question #676
In PowerPoint, which shortcut key duplicates a selected object?
A. Ctrl + D
B. Ctrl + V
C. Ctrl + C
D. Ctrl + X
Discuss
Get Complete Subject PDF for Computer

Correct Answer: Option A

Explanation:
Ctrl + D duplicates an object. Ctrl+C copies, Ctrl+V pastes.
This question belongs to: Computer Microsoft Office
Question #677
Which Access database object contains programming code that automates complex tasks?
A. Macro
B. Module
C. Query
D. Report
Discuss
Get Complete Subject PDF for Computer

Correct Answer: Option B

Explanation:
Modules contain VBA code for advanced automation. Macros are simpler.
This question belongs to: Computer Microsoft Office
Question #678
In MS Word, which alignment option spreads text evenly between left and right margins, adding space between words?
A. Align Left
B. Centre
C. Justify
D. Distribute
Discuss
Get Complete Subject PDF for Computer

Correct Answer: Option C

Explanation:
Justify (Ctrl+J) aligns text to both margins, adjusting word spacing. Distribute is not a standard paragraph alignment.
This question belongs to: Computer Microsoft Office
Question #679
In Excel, a circular reference occurs when:
A. A formula refers to its own cell either directly or indirectly
B. A cell is formatted as a circle
C. A cell reference uses both relative and absolute components
D. A formula references a cell from a different worksheet
Discuss
Get Complete Subject PDF for Computer

Correct Answer: Option A

Explanation:
Circular reference means the formula depends on itself, creating an infinite loop.
This question belongs to: Computer Microsoft Office
Question #680
What is the shortcut to open the thesaurus in MS Word?
A. Alt + F7
B. F7
C. Ctrl + F7
D. Shift + F7
Discuss
Get Complete Subject PDF for Computer

Correct Answer: Option D

Explanation:
Shift+F7 opens thesaurus. F7 is spelling/grammar.
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?'