In Excel, what does the 'TRIM' function do? MCQ with Answer and Explanation

Question
In Excel, what does the 'TRIM' function do?
A. Converts text to proper case
B. Truncates text to a specified length
C. Removes non-printable characters
D. Removes extra spaces from text
Answer: Option D
Solution (By JKSSB Mock Tests)
TRIM removes all leading, trailing, and multiple internal spaces, leaving single spaces between words. CLEAN removes non-printable characters.
This question belongs to: Computer Microsoft Office
Request complete Subject PDF

Discuss this Question (0)

No comments yet. Be the first to start the discussion!

Practice More Microsoft Office Questions

Question #1
What is the shortcut key to insert a new slide in MS PowerPoint?
A. Ctrl + N
B. Ctrl + M
C. Ctrl + Shift + N
D. Ctrl + D
Discuss
Get Complete Subject PDF for Computer

Correct Answer: Option B

Explanation:
Ctrl+M inserts a new slide. Ctrl+N creates a new presentation. Ctrl+D duplicates slide.
This question belongs to: Computer Microsoft Office
Question #2
Which component of an MS Access window layout allows database administrators to define specific rules that prevent invalid entries before records are saved?
A. Validation Rule
B. Default Value mapping
C. Format properties sheet
D. Input Mask editor
Discuss
Get Complete Subject PDF for Computer

Correct Answer: Option A

Explanation:
The Validation Rule property evaluates data entries against specified criteria constraints, blocking invalid inputs before they are saved to the database table.
This question belongs to: Computer Microsoft Office
Question #3
In MS Word, which feature allows you to see the document's structure using headings?
A. Outline View
B. All of the above
C. Document Map (older)
D. Navigation Pane
Discuss
Get Complete Subject PDF for Computer

Correct Answer: Option B

Explanation:
The Navigation Pane (with 'Headings' tab), Outline View, and the old Document Map all show the document's heading hierarchy.
This question belongs to: Computer Microsoft Office
Explore All Microsoft Office MCQs
Today's Top Topics
Computer Software 347 Computer Abbreviations 369 Operating Systems 510 Computer Networking 325 Microsoft Office 1199
Explore Subjects
Computer 5279 Science 4430 Geography GK 6121 Current Affairs 575 Static General Knowledge 6362
Practice Mix
The street ______ I live on is quiet.
What is the capacity unit for modern RAM modules?
Which of the following is a Rabi millet?
An object moving with uniform circular motion has
Identify the error: 'You are senior than me.'