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

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

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

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

Graded Quiz

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

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

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

  • You must delete the empty rows one at a time
  • Use Remove Duplicates to remove empty rows
  • Use Search & Replace to look for empty rows and delete
  • 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?

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

16. What does the PROPER function do?

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

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

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

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

  • Text Import wizard
  • Format button
  • 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

  • Flash Fill feature
  • Format Painter tool
  • Text to Columns feature
  • Paste Special

Leave a Reply