Learn Excel EasyDaily One Lesson

Quiz › Data Cleaning › Clean up text

Clean up text: Excel Quiz

5 quick questions. Pick an answer to see if you are right.

  1. A1 has the name Ravi with 2 spaces before it and 2 after it. What will this formula return?
    =LEN(TRIM(A1))
    • A. Ravi
    • B. 6
    • C. 8
    • D. 4
    Show the answerD — 4. TRIM removes the 4 extra spaces. Then LEN counts R, a, v, i: 4.
  2. A1 has ravi kumar in small letters. What will this formula return?
    =PROPER(A1)
    • A. RAVI KUMAR
    • B. ravi kumar
    • C. Ravi kumar
    • D. Ravi Kumar
    Show the answerD — Ravi Kumar. PROPER makes the first letter of every word a capital.
  3. A1 has A-B-C. What will this formula return?
    =SUBSTITUTE(A1,"-","")
    • A. ABC
    • B. A-B-C
    • C. A
    • D. A B C
    Show the answerA — ABC. SUBSTITUTE swaps every - for nothing, so you get ABC.
  4. A1 has excel in small letters. What will this formula return?
    =UPPER(A1)
    • A. EXCEL
    • B. eXCEL
    • C. Excel
    • D. excel
    Show the answerA — EXCEL. UPPER turns every letter into a capital.
  5. Column A has Apple, Mango, Apple, Apple. You run Remove Duplicates. How many rows are left?
    • A. 3
    • B. 4
    • C. 1
    • D. 2
    Show the answerD — 2. Excel keeps one Apple and one Mango: 2 rows.

Want to learn this? Read the Data Cleaning lessons →
← More Data Cleaning topics · All quiz categories