excel basics for data analysis coursera answers week 3

Basics of Data Quality and Privacy

Practice Quiz

1. What is the first and most significant part of data quality?

  • Relevance
  • Reliability
  • Accuracy
  • Completeness

2. Which data quality trait refers to the availability and accessibility of the data?

  • Completeness
  • Timeliness
  • Reliability
  • Accuracy

3. What is a delimited file?

  • file with no spaces between data fields 
  • file with data fields separated by characters like commas or tabs 
  • file with data fields separated by fixed-widths
  • file with text qualifiers between data fields 

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?

  • drag a divider across
  • select all columns and double-click one of the selected column dividers
  • click the Format button
  • shorten the text so it fits

Cleaning Data

Practice Quiz

7. According to the video, what's one of the easiest common errors or inconsistencies to fix when importing data?

  • Duplicated data 
  • Empty rows
  • Spelling mistakes 
  • Extra white space

8. What is the first thing you should do when checking spelling errors in Excel?

  • Click the Spelling button 
  • Use a dictionary
  • Find the misspelled data 
  • Select the data you want to check for spelling

9. What feature can you use to fix text that appears in mixed case?

  • AutoSum
  • Filter
  • Audits
  • Functions

10. What is one of the functions you can use to change the text case in your data?

  • CASE
  • CAP

11. What does the Flash Fill feature have in common with the UPPER, LOWER, and PROPER functions?

  • Requires a helper column or row 
  • Lookup & Reference 
  • Repairs a REF error
  • Keeps cell formatting

12. Which of the following tasks can Flash Fill do? Select all that apply.

  • Combine two columns of data into one

  • Remove empty rows
  • Set column width 
  • Split one column of data into two 

Graded Quiz

13. What is one of the issues that empty rows cause in your spreadsheet?

  • Data will be hidden
  • Spell-check will fail
  • Formula errors
  • Indexing function error

14. How can you remove all empty rows at the same time in your imported spreadsheet?

  • Use Search & Replace to look for empty rows and delete
  • You must delete the empty rows one at a time
  • Use Remove Duplicates to remove empty rows
  • Select all rows and then filter for Blanks, select these and then delete

15. There are two methods to locate and remove duplicated rows in Excel, what is the easiest way?

  • Select all data and click the Remove Duplicates button
  • Select a column and choose Conditional Formatting > Highlight Cells Rules > Duplicate Values
  • Search for the first character in rows
  • Use the HLOOKUP function

16. What does the PROPER function do?

  • Changes text to sentence case
  • Repairs a REF error
  • Converts upper case text to lower case
  • Converts lower case text to upper case

17. Why do you need to use the Paste Values option when you paste contents from a helper row to the original row?

  • Keeps cell formatting the same
  • Makes sure formulas aren’t also copied
  • Validates the copied function
  • Ensures consistency

18. What is one of the ways to apply new data formats to the rest of a column?

  • Format button
  • Text Import wizard
  • Paste Special tool
  • Format Painter tool

19. What tools or features can we use to split a single column with two names in, into two separate columns with a name in each? Select all that apply

  • Paste Special
  • Flash Fill feature

  • Text to Columns feature

  • Format Painter tool

Leave a Reply