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 + 1
B. Ctrl + 2
C. Ctrl + 5
D. Ctrl + 0
Discuss
Get Complete Subject PDF for Computer

Correct Answer: Option A

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. =MID("Excel5",2,1)
B. =LEFT("Excel5",1)
C. =RIGHT("Excel5",1)
D. =LEN("Excel5")
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. Insert
B. Animations
C. Design
D. Transitions
Discuss
Get Complete Subject PDF for Computer

Correct Answer: Option A

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. Make-Table query
B. Delete query
C. Update query
D. Append query
Discuss
Get Complete Subject PDF for Computer

Correct Answer: Option B

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. Opens the Font dialog
B. Increases font size
C. Toggles subscript
D. Applies superscript formatting
Discuss
Get Complete Subject PDF for Computer

Correct Answer: Option D

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. Sum all cells named Sheet2 and Sheet5
C. Sum range B3 on the active sheet
D. Cause an error because of incorrect syntax
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. Home
B. Insert
C. References
D. Review
Discuss
Get Complete Subject PDF for Computer

Correct Answer: Option D

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. 400%
B. 300%
C. 500%
D. 200%
Discuss
Get Complete Subject PDF for Computer

Correct Answer: Option A

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. SQL View
B. Datasheet View
C. Design View
D. PivotTable View
Discuss
Get Complete Subject PDF for Computer

Correct Answer: Option B

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 the document
B. Print the document
C. Open Save As dialog
D. Save the document
Discuss
Get Complete Subject PDF for Computer

Correct Answer: Option C

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. Removes all spaces from the text
B. Removes all extra spaces from text except single spaces between words
C. Converts text to proper case
D. Deletes non-printable characters
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 Transition
B. Slide Master
C. Design Template
D. Motion Paths
Discuss
Get Complete Subject PDF for Computer

Correct Answer: Option D

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. 50 characters
C. 100 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. Both A and B
C. Ctrl + W
D. Alt + F4
Discuss
Get Complete Subject PDF for Computer

Correct Answer: Option B

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. Both A and B
B. SEARCH()
C. FIND()
D. MATCH()
Discuss
Get Complete Subject PDF for Computer

Correct Answer: Option A

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. Report
B. Query
C. Module
D. Macro
Discuss
Get Complete Subject PDF for Computer

Correct Answer: Option C

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. Justify
C. Distribute
D. Centre
Discuss
Get Complete Subject PDF for Computer

Correct Answer: Option B

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 cell is formatted as a circle
B. A formula references a cell from a different worksheet
C. A cell reference uses both relative and absolute components
D. A formula refers to its own cell either directly or indirectly
Discuss
Get Complete Subject PDF for Computer

Correct Answer: Option D

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. F7
B. Shift + F7
C. Alt + F7
D. Ctrl + F7
Discuss
Get Complete Subject PDF for Computer

Correct Answer: Option B

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
Computer Hardware 430 Operating Systems 510 Programming Languages 0 Cyber Security 269 Database Management System (DBMS) 278
Explore Subjects
Reasoning 2064 Science 4430 Accountancy and Statistics 3179 Economy GK 2220 Computer 5279
Practice Mix
Which national park in Himachal Pradesh is known for its high-altitude grasslands and is a key habitat for the Himalayan Tahr?
Who was the first Indian to be the Coordination Secretary?
Which of the following is an example of an animal cell that lacks a nucleus in its mature form?
What is the primary limitation of configuring a network using a point-to-point Full Mesh Topology as the number of nodes scales high?
Double fertilization in angiosperms was discovered by: