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

Which formula is a valid example of =CLEAN?

Question 2 of 10 2/10

How many arguments does =CLEAN have in total?

Question 3 of 10 3/10

What is the output type of =CLEAN?

Question 4 of 10 4/10

Which statement about =CLEAN is correct?

Question 5 of 10 5/10

Does =CLEAN return a dynamic array?

Question 6 of 10 6/10

Is argument “text” required in =CLEAN?

Question 7 of 10 7/10

In =CLEAN, which is argument #1?

Question 8 of 10 8/10

Is =CLEAN volatile?

Question 9 of 10 9/10

Since which Excel version is =CLEAN available?

Question 10 of 10 10/10

Which function is related to =CLEAN?

Click a question to see the answer.

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

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

Explanation: Correct example: =CLEAN(A2)

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

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

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

3. What is the output type of =CLEAN?

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

Explanation: Output is “Text”.

4. Which statement about =CLEAN is correct?

A. Output is always a dynamic array
B. Select entire column for best performance
C. Text is always ignored
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. Does =CLEAN return a dynamic array?

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

Explanation: CLEAN does not spill.

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

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

Explanation: “text” is required.

7. In =CLEAN, which is argument #1?

A. text ✓
B. range
C. criteria
D. value

Explanation: Argument #1 is “text”.

8. Is =CLEAN volatile?

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

Explanation: CLEAN is not volatile.

9. Since which Excel version is =CLEAN available?

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

Explanation: Version: “All versions”.

10. Which function is related to =CLEAN?

A. MAKEARRAY
B. PV
C. ODDLYIELD
D. REGEXREPLACE ✓

Explanation: “REGEXREPLACE” is related to CLEAN.