Text =LEN(text)

Quiz =LEN — 15 Questions

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

Question 1 of 15 1/15

Which is the correct syntax of =LEN?

Question 2 of 15 2/15

In =LEN, which is argument #1?

Question 3 of 15 3/15

Which formula is a valid example of =LEN?

Question 4 of 15 4/15

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

Question 5 of 15 5/15

Which function is NOT related to =LEN?

Question 6 of 15 6/15

Which use case fits =LEN?

Question 7 of 15 7/15

Since which Excel version is =LEN available?

Question 8 of 15 8/15

How many arguments does =LEN have in total?

Question 9 of 15 9/15

Which function is related to =LEN?

Question 10 of 15 10/15

What is the output type of =LEN?

Question 11 of 15 11/15

Is argument “text” required in =LEN?

Question 12 of 15 12/15

Which statement about =LEN is correct?

Question 13 of 15 13/15

Does =LEN return a dynamic array?

Question 14 of 15 14/15

How many optional arguments does =LEN have?

Question 15 of 15 15/15

Which category does =LEN belong to?

Click a question to see the answer.

1. Which is the correct syntax of =LEN?

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

Explanation: Correct syntax: =LEN(text)

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

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

Explanation: Argument #1 is “text”.

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

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

Explanation: Correct example: =LEN(A2)

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

A. Reference
B. Logical
C. Any type ✓
D. Mixed

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

5. Which function is NOT related to =LEN?

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

Explanation: “IMPOWER” is not related to LEN.

6. Which use case fits =LEN?

A. Error Handling
B. Financial Calculations
C. Daily Tasks ✓
D. Probability & Hypothesis Testing

Explanation: Use case “Daily Tasks” fits LEN.

7. Since which Excel version is =LEN available?

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

Explanation: Version: “All versions”.

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

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

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

9. Which function is related to =LEN?

A. ISNONTEXT
B. MAKEARRAY
C. RIGHT ✓
D. ASINH

Explanation: “RIGHT” is related to LEN.

10. What is the output type of =LEN?

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

Explanation: Output is “Number”.

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

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

Explanation: “text” is required.

12. Which statement about =LEN is correct?

A. Only works in old versions
B. 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 ✓
C. Requires add-in
D. Volatile and recalculates every time

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

13. Does =LEN return a dynamic array?

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

Explanation: LEN does not spill.

14. How many optional arguments does =LEN have?

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

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

15. Which category does =LEN belong to?

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

Explanation: Category is “Text”.