Lookup & Reference =HLOOKUP(lookup_value, table_array, row_index_num, [range_lookup])

Quiz =HLOOKUP — 15 Questions

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

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

← HLOOKUP ▦ Practice in Playground

Progress — 15 questions 1 of 15

Question 1 of 15 1/15

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

Question 2 of 15 2/15

Does =HLOOKUP return a dynamic array?

Question 3 of 15 3/15

Which function is NOT related to =HLOOKUP?

Question 4 of 15 4/15

How many optional arguments does =HLOOKUP have?

Question 5 of 15 5/15

In =HLOOKUP, which is argument #1?

Question 6 of 15 6/15

Which use case fits =HLOOKUP?

Question 7 of 15 7/15

Which formula is a valid example of =HLOOKUP?

Question 8 of 15 8/15

How many arguments does =HLOOKUP have in total?

Question 9 of 15 9/15

Is argument “table_array” required in =HLOOKUP?

Question 10 of 15 10/15

Is argument “row_index_num” required in =HLOOKUP?

Question 11 of 15 11/15

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

Question 12 of 15 12/15

What is the type of argument “table_array” in =HLOOKUP?

Question 13 of 15 13/15

Which statement about =HLOOKUP is correct?

Question 14 of 15 14/15

In =HLOOKUP, which is argument #2?

Question 15 of 15 15/15

Is argument “lookup_value” required in =HLOOKUP?

Click a question to see the answer.

1. What is the fix for #N/A in =HLOOKUP?

A. Check the lookup value and clean the data ✓
B. Requires add-in
C. مقدار row_index_num کمتر از ۱ است.
D. Volatile and recalculates every time

Explanation: If one is not found, the error value #N/A is returned. — Fix: Check the lookup value and clean the data

2. Does =HLOOKUP return a dynamic array?

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

Explanation: HLOOKUP does not spill.

3. Which function is NOT related to =HLOOKUP?

A. MATCH
B. VLOOKUP
C. EXPONDIST ✓
D. XLOOKUP

Explanation: “EXPONDIST” is not related to HLOOKUP.

4. How many optional arguments does =HLOOKUP have?

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

Explanation: =HLOOKUP has 3 required, 1 optional (4 total).

5. In =HLOOKUP, which is argument #1?

A. range_lookup
B. table_array
C. range
D. lookup_value ✓

Explanation: Argument #1 is “lookup_value”.

6. Which use case fits =HLOOKUP?

A. Securities & Bonds
B. Lookup & Retrieval ✓
C. Error Handling
D. Reshape Tables

Explanation: Use case “Lookup & Retrieval” fits HLOOKUP.

7. Which formula is a valid example of =HLOOKUP?

A. =HLOOKUP("Axles", A1:C4, 2, TRUE, 0)
B. HLOOKUP("Axles", A1:C4, 2, TRUE)
C. =MATCH("Axles", A1:C4, 2, TRUE)
D. =HLOOKUP("Axles", A1:C4, 2, TRUE) ✓

Explanation: Correct example: =HLOOKUP("Axles", A1:C4, 2, TRUE)

8. How many arguments does =HLOOKUP have in total?

A. 4 ✓
B. 6
C. 5
D. 3

Explanation: =HLOOKUP has 3 required, 1 optional (4 total).

9. Is argument “table_array” required in =HLOOKUP?

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

Explanation: “table_array” is required.

10. Is argument “row_index_num” required in =HLOOKUP?

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

Explanation: “row_index_num” is required.

11. What is the fix for #VALUE! in =HLOOKUP?

A. برای row_index_num عددی بین ۱ تا تعداد سطرهای table_array وارد کنید. ✓
B. Requires add-in
C. Only works in old versions
D. Text is always ignored

Explanation: If row_index_num is less than 1, HLOOKUP returns the #VALUE! error value; if row_index_num is greater than the number of rows on table_array, HLOOKUP returns the #REF! error value. — Fix: برای row_index_num عددی بین ۱ تا تعداد سطرهای table_array وارد کنید.

12. What is the type of argument “table_array” in =HLOOKUP?

A. Date
B. Reference
C. Mixed
D. Range ✓

Explanation: Type of “table_array” is “Range”.

13. Which statement about =HLOOKUP is correct?

A. Select entire column for best performance
B. Volatile and recalculates every time
C. Try using the new XLOOKUP function, an improved version of HLOOKUP that works in any direction and returns exact matches by default, making it easier and more convenient to use than its predecessor. ✓
D. Requires add-in

Explanation: Correct: Try using the new XLOOKUP function, an improved version of HLOOKUP that works in any direction and returns exact matches by default, making it easier and more convenient to use than its predecessor.

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

A. range_lookup
B. lookup_value
C. table_array ✓
D. row_index_num

Explanation: Argument #2 is “table_array”.

15. Is argument “lookup_value” required in =HLOOKUP?

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

Explanation: “lookup_value” is required.