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 output type of =HSTACK?

Question 2 of 10 2/10

Which category does =HSTACK belong to?

Question 3 of 10 3/10

In =HSTACK, which is argument #1?

Question 4 of 10 4/10

Which statement about =HSTACK is correct?

Question 5 of 10 5/10

Which is the correct syntax of =HSTACK?

Question 6 of 10 6/10

Is argument “array” required in =HSTACK?

Question 7 of 10 7/10

Which function is related to =HSTACK?

Question 8 of 10 8/10

How many optional arguments does =HSTACK have?

Question 9 of 10 9/10

Which formula is a valid example of =HSTACK?

Question 10 of 10 10/10

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

Click a question to see the answer.

1. What is the output type of =HSTACK?

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

Explanation: Output is “Array”.

2. Which category does =HSTACK belong to?

A. Compatibility
B. Text
C. Lookup & Reference ✓
D. Date & Time

Explanation: Category is “Lookup & Reference”.

3. In =HSTACK, which is argument #1?

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

Explanation: Argument #1 is “array”.

4. Which statement about =HSTACK is correct?

A. HSTACK returns the array formed by appending each of the array arguments in a column-wise fashion. The resulting array will be the following dimensions: ✓
B. Select entire column for best performance
C. Requires add-in
D. Only works in old versions

Explanation: Correct: HSTACK returns the array formed by appending each of the array arguments in a column-wise fashion. The resulting array will be the following dimensions:

5. Which is the correct syntax of =HSTACK?

A. =HSTACK(array1,[array2],...) ✓
B. =HSTACK(array1,[array2],..., 0)
C. =FILTER(array1,[array2],...)
D. HSTACK(array1,[array2],...)

Explanation: Correct syntax: =HSTACK(array1,[array2],...)

6. Is argument “array” required in =HSTACK?

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

Explanation: “array” is required.

7. Which function is related to =HSTACK?

A. ACCRINTM
B. ODDFPRICE
C. MUNIT
D. FILTER ✓

Explanation: “FILTER” is related to HSTACK.

8. How many optional arguments does =HSTACK have?

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

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

9. Which formula is a valid example of =HSTACK?

A. =HSTACK(A2:C3,E2:G3, 0)
B. =FILTER(A2:C3,E2:G3)
C. HSTACK(A2:C3,E2:G3)
D. =HSTACK(A2:C3,E2:G3) ✓

Explanation: Correct example: =HSTACK(A2:C3,E2:G3)

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

A. Requires add-in
B. Select entire column for best performance
C. Only works in old versions
D. Make the ranges the same size or use IFNA ✓

Explanation: If an array has fewer rows than the maximum width of the selected arrays, Excel returns a #N/A error in the additional rows. Use HSTACK inside the IFERROR function to replace #N/A with the value of your choice. — Fix: Make the ranges the same size or use IFNA