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

Quiz =TAKE — 15 Questions

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

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

← TAKE ▦ Practice in Playground

Progress — 15 questions 1 of 15

Question 1 of 15 1/15

How many required arguments does =TAKE have?

Question 2 of 15 2/15

How many optional arguments does =TAKE have?

Question 3 of 15 3/15

What is the fix for #CALC! in =TAKE?

Question 4 of 15 4/15

Which is the correct syntax of =TAKE?

Question 5 of 15 5/15

Is argument “array” required in =TAKE?

Question 6 of 15 6/15

Since which Excel version is =TAKE available?

Question 7 of 15 7/15

Which formula is a valid example of =TAKE?

Question 8 of 15 8/15

How many arguments does =TAKE have in total?

Question 9 of 15 9/15

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

Question 10 of 15 10/15

Is argument “columns” required in =TAKE?

Question 11 of 15 11/15

What usually causes #CALC! in =TAKE?

Question 12 of 15 12/15

Is argument “rows” required in =TAKE?

Question 13 of 15 13/15

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

Question 14 of 15 14/15

Which function is NOT related to =TAKE?

Question 15 of 15 15/15

Which use case fits =TAKE?

Click a question to see the answer.

1. How many required arguments does =TAKE have?

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

Explanation: =TAKE has 0 required, 3 optional (3 total).

2. How many optional arguments does =TAKE have?

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

Explanation: =TAKE has 0 required, 3 optional (3 total).

3. What is the fix for #CALC! in =TAKE?

A. Select entire column for best performance
B. Output is always a dynamic array
C. اکسل وقتی آرایه خیلی بزرگ باشد خطای #NUM را برمی‌گرداند.
D. Enter a number other than zero ✓

Explanation: Excel returns a #CALC! error to indicate an empty array when either rows or columns is 0. — Fix: Enter a number other than zero

4. Which is the correct syntax of =TAKE?

A. =SORT(array, rows,[columns])
B. =TAKE(array, rows,[columns], 0)
C. =TAKE(array, rows,[columns]) ✓
D. TAKE(array, rows,[columns])

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

5. Is argument “array” required in =TAKE?

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

Explanation: “array” is optional.

6. Since which Excel version is =TAKE available?

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

Explanation: Version: “Excel 365”.

7. Which formula is a valid example of =TAKE?

A. =SORT(A2:C4,2)
B. =TAKE(A2:C4,2) ✓
C. =TAKE(A2:C4,2, 0)
D. TAKE(A2:C4,2)

Explanation: Correct example: =TAKE(A2:C4,2)

8. How many arguments does =TAKE have in total?

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

Explanation: =TAKE has 0 required, 3 optional (3 total).

9. What is the type of argument “rows” in =TAKE?

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

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

10. Is argument “columns” required in =TAKE?

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

Explanation: “columns” is optional.

11. What usually causes #CALC! in =TAKE?

A. Select entire column for best performance
B. Only works in old versions
C. Volatile and recalculates every time
D. Excel returns a #CALC! error to indicate an empty array when either rows or columns is 0. ✓

Explanation: Excel returns a #CALC! error to indicate an empty array when either rows or columns is 0. — Fix: Enter a number other than zero

12. Is argument “rows” required in =TAKE?

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

Explanation: “rows” is optional.

13. What is the fix for #NUM! in =TAKE?

A. Only works in old versions
B. اکسل خطای #CALC! را برای نشان دادن آرایه خالی برمی‌گرداند، وقتی rows یا columns برابر ۰ باشد.
C. Select entire column for best performance
D. اندازه آرایه را کاهش دهید یا محدوده کوچک‌تری را به تابع بدهید. ✓

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

14. Which function is NOT related to =TAKE?

A. HYPERLINK ✓
B. EXPAND
C. DROP
D. SORT

Explanation: “HYPERLINK” is not related to TAKE.

15. Which use case fits =TAKE?

A. Reshape Tables
B. Data Cleaning
C. Sort, Filter & Dedupe ✓
D. Error Handling

Explanation: Use case “Sort, Filter & Dedupe” fits TAKE.