Text =CLEAN(text)

Quiz =CLEAN — 15 Questions

15 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 — 15 questions 1 of 15

Question 1 of 15 1/15

How many required arguments does =CLEAN have?

Question 2 of 15 2/15

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

Question 3 of 15 3/15

Since which Excel version is =CLEAN available?

Question 4 of 15 4/15

Which statement about =CLEAN is correct?

Question 5 of 15 5/15

Is argument “text” required in =CLEAN?

Question 6 of 15 6/15

Is =CLEAN volatile?

Question 7 of 15 7/15

Which use case fits =CLEAN?

Question 8 of 15 8/15

Which function is related to =CLEAN?

Question 9 of 15 9/15

How many optional arguments does =CLEAN have?

Question 10 of 15 10/15

Which category does =CLEAN belong to?

Question 11 of 15 11/15

How many arguments does =CLEAN have in total?

Question 12 of 15 12/15

Does =CLEAN return a dynamic array?

Question 13 of 15 13/15

What is the output type of =CLEAN?

Question 14 of 15 14/15

Which is the correct syntax of =CLEAN?

Question 15 of 15 15/15

Which formula is a valid example of =CLEAN?

Click a question to see the answer.

1. How many required arguments does =CLEAN have?

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

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

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

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

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

3. Since which Excel version is =CLEAN available?

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

Explanation: Version: “All versions”.

4. Which statement about =CLEAN is correct?

A. Volatile and recalculates every time
B. Only works in old versions
C. Select entire column for best performance
D. 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. ✓

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.

5. Is argument “text” required in =CLEAN?

A. Yes
B. —
C. No
D. Yes ✓

Explanation: “text” is required.

6. Is =CLEAN volatile?

A. Yes
B. —
C. No ✓
D. No

Explanation: CLEAN is not volatile.

7. Which use case fits =CLEAN?

A. Data Cleaning ✓
B. Text Manipulation
C. Conditional Formatting & Validation
D. Scientific & Unit Conversion

Explanation: Use case “Data Cleaning” fits CLEAN.

8. Which function is related to =CLEAN?

A. GROWTH
B. REGEXTEST
C. CHOOSEROWS
D. REGEXREPLACE ✓

Explanation: “REGEXREPLACE” is related to CLEAN.

9. How many optional arguments does =CLEAN have?

A. 0 ✓
B. 2
C. 1
D. —

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

10. Which category does =CLEAN belong to?

A. Text ✓
B. Cube
C. Statistical
D. Database

Explanation: Category is “Text”.

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

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

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

12. Does =CLEAN return a dynamic array?

A. No ✓
B. Yes
C. —
D. No

Explanation: CLEAN does not spill.

13. What is the output type of =CLEAN?

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

Explanation: Output is “Text”.

14. Which is the correct syntax of =CLEAN?

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

Explanation: Correct syntax: =CLEAN(text)

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

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

Explanation: Correct example: =CLEAN(A2)