Lookup & Reference =FORMULATEXT(reference)

Quiz =FORMULATEXT — 10 Questions

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

Question 1 of 10 1/10

Which statement about =FORMULATEXT is correct?

Question 2 of 10 2/10

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

Question 3 of 10 3/10

Does =FORMULATEXT return a dynamic array?

Question 4 of 10 4/10

What is the fix for #N/A in =FORMULATEXT?

Question 5 of 10 5/10

Which formula is a valid example of =FORMULATEXT?

Question 6 of 10 6/10

Which use case fits =FORMULATEXT?

Question 7 of 10 7/10

What usually causes #N/A in =FORMULATEXT?

Question 8 of 10 8/10

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

Question 9 of 10 9/10

Since which Excel version is =FORMULATEXT available?

Question 10 of 10 10/10

How many optional arguments does =FORMULATEXT have?

Click a question to see the answer.

1. Which statement about =FORMULATEXT is correct?

A. If the Reference argument is to an entire row or column, or to a range or defined name containing more than one cell, FORMULATEXT returns the value in the upper leftmost cell of the row, column, or range.
B. The FORMULATEXT function returns what is displayed in the formula bar if you select the referenced cell. ✓
C. Select entire column for best performance
D. Output is always a dynamic array

Explanation: Correct: The FORMULATEXT function returns what is displayed in the formula bar if you select the referenced cell.

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

A. Text is always ignored
B. Volatile and recalculates every time
C. برای Reference مرجع سلول معتبر وارد کنید، نه مقدار متنی یا عددی نامعتبر. ✓
D. آرگومان Reference به کتاب کار بسته اشاره دارد، یا سلول مرجع حاوی فرمول نیست، یا فرمول طولانی‌تر از ۸۱۹۲ نویسه است یا قابل نمایش نیست.

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

3. Does =FORMULATEXT return a dynamic array?

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

Explanation: FORMULATEXT does not spill.

4. What is the fix for #N/A in =FORMULATEXT?

A. Check the input cell or manage the error with IFNA ✓
B. Volatile and recalculates every time
C. Text is always ignored
D. Output is always a dynamic array

Explanation: If the Reference argument is to another workbook that is not open, FORMULATEXT returns the #N/A error value. In the following cases, FORMULATEXT returns the #N/A error value: The cell used as the Reference argument does not contain a formula. — Fix: Check the input cell or manage the error with IFNA

5. Which formula is a valid example of =FORMULATEXT?

A. =EXACT(A1)
B. TODAY()
C. =TODAY() ✓
D. =TODAY(, 0)

Explanation: Correct example: =TODAY()

6. Which use case fits =FORMULATEXT?

A. Descriptive Statistics
B. Financial Calculations
C. Worksheet Info & Navigation ✓
D. Probability & Hypothesis Testing

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

7. What usually causes #N/A in =FORMULATEXT?

A. Select entire column for best performance
B. If the Reference argument is to another workbook that is not open, FORMULATEXT returns the #N/A error value. In the following cases, FORMULATEXT returns the #N/A error value: The cell used as the Reference argument does not contain a formula. ✓
C. Text is always ignored
D. Only works in old versions

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

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

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

9. Since which Excel version is =FORMULATEXT available?

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

Explanation: Version: “Excel 2013”.

10. How many optional arguments does =FORMULATEXT have?

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

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