# Spreadsheets Level 3: Sorting, filtering, and cleaning data (free quiz and certificate) | Get Certified for Free

Source: https://getcertifiedforfree.com/courses/spreadsheets/level-3/

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.
1. Filters hide rows that do not match criteria without deleting anything.
1. Remove duplicates carefully. Decide which columns define a duplicate before you delete.
1. TRIM removes extra spaces. UPPER, LOWER, and PROPER change letter case.
1. 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.

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](https://getcertifiedforfree.com/about-our-certificates/).

[← Level 2: Functions and references](https://getcertifiedforfree.com/courses/spreadsheets/level-2/) [Level 4: Lookups and pivot tables →](https://getcertifiedforfree.com/courses/spreadsheets/level-4/)