Lookup & Reference =FORMULATEXT(reference)

Quiz =FORMULATEXT — 15 Questions

15 quiz questions about =FORMULATEXT — test syntax, arguments, examples & errors!

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

← FORMULATEXT ▦ Practice in Playground

Progress — 15 questions 1 of 15

Question 1 of 15 1/15

How many required arguments does =FORMULATEXT have?

Question 2 of 15 2/15

Since which Excel version is =FORMULATEXT available?

Question 3 of 15 3/15

What usually causes #VALUE! in =FORMULATEXT?

Question 4 of 15 4/15

How many arguments does =FORMULATEXT have in total?

Question 5 of 15 5/15

Is =FORMULATEXT volatile?

Question 6 of 15 6/15

What is the fix for #VALUE! in =FORMULATEXT?

Question 7 of 15 7/15

What is the type of argument “reference” in =FORMULATEXT?

Question 8 of 15 8/15

Does =FORMULATEXT return a dynamic array?

Question 9 of 15 9/15

What is the output type of =FORMULATEXT?

Question 10 of 15 10/15

Which category does =FORMULATEXT belong to?

Question 11 of 15 11/15

In =FORMULATEXT, which is argument #1?

Question 12 of 15 12/15

Is argument “reference” required in =FORMULATEXT?

Question 13 of 15 13/15

Which use case fits =FORMULATEXT?

Question 14 of 15 14/15

Which is the correct syntax of =FORMULATEXT?

Question 15 of 15 15/15

How many optional arguments does =FORMULATEXT have?

Click a question to see the answer.

1. How many required arguments does =FORMULATEXT have?

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

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

2. Since which Excel version is =FORMULATEXT available?

A. Excel 365
B. Excel 2019
C. Excel 2013 ✓
D. All versions

Explanation: Version: “Excel 2013”.

3. What usually causes #VALUE! in =FORMULATEXT?

A. Requires add-in
B. Invalid data types used as inputs will produce a #VALUE! error value. ✓
C. Text is always ignored
D. Select entire column for best performance

Explanation: Invalid data types used as inputs will produce a #VALUE! error value. — Fix: برای Reference مرجع سلول معتبر وارد کنید، نه مقدار متنی یا عددی نامعتبر.

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

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

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

5. Is =FORMULATEXT volatile?

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

Explanation: FORMULATEXT is not volatile.

6. What is the fix for #VALUE! in =FORMULATEXT?

A. آرگومان Reference به کتاب کار بسته اشاره دارد، یا سلول مرجع حاوی فرمول نیست، یا فرمول طولانی‌تر از ۸۱۹۲ نویسه است یا قابل نمایش نیست.
B. برای Reference مرجع سلول معتبر وارد کنید، نه مقدار متنی یا عددی نامعتبر. ✓
C. Only works in old versions
D. Requires add-in

7. What is the type of argument “reference” in =FORMULATEXT?

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

Explanation: Type of “reference” is “Reference”.

8. Does =FORMULATEXT return a dynamic array?

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

Explanation: FORMULATEXT does not spill.

9. What is the output type of =FORMULATEXT?

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

Explanation: Output is “Text”.

10. Which category does =FORMULATEXT belong to?

A. Lookup & Reference ✓
B. Web
C. Math & Trig
D. Compatibility

Explanation: Category is “Lookup & Reference”.

11. In =FORMULATEXT, which is argument #1?

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

Explanation: Argument #1 is “reference”.

12. Is argument “reference” required in =FORMULATEXT?

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

Explanation: “reference” is required.

13. Which use case fits =FORMULATEXT?

A. Financial Calculations
B. Depreciation
C. Worksheet Info & Navigation ✓
D. Comparation

Explanation: Use case “Worksheet Info & Navigation” fits FORMULATEXT.

14. Which is the correct syntax of =FORMULATEXT?

A. =EXACT(reference)
B. =FORMULATEXT(reference) ✓
C. FORMULATEXT(reference)
D. =FORMULATEXT(reference, 0)

Explanation: Correct syntax: =FORMULATEXT(reference)

15. How many optional arguments does =FORMULATEXT have?

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

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