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

Does =LEN return a dynamic array?

Question 3 of 10 3/10

Which statement about =LEN is correct?

Question 4 of 10 4/10

How many arguments does =LEN have in total?

Question 5 of 10 5/10

Which use case fits =LEN?

Question 6 of 10 6/10

Which formula is a valid example of =LEN?

Question 7 of 10 7/10

Since which Excel version is =LEN available?

Question 8 of 10 8/10

Which is the correct syntax of =LEN?

Question 9 of 10 9/10

What is the output type of =LEN?

Question 10 of 10 10/10

Which category does =LEN belong to?

Click a question to see the answer.

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

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

Explanation: “text” is required.

2. Does =LEN return a dynamic array?

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

Explanation: LEN does not spill.

3. 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. Requires add-in
D. Output is always a dynamic array

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

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

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

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

5. Which use case fits =LEN?

A. Comparation
B. Lookup & Retrieval
C. Daily Tasks ✓
D. Dynamic Ranges & Dashboards

Explanation: Use case “Daily Tasks” fits LEN.

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

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

Explanation: Correct example: =LEN(A2)

7. Since which Excel version is =LEN available?

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

Explanation: Version: “All versions”.

8. Which is the correct syntax of =LEN?

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

Explanation: Correct syntax: =LEN(text)

9. What is the output type of =LEN?

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

Explanation: Output is “Number”.

10. Which category does =LEN belong to?

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

Explanation: Category is “Text”.