Lookup & Reference =FIELDVALUE(value, field_name)

Quiz =FIELDVALUE — 15 Questions

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

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

← FIELDVALUE ▦ Practice in Playground

Progress — 15 questions 1 of 15

Question 1 of 15 1/15

Which formula is a valid example of =FIELDVALUE?

Question 2 of 15 2/15

Is argument “field_name” required in =FIELDVALUE?

Question 3 of 15 3/15

Which statement about =FIELDVALUE is correct?

Question 4 of 15 4/15

Which function is NOT related to =FIELDVALUE?

Question 5 of 15 5/15

What is the output type of =FIELDVALUE?

Question 6 of 15 6/15

How many required arguments does =FIELDVALUE have?

Question 7 of 15 7/15

Which category does =FIELDVALUE belong to?

Question 8 of 15 8/15

Is argument “value” required in =FIELDVALUE?

Question 9 of 15 9/15

Which is the correct syntax of =FIELDVALUE?

Question 10 of 15 10/15

Which use case fits =FIELDVALUE?

Question 11 of 15 11/15

Since which Excel version is =FIELDVALUE available?

Question 12 of 15 12/15

How many arguments does =FIELDVALUE have in total?

Question 13 of 15 13/15

In =FIELDVALUE, which is argument #1?

Question 14 of 15 14/15

In =FIELDVALUE, which is argument #2?

Question 15 of 15 15/15

What is the type of argument “value” in =FIELDVALUE?

Click a question to see the answer.

1. Which formula is a valid example of =FIELDVALUE?

A. =ADDRESS(A2,"Price")
B. =FIELDVALUE(A2,"Price") ✓
C. FIELDVALUE(A2,"Price")
D. =FIELDVALUE(A2,"Price", 0)

Explanation: Correct example: =FIELDVALUE(A2,"Price")

2. Is argument “field_name” required in =FIELDVALUE?

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

Explanation: “field_name” is required.

3. Which statement about =FIELDVALUE is correct?

A. Volatile and recalculates every time
B. Only works in old versions
C. Output is always a dynamic array
D. If you try to retrieve data from a non-existent data type field, the FIELDVALUE function will return the #FIELD! error. For instance, you might have entered "Prices", when the actual data type field is named "Price". Double-check your formula to make sure you're using a valid field name. If you want to display a list of field names for a record, select the cell for the record, and press Alt+Shift+F10. ✓

Explanation: Correct: If you try to retrieve data from a non-existent data type field, the FIELDVALUE function will return the #FIELD! error. For instance, you might have entered "Prices", when the actual data type field is named "Price". Double-check your formula to make sure you're using a valid field name. If you want to display a list of field names for a record, select the cell for the record, and press Alt+Shift+F10.

4. Which function is NOT related to =FIELDVALUE?

A. BESSELY ✓
B. AREAS
C. ADDRESS
D. CHOOSE

Explanation: “BESSELY” is not related to FIELDVALUE.

5. What is the output type of =FIELDVALUE?

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

Explanation: Output is “Text”.

6. How many required arguments does =FIELDVALUE have?

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

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

7. Which category does =FIELDVALUE belong to?

A. Compatibility
B. Cube
C. Lookup & Reference ✓
D. Financial

Explanation: Category is “Lookup & Reference”.

8. Is argument “value” required in =FIELDVALUE?

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

Explanation: “value” is required.

9. Which is the correct syntax of =FIELDVALUE?

A. FIELDVALUE(value, field_name)
B. =FIELDVALUE(value, field_name, 0)
C. =FIELDVALUE(value, field_name) ✓
D. =ADDRESS(value, field_name)

Explanation: Correct syntax: =FIELDVALUE(value, field_name)

10. Which use case fits =FIELDVALUE?

A. Investment Appraisal
B. Advanced Formulas
C. External Data, Web & Cube ✓
D. Workdays & Due Dates

Explanation: Use case “External Data, Web & Cube” fits FIELDVALUE.

11. Since which Excel version is =FIELDVALUE available?

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

Explanation: Version: “Excel for Microsoft 365”.

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

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

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

13. In =FIELDVALUE, which is argument #1?

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

Explanation: Argument #1 is “value”.

14. In =FIELDVALUE, which is argument #2?

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

Explanation: Argument #2 is “field_name”.

15. What is the type of argument “value” in =FIELDVALUE?

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

Explanation: Type of “value” is “Number”.