Data Cleaning Techniques

Which technique is effective for correcting inaccuracies in data?

• Text-to-Columns

• Filters

• Spell checkers

• CLEAN functions

What approach is suitable for cleaning unstructured text data?

• Using Text-to-Columns

• Applying filters

• Spell checkers

• CLEAN functions

What does the TRIM function do in data cleaning?

• Removes leading and trailing spaces from text

• Converts text to uppercase

• Calculates the sum of a range of cells

• Converts text to numbers

What is the purpose of the CLEAN function in data cleaning?

• Converts text to lowercase

• Removes leading and trailing spaces from text

• Removes non-printable characters from text

• Converts text to numbers

What method can be used to identify and handle incomplete data?

• Text-to-Columns

• Spell checkers

• Filters

• TRIM

How can inconsistent data be addressed?

• Removing duplicates

• Using Text-to-Columns

• Formatting data

• Applying filters

What action should be taken to handle duplicate data?

• Using Text-to-Columns

• Applying filters

• Removing duplicates

• Formatting data