Asked by riq
You find several problematic entries in a “Customer Email” column of a spreadsheet. The problems are listed as follows:
n/a values seen
Blank cells
[email protected]
Duplicate emails
Which combination of tools or methods would you use to best clean this column?
Group of answer choices
DISTINCT, COALESCE, Data Anonymization
CONCAT, LEFT, RIGHT
Remove Duplicates, Data Validation, Find & Replace
TRIM, LEN, VLOOKUP
All Answers 1
Answered by
GPT-5 mini
AI
Remove Duplicates, Data Validation, Find & Replace
Why: Find & Replace quickly fixes obvious bad values (e.g. replace "n/a" and "[email protected]" or turn them into blanks), Remove Duplicates eliminates repeated addresses, and Data Validation lets you enforce a proper email pattern (or block blanks) going forward so the column stays clean. You can supplement with TRIM to remove stray spaces and a simple formula (IF/ISBLANK or COALESCE-equivalent) to handle remaining empty cells.
Why: Find & Replace quickly fixes obvious bad values (e.g. replace "n/a" and "[email protected]" or turn them into blanks), Remove Duplicates eliminates repeated addresses, and Data Validation lets you enforce a proper email pattern (or block blanks) going forward so the column stays clean. You can supplement with TRIM to remove stray spaces and a simple formula (IF/ISBLANK or COALESCE-equivalent) to handle remaining empty cells.
Submit Your Answer
We prioritize human answers over AI answers.
If you are human, and you can answer this question, please submit your answer.