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

In =CLEAN, which is argument #1?

Question 2 of 10 2/10

What is the output type of =CLEAN?

Question 3 of 10 3/10

How many arguments does =CLEAN have in total?

Question 4 of 10 4/10

Is =CLEAN volatile?

Question 5 of 10 5/10

Which statement about =CLEAN is correct?

Question 6 of 10 6/10

Which use case fits =CLEAN?

Question 7 of 10 7/10

Which category does =CLEAN belong to?

Question 8 of 10 8/10

How many required arguments does =CLEAN have?

Question 9 of 10 9/10

How many optional arguments does =CLEAN have?

Question 10 of 10 10/10

Since which Excel version is =CLEAN available?

Click a question to see the answer.

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

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

Explanation: Argument #1 is “text”.

2. What is the output type of =CLEAN?

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

Explanation: Output is “Text”.

3. 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).

4. Is =CLEAN volatile?

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

Explanation: CLEAN is not volatile.

5. Which statement about =CLEAN is correct?

A. Volatile and recalculates every time
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. Requires add-in
D. Output is always a dynamic array

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.

6. Which use case fits =CLEAN?

A. Date & Time Calculations
B. Forecasting & Trends
C. Data Cleaning ✓
D. Financial Calculations

Explanation: Use case “Data Cleaning” fits CLEAN.

7. Which category does =CLEAN belong to?

A. Text ✓
B. Compatibility
C. Database
D. Financial

Explanation: Category is “Text”.

8. How many required arguments does =CLEAN have?

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

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

9. How many optional arguments does =CLEAN have?

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

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

10. Since which Excel version is =CLEAN available?

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

Explanation: Version: “All versions”.