Text =LEN(text)

Quiz =LEN — 10 Questions

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

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

← LEN ▦ Practice in Playground

Progress — 10 questions 1 of 10

Question 1 of 10 1/10

Is argument “text” required in =LEN?

Question 2 of 10 2/10

Which is the correct syntax of =LEN?

Question 3 of 10 3/10

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

Question 4 of 10 4/10

Which statement about =LEN is correct?

Question 5 of 10 5/10

How many required arguments does =LEN have?

Question 6 of 10 6/10

Which function is NOT related to =LEN?

Question 7 of 10 7/10

In =LEN, which is argument #1?

Question 8 of 10 8/10

How many optional arguments does =LEN have?

Question 9 of 10 9/10

Is =LEN volatile?

Question 10 of 10 10/10

Which use case fits =LEN?

Click a question to see the answer.

1. Is argument “text” required in =LEN?

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

Explanation: “text” is required.

2. Which is the correct syntax of =LEN?

A. =LEN(text) ✓
B. =RIGHT(text)
C. LEN(text)
D. =LEN(text, 0)

Explanation: Correct syntax: =LEN(text)

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

A. Date
B. Array
C. Any type ✓
D. Logical

Explanation: Type of “text” is “Any type”.

4. Which statement about =LEN is correct?

A. The LENB function is deprecated. In workbooks set to Compatibility Version 2, LEN has improved behavior with Surrogate Pairs, counting them as one character instead of two. Variation Selectors (commonly used with emojis) will still be counted as separate characters. Read more here: The Unicode standard ✓
B. Volatile and recalculates every time
C. Text is always ignored
D. Requires add-in

Explanation: Correct: The LENB function is deprecated. In workbooks set to Compatibility Version 2, LEN has improved behavior with Surrogate Pairs, counting them as one character instead of two. Variation Selectors (commonly used with emojis) will still be counted as separate characters. Read more here: The Unicode standard

5. How many required arguments does =LEN have?

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

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

6. Which function is NOT related to =LEN?

A. RIGHT
B. TRIMRANGE ✓
C. SUBSTITUTE
D. TRIM

Explanation: “TRIMRANGE” is not related to LEN.

7. In =LEN, which is argument #1?

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

Explanation: Argument #1 is “text”.

8. How many optional arguments does =LEN have?

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

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

9. Is =LEN volatile?

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

Explanation: LEN is not volatile.

10. Which use case fits =LEN?

A. Daily Tasks ✓
B. Reshape Tables
C. Reporting
D. Comparation

Explanation: Use case “Daily Tasks” fits LEN.