Lookup & Reference =TOCOL(array, [ignore], [scan_by_column])

Quiz =TOCOL — 10 Questions

10 quiz questions about =TOCOL — test syntax, arguments, examples & errors!

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

← TOCOL ▦ Practice in Playground

Progress — 10 questions 1 of 10

Question 1 of 10 1/10

Which use case fits =TOCOL?

Question 2 of 10 2/10

Which function is NOT related to =TOCOL?

Question 3 of 10 3/10

Which category does =TOCOL belong to?

Question 4 of 10 4/10

How many arguments does =TOCOL have in total?

Question 5 of 10 5/10

In =TOCOL, which is argument #1?

Question 6 of 10 6/10

Which is the correct syntax of =TOCOL?

Question 7 of 10 7/10

Is argument “scan_by_column” required in =TOCOL?

Question 8 of 10 8/10

How many required arguments does =TOCOL have?

Question 9 of 10 9/10

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

Question 10 of 10 10/10

What is the type of argument “scan_by_column” in =TOCOL?

Click a question to see the answer.

1. Which use case fits =TOCOL?

A. Forecasting & Trends
B. Comparation
C. Data Cleaning ✓
D. Financial Calculations

Explanation: Use case “Data Cleaning” fits TOCOL.

2. Which function is NOT related to =TOCOL?

A. TOROW
B. SORT
C. UNIQUE
D. ROUNDUP ✓

Explanation: “ROUNDUP” is not related to TOCOL.

3. Which category does =TOCOL belong to?

A. Compatibility
B. Financial
C. Lookup & Reference ✓
D. Statistical

Explanation: Category is “Lookup & Reference”.

4. How many arguments does =TOCOL have in total?

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

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

5. In =TOCOL, which is argument #1?

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

Explanation: Argument #1 is “array”.

6. Which is the correct syntax of =TOCOL?

A. =TOCOL(array, [ignore], [scan_by_column]) ✓
B. =SORT(array, [ignore], [scan_by_column])
C. TOCOL(array, [ignore], [scan_by_column])
D. =TOCOL(array, [ignore], [scan_by_column], 0)

Explanation: Correct syntax: =TOCOL(array, [ignore], [scan_by_column])

7. Is argument “scan_by_column” required in =TOCOL?

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

Explanation: “scan_by_column” is required.

8. How many required arguments does =TOCOL have?

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

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

9. What is the fix for #VALUE! in =TOCOL?

A. Only works in old versions
B. بررسی کنید ثابت آرایه فقط اعداد صحیح داشته باشد؛ مقادیر اعشاری را گرد یا اصلاح کنید. ✓
C. وقتی آرایه خیلی بزرگ باشد، اکسل خطای #NUM را برمی‌گرداند.
D. Text is always ignored

Explanation: Excel returns a #VALUE! when an array constant contains one or more numbers that are not a whole number. — Fix: بررسی کنید ثابت آرایه فقط اعداد صحیح داشته باشد؛ مقادیر اعشاری را گرد یا اصلاح کنید.

10. What is the type of argument “scan_by_column” in =TOCOL?

A. Reference
B. Array
C. Mixed
D. Range ✓

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