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

Quiz =EXPAND — 10 Questions

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

Question 1 of 10 1/10

Is =EXPAND volatile?

Question 2 of 10 2/10

Is argument “array” required in =EXPAND?

Question 3 of 10 3/10

Which statement about =EXPAND is correct?

Question 4 of 10 4/10

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

Question 5 of 10 5/10

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

Question 6 of 10 6/10

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

Question 7 of 10 7/10

In =EXPAND, which is argument #1?

Question 8 of 10 8/10

What usually causes #VALUE! in =EXPAND?

Question 9 of 10 9/10

How many optional arguments does =EXPAND have?

Question 10 of 10 10/10

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

Click a question to see the answer.

1. Is =EXPAND volatile?

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

Explanation: EXPAND is not volatile.

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

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

Explanation: “array” is optional.

3. Which statement about =EXPAND is correct?

A. Select entire column for best performance
B. If columns isn't provided or is empty, the default value is the number of columns in the array argument.
C. Requires add-in
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.

4. What is the fix for #VALUE! in =EXPAND?

A. Use a number equal to or greater than the current dimensions ✓
B. Volatile and recalculates every time
C. Output is always a dynamic array
D. Requires add-in

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

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

A. Logical
B. Any type
C. Date
D. Array ✓

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

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

A. ابعاد درخواستی را کاهش دهید یا آرایه مبدأ را کوچک‌تر کنید. ✓
B. مقدار پیش‌فرض پرکننده ‎#N/A است و اگر pad_with ارائه نشود، سلول‌های پرشده خطای ‎#N/A برمی‌گردانند.
C. Only works in old versions
D. آرگومان rows یا columns کوچک‌تر از تعداد سطرها یا ستون‌های آرایه اصلی است.

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

7. In =EXPAND, which is argument #1?

A. array ✓
B. pad_with
C. rows
D. range

Explanation: Argument #1 is “array”.

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

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

9. How many optional arguments does =EXPAND have?

A. 4 ✓
B. 3
C. 5
D. 6

Explanation: =EXPAND has 0 required, 4 optional (4 total).

10. What is the type of argument “rows” in =EXPAND?

A. Any type
B. Number ✓
C. Mixed
D. Reference

Explanation: Type of “rows” is “Number”.