Practice Quiz WEEK 3

What is the first and most significant part of data quality? Accuracy Relevance Completeness Reliability

Accuracy

Which of the following tasks can Flash Fill do? Select all that apply. Set column width Combine two columns of data into one Split one column of data into two Remove empty rows

Combine two columns of data into one Split one column of data into two

What feature can you use to fix text that appears in mixed case? Audits Functions AutoSum Filter

Functions

What is one of the functions you can use to change the text case in your data? CAP LOWER STRUCTURE CASE

LOWER

What does the Flash Fill feature have in common with the UPPER, LOWER, and PROPER functions? Lookup & Reference Repairs a REF error Keeps cell formatting Requires a helper column or row

Requires a helper column or row

What is the first thing you should do when checking spelling errors in Excel? Use a dictionary Select the data you want to check for spelling Find the misspelled data Click the Spelling button

Select the data you want to check for spelling

According to the video, what's one of the easiest common errors or inconsistencies to fix when importing data? Duplicated data Extra white space Empty rows Spelling mistakes

Spelling mistakes

Which data quality trait refers to the availability and accessibility of the data? Completeness Accuracy Reliability Timeliness

Timeliness

What is a delimited file? file with no spaces between data fields file with text qualifiers between data fields file with data fields separated by fixed-widths file with data fields separated by characters like commas or tabs

file with data fields separated by characters like commas or tabs