Text =CLEAN(text)

Quiz =CLEAN — 10 Questions

10 quiz questions about =CLEAN — test syntax, arguments, examples & errors!

Questions: 10 questions 15 questions Random 10 or 15 questions from the pool + shuffled options each time

← CLEAN ▦ Practice in Playground

Progress — 10 questions 1 of 10

Question 1 of 10 1/10

Since which Excel version is =CLEAN available?

Question 2 of 10 2/10

Which function is related to =CLEAN?

Question 3 of 10 3/10

Which is the correct syntax of =CLEAN?

Question 4 of 10 4/10

How many arguments does =CLEAN have in total?

Question 5 of 10 5/10

Which formula is a valid example of =CLEAN?

Question 6 of 10 6/10

What is the type of argument “text” in =CLEAN?

Question 7 of 10 7/10

What is the output type of =CLEAN?

Question 8 of 10 8/10

Which use case fits =CLEAN?

Question 9 of 10 9/10

Which function is NOT related to =CLEAN?

Question 10 of 10 10/10

Which statement about =CLEAN is correct?

Click a question to see the answer.

1. Since which Excel version is =CLEAN available?

A. Excel 2019
B. Excel 2007 (Compatibility)
C. Excel 365
D. All versions ✓

Explanation: Version: “All versions”.

2. Which function is related to =CLEAN?

A. DROP
B. REGEXREPLACE ✓
C. GETPIVOTDATA
D. COLUMN

Explanation: “REGEXREPLACE” is related to CLEAN.

3. Which is the correct syntax of =CLEAN?

A. =CLEAN(text) ✓
B. =REGEXREPLACE(text)
C. CLEAN(text)
D. =CLEAN(text, 0)

Explanation: Correct syntax: =CLEAN(text)

4. How many arguments does =CLEAN have in total?

A. 1 ✓
B. 3
C. 2
D. 4

Explanation: =CLEAN has 1 required, 0 optional (1 total).

5. Which formula is a valid example of =CLEAN?

A. =CLEAN(A2, 0)
B. CLEAN(A2)
C. =CLEAN(A2) ✓
D. =REGEXREPLACE(A2)

Explanation: Correct example: =CLEAN(A2)

6. What is the type of argument “text” in =CLEAN?

A. Text ✓
B. Value
C. Date
D. Reference

Explanation: Type of “text” is “Text”.

7. What is the output type of =CLEAN?

A. Value
B. Date
C. Number
D. Text ✓

Explanation: Output is “Text”.

8. Which use case fits =CLEAN?

A. Securities & Bonds
B. Data Cleaning ✓
C. Loans & Installments
D. Date & Time Calculations

Explanation: Use case “Data Cleaning” fits CLEAN.

9. Which function is NOT related to =CLEAN?

A. TRIM
B. SUBSTITUTE
C. FILTER ✓
D. REGEXREPLACE

Explanation: “FILTER” is not related to CLEAN.

10. Which statement about =CLEAN is correct?

A. Requires add-in
B. The CLEAN function was designed to remove the first 32 nonprinting characters in the 7-bit ASCII code (values 0 through 31) from text. In the Unicode character set, there are additional nonprinting characters (values 127, 129, 141, 143, 144, and 157). By itself, the CLEAN function does not remove these additional nonprinting characters. For an example of how to remove these additional nonprinting characters from text, see Top ten ways to clean your data. ✓
C. Only works in old versions
D. Select entire column for best performance

Explanation: Correct: The CLEAN function was designed to remove the first 32 nonprinting characters in the 7-bit ASCII code (values 0 through 31) from text. In the Unicode character set, there are additional nonprinting characters (values 127, 129, 141, 143, 144, and 157). By itself, the CLEAN function does not remove these additional nonprinting characters. For an example of how to remove these additional nonprinting characters from text, see Top ten ways to clean your data.