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

Does =CLEAN return a dynamic array?

Question 2 of 10 2/10

Which is the correct syntax of =CLEAN?

Question 3 of 10 3/10

How many optional arguments does =CLEAN have?

Question 4 of 10 4/10

Which statement about =CLEAN is correct?

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

How many required arguments does =CLEAN have?

Question 8 of 10 8/10

Is argument “text” required in =CLEAN?

Question 9 of 10 9/10

Which category does =CLEAN belong to?

Question 10 of 10 10/10

How many arguments does =CLEAN have in total?

Click a question to see the answer.

1. Does =CLEAN return a dynamic array?

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

Explanation: CLEAN does not spill.

2. Which is the correct syntax of =CLEAN?

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

Explanation: Correct syntax: =CLEAN(text)

3. How many optional arguments does =CLEAN have?

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

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

4. Which statement about =CLEAN is correct?

A. Text is always ignored
B. Select entire column for best performance
C. Volatile and recalculates every time
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. Which formula is a valid example of =CLEAN?

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

Explanation: Correct example: =CLEAN(A2)

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

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

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

7. How many required arguments does =CLEAN have?

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

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

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

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

Explanation: “text” is required.

9. Which category does =CLEAN belong to?

A. Text ✓
B. Financial
C. Date & Time
D. Information

Explanation: Category is “Text”.

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

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

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