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

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

Question 2 of 15 2/15

How many required arguments does =LEN have?

Question 3 of 15 3/15

How many optional arguments does =LEN have?

Question 4 of 15 4/15

In =LEN, which is argument #1?

Question 5 of 15 5/15

Which use case fits =LEN?

Question 6 of 15 6/15

Which formula is a valid example of =LEN?

Question 7 of 15 7/15

Which function is NOT related to =LEN?

Question 8 of 15 8/15

Is argument “text” required in =LEN?

Question 9 of 15 9/15

Which statement about =LEN is correct?

Question 10 of 15 10/15

What is the output type of =LEN?

Question 11 of 15 11/15

Which is the correct syntax of =LEN?

Question 12 of 15 12/15

How many arguments does =LEN have in total?

Question 13 of 15 13/15

Since which Excel version is =LEN available?

Question 14 of 15 14/15

Does =LEN return a dynamic array?

Question 15 of 15 15/15

Which function is related to =LEN?

Click a question to see the answer.

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

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

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

2. How many required arguments does =LEN have?

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

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

3. How many optional arguments does =LEN have?

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

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

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

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

Explanation: Argument #1 is “text”.

5. Which use case fits =LEN?

A. Loans & Installments
B. Text Manipulation
C. Scientific & Unit Conversion
D. Daily Tasks ✓

Explanation: Use case “Daily Tasks” fits LEN.

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

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

Explanation: Correct example: =LEN(A2)

7. Which function is NOT related to =LEN?

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

Explanation: “POISSON” is not related to LEN.

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

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

Explanation: “text” is required.

9. Which statement about =LEN is correct?

A. Only works in old versions
B. Select entire column for best performance
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. 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

10. What is the output type of =LEN?

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

Explanation: Output is “Number”.

11. Which is the correct syntax of =LEN?

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

Explanation: Correct syntax: =LEN(text)

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

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

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

13. Since which Excel version is =LEN available?

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

Explanation: Version: “All versions”.

14. Does =LEN return a dynamic array?

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

Explanation: LEN does not spill.

15. Which function is related to =LEN?

A. RECEIVED
B. REDUCE
C. RIGHT ✓
D. CUBESET

Explanation: “RIGHT” is related to LEN.