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

Quiz =HSTACK — 15 Questions

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

Question 1 of 15 1/15

Does =HSTACK return a dynamic array?

Question 2 of 15 2/15

Is =HSTACK volatile?

Question 3 of 15 3/15

Since which Excel version is =HSTACK available?

Question 4 of 15 4/15

How many optional arguments does =HSTACK have?

Question 5 of 15 5/15

Which formula is a valid example of =HSTACK?

Question 6 of 15 6/15

How many required arguments does =HSTACK have?

Question 7 of 15 7/15

Which category does =HSTACK belong to?

Question 8 of 15 8/15

Which use case fits =HSTACK?

Question 9 of 15 9/15

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

Question 10 of 15 10/15

Which function is related to =HSTACK?

Question 11 of 15 11/15

How many arguments does =HSTACK have in total?

Question 12 of 15 12/15

Which is the correct syntax of =HSTACK?

Question 13 of 15 13/15

Is argument “array” required in =HSTACK?

Question 14 of 15 14/15

Which statement about =HSTACK is correct?

Question 15 of 15 15/15

What is the output type of =HSTACK?

Click a question to see the answer.

1. Does =HSTACK return a dynamic array?

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

Explanation: HSTACK spills as a dynamic array.

2. Is =HSTACK volatile?

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

Explanation: HSTACK is not volatile.

3. Since which Excel version is =HSTACK available?

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

Explanation: Version: “Excel 365”.

4. How many optional arguments does =HSTACK have?

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

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

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

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

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

6. How many required arguments does =HSTACK have?

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

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

7. Which category does =HSTACK belong to?

A. Lookup & Reference ✓
B. Math & Trig
C. Date & Time
D. Engineering

Explanation: Category is “Lookup & Reference”.

8. Which use case fits =HSTACK?

A. Date & Time Calculations
B. Reshape Tables ✓
C. Error Handling
D. Workdays & Due Dates

Explanation: Use case “Reshape Tables” fits HSTACK.

9. What is the type of argument “array” in =HSTACK?

A. Date
B. Range ✓
C. Number
D. Array

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

10. Which function is related to =HSTACK?

A. CHIINV
B. T.INV
C. ACOTH
D. FILTER ✓

Explanation: “FILTER” is related to HSTACK.

11. How many arguments does =HSTACK have in total?

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

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

12. Which is the correct syntax of =HSTACK?

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

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

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

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

Explanation: “array” is required.

14. Which statement about =HSTACK is correct?

A. Columns The combined count of all the columns from each of the array arguments.
B. 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: ✓
C. Only works in old versions
D. Rows The maximum of the row count from each of the array arguments.

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:

15. What is the output type of =HSTACK?

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

Explanation: Output is “Array”.