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

Quiz =HLOOKUP — 10 Questions

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

Question 1 of 10 1/10

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

Question 2 of 10 2/10

Is argument “lookup_value” required in =HLOOKUP?

Question 3 of 10 3/10

Which function is NOT related to =HLOOKUP?

Question 4 of 10 4/10

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

Question 5 of 10 5/10

Which statement about =HLOOKUP is correct?

Question 6 of 10 6/10

Which category does =HLOOKUP belong to?

Question 7 of 10 7/10

In =HLOOKUP, which is argument #2?

Question 8 of 10 8/10

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

Question 9 of 10 9/10

Is =HLOOKUP volatile?

Question 10 of 10 10/10

What is the output type of =HLOOKUP?

Click a question to see the answer.

1. What is the type of argument “range_lookup” in =HLOOKUP?

A. Value
B. Logical ✓
C. Array
D. Reference

Explanation: Type of “range_lookup” is “Logical”.

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

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

Explanation: “lookup_value” is required.

3. Which function is NOT related to =HLOOKUP?

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

Explanation: “CHIINV” is not related to HLOOKUP.

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

A. مقدار row_index_num کمتر از ۱ است.
B. Only works in old versions
C. Requires add-in
D. Check the lookup value and clean the data ✓

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

5. Which statement about =HLOOKUP is correct?

A. Text is always ignored
B. Requires add-in
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. Select entire column for best performance

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.

6. Which category does =HLOOKUP belong to?

A. Database
B. Math & Trig
C. Lookup & Reference ✓
D. Text

Explanation: Category is “Lookup & Reference”.

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

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

Explanation: Argument #2 is “table_array”.

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

A. Text is always ignored
B. مقدار row_index_num بزرگ‌تر از تعداد سطرهای table_array است.
C. برای row_index_num عددی بین ۱ تا تعداد سطرهای table_array وارد کنید. ✓
D. Requires add-in

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 وارد کنید.

9. Is =HLOOKUP volatile?

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

Explanation: HLOOKUP is not volatile.

10. What is the output type of =HLOOKUP?

A. Value
B. Array
C. Logical
D. Mixed ✓

Explanation: Output is “Mixed”.