USING MICROSOFT EXCEL
USING THE UPPER AND LOWER FUNCTIONS IN EXCEL
|
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
When using the TRIM function, what space(s) would be removed?
|
|
only the first
|
|
|
first and last
|
|
|
only the last
|
|
|
only the middle
|
Explanation:
Detailed explanation-1: -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.
Detailed explanation-2: -The Trim function removes all spaces from a string of text except for single spaces between words.
Detailed explanation-3: -Description. 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.
Detailed explanation-4: -The TRIM function: Removes spaces from start and end of text string. Removes all except single spaces between words.
There is 1 question to complete.