Data Cleaning Quiz

What is the primary goal of data cleaning?

• To delete unnecessary files

• To correct or remove inaccurate records from a dataset

• To format data for better readability

• To reduce the size of the dataset

Which of the following is NOT a common data cleaning technique?

• Removing duplicates

• Converting data to a different format

• Filling in missing values

• Adding new data points

What is the first step typically involved in the data cleaning process?

• Removing outliers

• Data profiling and assessment

• Filling in missing values

• Standardizing data formats

In Excel, which function can be used to identify duplicate entries?

• VLOOKUP

• CONCATENATE

• IFERROR

• COUNTIF

Which of the following describes the process of handling missing data by replacing it with the mean value of the dataset?

• Data imputation

• Data normalization

• Data enrichment

• Data transformation

What is the purpose of removing outliers during data cleaning?

• To increase the size of the dataset

• To ensure the data distribution is normal

• To improve the accuracy of data analysis

• To remove all low-valued data points

Which of the following Excel tools can be used to clean data by removing extra spaces?

• TRIM function

• SUBSTITUTE function

• FIND function

• LEFT function

Which technique is often used to handle inconsistencies in categorical data?

• Normalization

• Binning

• Standardization

• Data deduplication

What is the key benefit of automating data cleaning processes?

• It makes the data more visually appealing

• It reduces the time and effort required for manual cleaning

• It allows for the deletion of more records

• It increases the size of the dataset

In the context of data cleaning, what does 'normalization' refer to?

• Adjusting data to follow a normal distribution

• Converting data to a common scale

• Removing all errors from the dataset

• Transforming data into a uniform format