Get Certified for Free Browse courses

Spreadsheets · Level 3 of 5 · Intermediate

Sorting, filtering, and cleaning data

Sort, filter, remove duplicates, and fix messy text.

Study notes

  1. Sort orders rows by a column. Select the whole table first so rows stay together.
  2. Filters hide rows that do not match criteria without deleting anything.
  3. Remove duplicates carefully. Decide which columns define a duplicate before you delete.
  4. TRIM removes extra spaces. UPPER, LOWER, and PROPER change letter case.
  5. Split text into columns by a delimiter such as a comma, and join text with & or TEXTJOIN.

Quiz: 6 questions

Choose one answer for each question, then check your answers. Score 5 of 6 to pass. Then enter your name and email to download a PDF certificate and have a copy emailed to you. Answers are graded in your browser.

1. Why select the whole table before sorting?

2. A filter:

3. =TRIM(" Ann Lee ") returns:

4. =PROPER("maria lopez") returns:

5. Before removing duplicates you should decide:

6. To join first name in A2 and last name in B2 with a space:

About this certificate: Certificates are issued by Get Certified for Free for passing a free online knowledge quiz. They are not accredited, licensed, government, academic, or professional credentials and do not confer a license. Read the full terms.