Lookup & Reference =HSTACK(array1, [array2], ...)

Quiz =HSTACK — 10 Questions

10 quiz questions about =HSTACK — test syntax, arguments, examples & errors!

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

← HSTACK ▦ Practice in Playground

Progress — 10 questions 1 of 10

Question 1 of 10 1/10

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

Question 2 of 10 2/10

Is =HSTACK volatile?

Question 3 of 10 3/10

What is the type of argument “array2” in =HSTACK?

Question 4 of 10 4/10

Is argument “array2” required in =HSTACK?

Question 5 of 10 5/10

How many required arguments does =HSTACK have?

Question 6 of 10 6/10

How many optional arguments does =HSTACK have?

Question 7 of 10 7/10

Which category does =HSTACK belong to?

Question 8 of 10 8/10

What is the output type of =HSTACK?

Question 9 of 10 9/10

What usually causes #N/A in =HSTACK?

Question 10 of 10 10/10

Since which Excel version is =HSTACK available?

Click a question to see the answer.

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

A. Make the ranges the same size or use IFNA ✓
B. Volatile and recalculates every time
C. Text is always ignored
D. Select entire column for best performance

Explanation: The ranges are not the same height, and the gap of the shorter range is filled with this error — Fix: Make the ranges the same size or use IFNA

2. Is =HSTACK volatile?

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

Explanation: HSTACK is not volatile.

3. What is the type of argument “array2” in =HSTACK?

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

Explanation: Type of “array2” is “Array”.

4. Is argument “array2” required in =HSTACK?

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

Explanation: “array2” is optional.

5. How many required arguments does =HSTACK have?

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

Explanation: =HSTACK has 1 required, 1 optional (2 total).

6. How many optional arguments does =HSTACK have?

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

Explanation: =HSTACK has 1 required, 1 optional (2 total).

7. Which category does =HSTACK belong to?

A. Lookup & Reference ✓
B. Database
C. Statistical
D. Information

Explanation: Category is “Lookup & Reference”.

8. What is the output type of =HSTACK?

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

Explanation: Output is “Array”.

9. What usually causes #N/A in =HSTACK?

A. Text is always ignored
B. Select entire column for best performance
C. The ranges are not the same height, and the gap of the shorter range is filled with this error ✓
D. Volatile and recalculates every time

Explanation: The ranges are not the same height, and the gap of the shorter range is filled with this error — Fix: Make the ranges the same size or use IFNA

10. Since which Excel version is =HSTACK available?

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

Explanation: Version: “Excel 365”.