Text =TRIM(text)

Quiz =TRIM — 15 Questions

15 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 — 15 questions 1 of 15

Question 1 of 15 1/15

Which is the correct syntax of =TRIM?

Question 2 of 15 2/15

What is the output type of =TRIM?

Question 3 of 15 3/15

In =TRIM, which is argument #2?

Question 4 of 15 4/15

Which formula is a valid example of =TRIM?

Question 5 of 15 5/15

In =TRIM, which is argument #1?

Question 6 of 15 6/15

How many optional arguments does =TRIM have?

Question 7 of 15 7/15

Since which Excel version is =TRIM available?

Question 8 of 15 8/15

Which category does =TRIM belong to?

Question 9 of 15 9/15

How many required arguments does =TRIM have?

Question 10 of 15 10/15

Which function is NOT related to =TRIM?

Question 11 of 15 11/15

Is argument “string” required in =TRIM?

Question 12 of 15 12/15

Which statement about =TRIM is correct?

Question 13 of 15 13/15

Which function is related to =TRIM?

Question 14 of 15 14/15

What is the type of argument “cell” in =TRIM?

Question 15 of 15 15/15

Which use case fits =TRIM?

Click a question to see the answer.

1. Which is the correct syntax of =TRIM?

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

Explanation: Correct syntax: =TRIM(text)

2. What is the output type of =TRIM?

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

Explanation: Output is “Text”.

3. In =TRIM, which is argument #2?

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

Explanation: Argument #2 is “cell”.

4. Which formula is a valid example of =TRIM?

A. =TRIM(" Sales report ") ✓
B. =CLEAN(" Sales report ")
C. TRIM(" Sales report ")
D. =TRIM(" Sales report ", 0)

Explanation: Correct example: =TRIM(" Sales report ")

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

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

Explanation: Argument #1 is “string”.

6. How many optional arguments does =TRIM have?

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

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

7. Since which Excel version is =TRIM available?

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

Explanation: Version: “All versions”.

8. Which category does =TRIM belong to?

A. Text ✓
B. Compatibility
C. Engineering
D. Date & Time

Explanation: Category is “Text”.

9. How many required arguments does =TRIM have?

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

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

10. Which function is NOT related to =TRIM?

A. SUBSTITUTE
B. VLOOKUP
C. CLEAN
D. GAMMALN.PRECISE ✓

Explanation: “GAMMALN.PRECISE” is not related to TRIM.

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

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

Explanation: “string” is required.

12. Which statement about =TRIM is correct?

A. 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. ✓
B. Requires add-in
C. Output is always a dynamic array
D. Text is always ignored

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.

13. Which function is related to =TRIM?

A. DROP
B. PERCENTOF
C. T.DIST.RT
D. CLEAN ✓

Explanation: “CLEAN” is related to TRIM.

14. What is the type of argument “cell” in =TRIM?

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

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

15. Which use case fits =TRIM?

A. Daily Tasks ✓
B. External Data, Web & Cube
C. Conditional Formatting & Validation
D. Depreciation

Explanation: Use case “Daily Tasks” fits TRIM.