Q: Which of the following functions automatically remove extra spaces when cleaning data?
or
Q: When cleaning data, which of the following functions automatically eliminates superfluous spaces?
- SNIP
- REMOVE
- TRIM
- CLEAR
Explanation: When data is cleaned, it is usual practice to utilize the TRIM function to eliminate superfluous spaces in a data set automatically. It is a useful tool that may maintain uniformity and get rid of unwanted gaps, which can be a source of problems during analysis or presentation.
