excel basics for data analysis coursera week 3 quiz answers
Practice Quiz
1. What is the first and most significant part of data quality?
- Completeness
- Accuracy
- Reliability
- Relevance
2. Which data quality trait refers to the availability and accessibility of the data?
- Reliability
- Completeness
- Accuracy
- Timeliness
3. What is a delimited file?
- file with text qualifiers between data fields
- file with data fields separated by fixed-widths
- file with no spaces between data fields
- file with data fields separated by characters like commas or tabs
Graded Quiz
4. Which data quality trait can be summarized by asking if the data is really necessary?
- Reliability
- Timeliness
- Completeness
- Relevance
5. Which data quality trait refers to the availability and accessibility of the data?
- Timeliness
- Reliability
- Completeness
- Accuracy
6. After importing a text file into Excel, you find some columns aren't showing all data. How can you fix all column widths at the same time?
- shorten the text so it fits
- select all columns and double-click one of the selected column dividers
- drag a divider across
- click the Format button
Practice Quiz
7. 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
8. What is the first thing you should do when checking spelling errors in Excel?
- Click the Spelling button
- Find the misspelled data
- Select the data you want to check for spelling
- Use a dictionary
Shuffle Q/A 1
9. What feature can you use to fix text that appears in mixed case?
- AutoSum
- Audits
- Functions
- Filter
10. What is one of the functions you can use to change the text case in your data?
- CAP
- STRUCTURE
- LOWER
- CASE
