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

Which statement about =CLEAN is correct?

Question 2 of 15 2/15

Is argument “text” required in =CLEAN?

Question 3 of 15 3/15

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

Question 4 of 15 4/15

Since which Excel version is =CLEAN available?

Question 5 of 15 5/15

Is =CLEAN volatile?

Question 6 of 15 6/15

Which use case fits =CLEAN?

Question 7 of 15 7/15

Does =CLEAN return a dynamic array?

Question 8 of 15 8/15

Which function is related to =CLEAN?

Question 9 of 15 9/15

In =CLEAN, which is argument #1?

Question 10 of 15 10/15

What is the output type of =CLEAN?

Question 11 of 15 11/15

How many optional arguments does =CLEAN have?

Question 12 of 15 12/15

How many arguments does =CLEAN have in total?

Question 13 of 15 13/15

Which formula is a valid example of =CLEAN?

Question 14 of 15 14/15

Which category does =CLEAN belong to?

Question 15 of 15 15/15

Which is the correct syntax of =CLEAN?

Click a question to see the answer.

1. Which statement about =CLEAN is correct?

A. Text is always ignored
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. Volatile and recalculates every time
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.

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

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

Explanation: “text” is required.

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

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

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

4. Since which Excel version is =CLEAN available?

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

Explanation: Version: “All versions”.

5. Is =CLEAN volatile?

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

Explanation: CLEAN is not volatile.

6. Which use case fits =CLEAN?

A. Advanced Formulas
B. Descriptive Statistics
C. Data Cleaning ✓
D. Reshape Tables

Explanation: Use case “Data Cleaning” fits CLEAN.

7. Does =CLEAN return a dynamic array?

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

Explanation: CLEAN does not spill.

8. Which function is related to =CLEAN?

A. COMBIN
B. REGEXREPLACE ✓
C. DSUM
D. PERMUT

Explanation: “REGEXREPLACE” is related to CLEAN.

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

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

Explanation: Argument #1 is “text”.

10. What is the output type of =CLEAN?

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

Explanation: Output is “Text”.

11. How many optional arguments does =CLEAN have?

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

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

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

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

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

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

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

Explanation: Correct example: =CLEAN(A2)

14. Which category does =CLEAN belong to?

A. Text ✓
B. Information
C. Engineering
D. Compatibility

Explanation: Category is “Text”.

15. Which is the correct syntax of =CLEAN?

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

Explanation: Correct syntax: =CLEAN(text)