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

How many arguments does =LEN have in total?

Question 2 of 10 2/10

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

Question 3 of 10 3/10

Which function is NOT related to =LEN?

Question 4 of 10 4/10

Which formula is a valid example of =LEN?

Question 5 of 10 5/10

How many required arguments does =LEN have?

Question 6 of 10 6/10

Does =LEN return a dynamic array?

Question 7 of 10 7/10

Which statement about =LEN is correct?

Question 8 of 10 8/10

What is the output type of =LEN?

Question 9 of 10 9/10

Which is the correct syntax of =LEN?

Question 10 of 10 10/10

How many optional arguments does =LEN have?

Click a question to see the answer.

1. How many arguments does =LEN have in total?

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

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

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

A. Any type ✓
B. Reference
C. Value
D. Date

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

3. Which function is NOT related to =LEN?

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

Explanation: “DURATION” is not related to LEN.

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

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

Explanation: Correct example: =LEN(A2)

5. How many required arguments does =LEN have?

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

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

6. Does =LEN return a dynamic array?

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

Explanation: LEN does not spill.

7. Which statement about =LEN is correct?

A. Output is always a dynamic array
B. Text is always ignored
C. 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 ✓
D. Only works in old versions

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

8. What is the output type of =LEN?

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

Explanation: Output is “Number”.

9. Which is the correct syntax of =LEN?

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

Explanation: Correct syntax: =LEN(text)

10. How many optional arguments does =LEN have?

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

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