In Excel, what does the formula =TRIM(A1) do? MCQ with Answer and Explanation

Question
In Excel, what does the formula =TRIM(A1) do?
A. Removes all extra spaces from text except single spaces between words
B. Converts text to proper case
C. Removes all spaces from the text
D. Deletes non-printable characters
Answer: Option A
Solution (By JKSSB Mock Tests)
TRIM removes leading, trailing, and repeated spaces. 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
Which of the following is a valid object in MS Access database?
A. Query
B. Table
C. All of these
D. Form
Discuss
Get Complete Subject PDF for Computer

Correct Answer: Option C

Explanation:
All are objects.
This question belongs to: Computer Microsoft Office
Question #2
In MS Word, which of the following is an example of a font style or character decoration attribute?
A. Strikethrough
B. Calibri
C. 12 pt
D. Margins
Discuss
Get Complete Subject PDF for Computer

Correct Answer: Option A

Explanation:
Strikethrough is an explicitly selectable character effect attribute, whereas Calibri is a font family, and 12 pt represents font size metric sizing.
This question belongs to: Computer Microsoft Office
Question #3
What is the function of the CONCATENATE function in Excel?
A. Extracts a specific number of characters from the left of a string
B. Joins two or more text strings into one string
C. Converts text to uppercase
D. Removes extra spaces from text
Discuss
Get Complete Subject PDF for Computer

Correct Answer: Option B

Explanation:
CONCATENATE combines text strings. UPPER converts to uppercase, TRIM removes extra spaces, LEFT extracts left characters.
This question belongs to: Computer Microsoft Office
Explore All Microsoft Office MCQs
Today's Top Topics
Computer Software 347 Internet and Web Technologies 461 Computer Fundamentals 326 Microsoft Office 1199 CPU (Central Processing Unit) 327
Explore Subjects
Computer 5279 Static General Knowledge 6362 English 15164 Current Affairs 575 History GK 3374
Practice Mix
The difference between simple interest and compound interest on a certain sum of money for 2 years at 9% per annum is Rs. 81. Find the sum.
The process by which plants lose water in the form of liquid droplets is:
The 'Vote on Account' is used to:
Software programs that are custom engineered for banking automated teller machines (ATMs) to connect securely to institutional transaction ledger networks are classified as:
Which is the capital of South Africa (legislative)?