Logical =SCAN ([initial_value], array, lambda(accumulator, value, body))

Quiz =SCAN — 15 Questions

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

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

← SCAN ▦ Practice in Playground

Progress — 15 questions 1 of 15

Question 1 of 15 1/15

Is argument “array” required in =SCAN?

Question 2 of 15 2/15

Since which Excel version is =SCAN available?

Question 3 of 15 3/15

Is argument “lambda” required in =SCAN?

Question 4 of 15 4/15

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

Question 5 of 15 5/15

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

Question 6 of 15 6/15

Which use case fits =SCAN?

Question 7 of 15 7/15

How many optional arguments does =SCAN have?

Question 8 of 15 8/15

What is the type of argument “lambda” in =SCAN?

Question 9 of 15 9/15

Which function is NOT related to =SCAN?

Question 10 of 15 10/15

How many arguments does =SCAN have in total?

Question 11 of 15 11/15

Which statement about =SCAN is correct?

Question 12 of 15 12/15

What is the type of argument “initial_value” in =SCAN?

Question 13 of 15 13/15

Which category does =SCAN belong to?

Question 14 of 15 14/15

Is argument “initial_value” required in =SCAN?

Question 15 of 15 15/15

In =SCAN, which is argument #3?

Click a question to see the answer.

1. Is argument “array” required in =SCAN?

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

Explanation: “array” is optional.

2. Since which Excel version is =SCAN available?

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

Explanation: Version: “Excel 365”.

3. Is argument “lambda” required in =SCAN?

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

Explanation: “lambda” is optional.

4. What is the type of argument “array” in =SCAN?

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

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

5. What is the fix for #VALUE! in =SCAN?

A. Volatile and recalculates every time
B. Text is always ignored
C. Check the number of LAMBDA parameters ✓
D. Requires add-in

Explanation: Providing an invalid LAMBDA function or an incorrect number of parameters returns a #VALUE! error called "Incorrect Parameters". — Fix: Check the number of LAMBDA parameters

6. Which use case fits =SCAN?

A. Data Cleaning
B. Error Handling
C. Dynamic Ranges & Dashboards
D. Advanced Formulas ✓

Explanation: Use case “Advanced Formulas” fits SCAN.

7. How many optional arguments does =SCAN have?

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

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

8. What is the type of argument “lambda” in =SCAN?

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

Explanation: Type of “lambda” is “Any type”.

9. Which function is NOT related to =SCAN?

A. LOG ✓
B. MAP
C. REDUCE
D. LAMBDA

Explanation: “LOG” is not related to SCAN.

10. How many arguments does =SCAN have in total?

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

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

11. Which statement about =SCAN is correct?

A. Text is always ignored
B. Select entire column for best performance
C. Requires add-in
D. Use the initial_value argument to set the starting value for the accumulator parameter. If you are working with text, set the initial value to "". ✓

Explanation: Correct: Use the initial_value argument to set the starting value for the accumulator parameter. If you are working with text, set the initial value to "".

12. What is the type of argument “initial_value” in =SCAN?

A. Date
B. Any type ✓
C. Number
D. Value

Explanation: Type of “initial_value” is “Any type”.

13. Which category does =SCAN belong to?

A. Math & Trig
B. Logical ✓
C. Database
D. Financial

Explanation: Category is “Logical”.

14. Is argument “initial_value” required in =SCAN?

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

Explanation: “initial_value” is optional.

15. In =SCAN, which is argument #3?

A. initial_value
B. value
C. lambda ✓
D. range

Explanation: Argument #3 is “lambda”.