Lookup & Reference =Expand(array, rows, [columns], [pad_with])

Quiz =EXPAND — 15 Questions

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

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

← EXPAND ▦ Practice in Playground

Progress — 15 questions 1 of 15

Question 1 of 15 1/15

Which formula is a valid example of =EXPAND?

Question 2 of 15 2/15

Is argument “rows” required in =EXPAND?

Question 3 of 15 3/15

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

Question 4 of 15 4/15

What usually causes #N/A in =EXPAND?

Question 5 of 15 5/15

What is the output type of =EXPAND?

Question 6 of 15 6/15

Is =EXPAND volatile?

Question 7 of 15 7/15

What usually causes #NUM! in =EXPAND?

Question 8 of 15 8/15

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

Question 9 of 15 9/15

Since which Excel version is =EXPAND available?

Question 10 of 15 10/15

What usually causes #VALUE! in =EXPAND?

Question 11 of 15 11/15

Which statement about =EXPAND is correct?

Question 12 of 15 12/15

What is the fix for #NUM! in =EXPAND?

Question 13 of 15 13/15

Which use case fits =EXPAND?

Question 14 of 15 14/15

Which is the correct syntax of =EXPAND?

Question 15 of 15 15/15

In =EXPAND, which is argument #2?

Click a question to see the answer.

1. Which formula is a valid example of =EXPAND?

A. EXPAND(A2:B3,3,3)
B. =HSTACK(A2:B3,3,3)
C. =EXPAND(A2:B3,3,3, 0)
D. =EXPAND(A2:B3,3,3) ✓

Explanation: Correct example: =EXPAND(A2:B3,3,3)

2. Is argument “rows” required in =EXPAND?

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

Explanation: “rows” is optional.

3. What is the type of argument “array” in =EXPAND?

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

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

4. What usually causes #N/A in =EXPAND?

A. آرگومان rows یا columns کوچک‌تر از تعداد سطرها یا ستون‌های آرایه اصلی است.
B. آرایه خیلی بزرگ است.
C. The default is #N/A. Excel returns a #N/A error in padded cells if pad_with is not provided. ✓
D. Select entire column for best performance

Explanation: The default is #N/A. Excel returns a #N/A error in padded cells if pad_with is not provided. — Fix: اگر نمی‌خواهید ‎#N/A ببینید، برای pad_with مقدار دلخواه مانند "-" یا ۰ وارد کنید.

5. What is the output type of =EXPAND?

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

Explanation: Output is “Array”.

6. Is =EXPAND volatile?

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

Explanation: EXPAND is not volatile.

7. What usually causes #NUM! in =EXPAND?

A. Excel returns a #NUM when array is too large. ✓
B. Only works in old versions
C. Volatile and recalculates every time
D. Output is always a dynamic array

Explanation: Excel returns a #NUM when array is too large. — Fix: ابعاد درخواستی را کاهش دهید یا آرایه مبدأ را کوچک‌تر کنید.

8. What is the fix for #N/A in =EXPAND?

A. آرگومان rows یا columns کوچک‌تر از تعداد سطرها یا ستون‌های آرایه اصلی است.
B. آرایه خیلی بزرگ است.
C. Requires add-in
D. اگر نمی‌خواهید ‎#N/A ببینید، برای pad_with مقدار دلخواه مانند "-" یا ۰ وارد کنید. ✓

9. Since which Excel version is =EXPAND available?

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

Explanation: Version: “Excel 365”.

10. What usually causes #VALUE! in =EXPAND?

A. Select entire column for best performance
B. Output is always a dynamic array
C. Only works in old versions
D. Excel returns a #VALUE error when the rows or columns argument is less than the rows or columns in the array argument. ✓

Explanation: Excel returns a #VALUE error when the rows or columns argument is less than the rows or columns in the array argument. — Fix: Use a number equal to or greater than the current dimensions

11. Which statement about =EXPAND is correct?

A. Requires add-in
B. Text is always ignored
C. Select entire column for best performance
D. If rows isn't provided or is empty, the default value is the number of rows in the array argument. ✓

Explanation: Correct: If rows isn't provided or is empty, the default value is the number of rows in the array argument.

12. What is the fix for #NUM! in =EXPAND?

A. Text is always ignored
B. Volatile and recalculates every time
C. ابعاد درخواستی را کاهش دهید یا آرایه مبدأ را کوچک‌تر کنید. ✓
D. آرگومان rows یا columns کوچک‌تر از تعداد سطرها یا ستون‌های آرایه اصلی است.

Explanation: Excel returns a #NUM when array is too large. — Fix: ابعاد درخواستی را کاهش دهید یا آرایه مبدأ را کوچک‌تر کنید.

13. Which use case fits =EXPAND?

A. Ranking & Top N
B. Securities & Bonds
C. Reshape Tables ✓
D. Text Manipulation

Explanation: Use case “Reshape Tables” fits EXPAND.

14. Which is the correct syntax of =EXPAND?

A. =Expand(array, rows, [columns], [pad_with]) ✓
B. =Expand(array, rows, [columns], [pad_with], 0)
C. =HSTACK(array, rows, [columns], [pad_with])
D. Expand(array, rows, [columns], [pad_with])

Explanation: Correct syntax: =Expand(array, rows, [columns], [pad_with])

15. In =EXPAND, which is argument #2?

A. rows ✓
B. criteria
C. pad_with
D. lookup_value

Explanation: Argument #2 is “rows”.