10.30.4
- 1. How can you detect and fix dates stored as text?
- 2. What problems occur when numbers are stored as text?
- 3. How do you convert numbers stored as text into numeric values?
- 4. How can Power Query standardize text formats automatically?
- 5. How can Power Query remove duplicate rows from a table?
- 6. How can Power Query remove blank rows or columns from data?
- 7. What is Power Query, and how is it useful for data cleaning?
- 8. How can Text to Columns help fix combined data issues?
- 9. What delimiters can be used in Text to Columns (e.g., comma, space, tab)?
- 10. How can Text to Columns split data in a single column into multiple columns?
- 11. Give an example of using Flash Fill to standardize names.
- 12. How can Flash Fill be used to clean or reformat data?
- 13. How can extra spaces in cells affect formulas or lookups?
- 14. What is the purpose of the CLEAN function in Excel?
- 15. How does the TRIM function help in cleaning text?
- 16. What is the difference between removing duplicates and filtering unique values?
- 17. What precautions should you take before removing duplicates?
- 18. How do you remove duplicates from a dataset in Excel?
- 19. How can duplicate values be identified in Excel?
- 20. What is data cleaning in Excel and why is it important?