USING MICROSOFT EXCEL
HOW TO INSERT DELETE COLUMNS ROWS IN EXCEL
|
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
What is the purpose of the TRIM function?
|
|
It removes a specific number of characters from a text string.
|
|
|
It removes all non-printable characters.
|
|
|
It removes all spaces from a text string except single spaces between words.
|
|
|
None of the above options are correct.
|
Explanation:
Detailed explanation-1: -Removes all spaces from text except for single spaces between words. Use TRIM on text that you have received from another application that may have irregular spacing. Important: The TRIM function was designed to trim the 7-bit ASCII space character (value 32) from text.
Detailed explanation-2: -The TRIM function removes all spaces from text except a single space between words. Use this function when you have text data that contains hidden spaces in the cell.
Detailed explanation-3: -TRIM function-remove extra spaces in Excel You use the TRIM function in Excel removes extra spaces from text. It deletes all leading, trailing and in-between spaces except for a single space character between words.
There is 1 question to complete.