Text =TEXT(value, format_text)

Quiz =TEXT — 10 Questions

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

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

← TEXT ▦ Practice in Playground

Progress — 10 questions 1 of 10

Question 1 of 10 1/10

Does =TEXT return a dynamic array?

Question 2 of 10 2/10

How many optional arguments does =TEXT have?

Question 3 of 10 3/10

Which function is NOT related to =TEXT?

Question 4 of 10 4/10

Is argument “format_text” required in =TEXT?

Question 5 of 10 5/10

Which function is related to =TEXT?

Question 6 of 10 6/10

Which formula is a valid example of =TEXT?

Question 7 of 10 7/10

Which use case fits =TEXT?

Question 8 of 10 8/10

What is the output type of =TEXT?

Question 9 of 10 9/10

How many arguments does =TEXT have in total?

Question 10 of 10 10/10

In =TEXT, which is argument #2?

Click a question to see the answer.

1. Does =TEXT return a dynamic array?

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

Explanation: TEXT does not spill.

2. How many optional arguments does =TEXT have?

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

Explanation: =TEXT has 2 required, 0 optional (2 total).

3. Which function is NOT related to =TEXT?

A. VALUE
B. CONCAT
C. REPT
D. DOLLARDE ✓

Explanation: “DOLLARDE” is not related to TEXT.

4. Is argument “format_text” required in =TEXT?

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

Explanation: “format_text” is required.

5. Which function is related to =TEXT?

A. LOGINV
B. CONCAT ✓
C. ERF
D. NOT

Explanation: “CONCAT” is related to TEXT.

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

A. =CONCAT(Value you want to format, "Format code you want to apply")
B. =TEXT(Value you want to format, "Format code you want to apply", 0)
C. TEXT(Value you want to format, "Format code you want to apply")
D. =TEXT(Value you want to format, "Format code you want to apply") ✓

Explanation: Correct example: =TEXT(Value you want to format, "Format code you want to apply")

7. Which use case fits =TEXT?

A. Advanced Formulas
B. Daily Tasks ✓
C. Lookup & Retrieval
D. Loans & Installments

Explanation: Use case “Daily Tasks” fits TEXT.

8. What is the output type of =TEXT?

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

Explanation: Output is “Text”.

9. How many arguments does =TEXT have in total?

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

Explanation: =TEXT has 2 required, 0 optional (2 total).

10. In =TEXT, which is argument #2?

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

Explanation: Argument #2 is “format_text”.