Text =TRIM(text)

Quiz =TRIM — 10 Questions

10 quiz questions about =TRIM — test syntax, arguments, examples & errors!

Questions: 10 questions 15 questions Random 10 or 15 questions from the pool + shuffled options each time

← TRIM ▦ Practice in Playground

Progress — 10 questions 1 of 10

Question 1 of 10 1/10

Is argument “cell” required in =TRIM?

Question 2 of 10 2/10

Is argument “string” required in =TRIM?

Question 3 of 10 3/10

How many required arguments does =TRIM have?

Question 4 of 10 4/10

Which category does =TRIM belong to?

Question 5 of 10 5/10

In =TRIM, which is argument #1?

Question 6 of 10 6/10

Which function is related to =TRIM?

Question 7 of 10 7/10

Which statement about =TRIM is correct?

Question 8 of 10 8/10

How many optional arguments does =TRIM have?

Question 9 of 10 9/10

What is the output type of =TRIM?

Question 10 of 10 10/10

Which is the correct syntax of =TRIM?

Click a question to see the answer.

1. Is argument “cell” required in =TRIM?

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

Explanation: “cell” is required.

2. Is argument “string” required in =TRIM?

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

Explanation: “string” is required.

3. How many required arguments does =TRIM have?

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

Explanation: =TRIM has 2 required, 0 optional (2 total).

4. Which category does =TRIM belong to?

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

Explanation: Category is “Text”.

5. In =TRIM, which is argument #1?

A. string ✓
B. criteria
C. range
D. cell

Explanation: Argument #1 is “string”.

6. Which function is related to =TRIM?

A. STDEV.S
B. ASIN
C. CLEAN ✓
D. AVERAGEIF

Explanation: “CLEAN” is related to TRIM.

7. Which statement about =TRIM is correct?

A. Volatile and recalculates every time
B. Text is always ignored
C. The TRIM function was designed to trim the 7-bit ASCII space character (value 32) from text. In the Unicode character set, there is an additional space character called the nonbreaking space character that has a decimal value of 160. This character is commonly used in Web pages as the HTML entity, ** **. By itself, the TRIM function does not remove this nonbreaking space character. For an example of how to trim both space characters from text, see Top ten ways to clean your data. ✓
D. Only works in old versions

Explanation: Correct: The TRIM function was designed to trim the 7-bit ASCII space character (value 32) from text. In the Unicode character set, there is an additional space character called the nonbreaking space character that has a decimal value of 160. This character is commonly used in Web pages as the HTML entity, ** **. By itself, the TRIM function does not remove this nonbreaking space character. For an example of how to trim both space characters from text, see Top ten ways to clean your data.

8. How many optional arguments does =TRIM have?

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

Explanation: =TRIM has 2 required, 0 optional (2 total).

9. What is the output type of =TRIM?

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

Explanation: Output is “Text”.

10. Which is the correct syntax of =TRIM?

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

Explanation: Correct syntax: =TRIM(text)