Data Quality Basics
What is data quality?
The measure of how well data serves its intended purpose, considering factors like accuracy, completeness, reliability, and relevance.
Which Excel function can you use to remove leading and trailing spaces from text?
TRIM.
What is a missing value in a dataset?
A data entry that is absent or null.
What is the purpose of data validation in Excel?
To ensure that data entered into a cell meets certain criteria.
How do you sort data in ascending order in Excel?
By selecting the column and using the Sort A to Z button.
Name one characteristic of high-quality data.
Accuracy.
How do you change text to uppercase in Excel?
Using the UPPER function.
What is a duplicate entry?
A record that appears more than once in a dataset.
How can you restrict data entry to a specific list of values in Excel?
Using the Data Validation feature and selecting List.
What tool can you use to quickly filter data in Excel?
The Filter tool under the Data tab.
Why is data quality important?
It ensures that decisions made based on the data are reliable and valid.
Which function helps to find and replace data in Excel?
FIND and REPLACE.
What is an outlier?
A data point significantly different from others in the dataset.
How do you create a custom data validation rule in Excel?
By using the Data Validation feature and selecting Custom.
How do you merge cells in Excel?
By selecting the cells and using the Merge & Center button under the Home tab.
What does data consistency mean?
Ensuring that data is the same across multiple datasets or within different parts of the same dataset.
What function would you use to remove duplicates in Excel?
Remove Duplicates tool under the Data tab.
Give an example of inconsistent data.
Different date formats in the same column.
How can you ensure that only valid email addresses are entered in a column?
By using "Data Validation" with a custom rule that checks for valid email formats.
What feature helps you summarize data quickly in Excel?
PivotTable.
What is data integrity?
The accuracy and consistency of data over its entire lifecycle.
How can you split text into different columns in Excel?
Using the Text to Columns feature.
What does data redundancy mean?
Unnecessarily repeated data in a dataset.
How do you split text into different columns in Excel?
Using the "Text to Columns" feature.
How can you create a visual representation of data in Excel?
By using the Chart tool under the Insert tab.