Logical =LAMBDA([parameter1, parameter2, …,] calculation)

Quiz =LAMBDA — 10 Questions

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

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

← LAMBDA ▦ Practice in Playground

Progress — 10 questions 1 of 10

Question 1 of 10 1/10

Which statement about =LAMBDA is correct?

Question 2 of 10 2/10

What is the type of argument “calculation” in =LAMBDA?

Question 3 of 10 3/10

What is the output type of =LAMBDA?

Question 4 of 10 4/10

Since which Excel version is =LAMBDA available?

Question 5 of 10 5/10

Is argument “calculation” required in =LAMBDA?

Question 6 of 10 6/10

In =LAMBDA, which is argument #2?

Question 7 of 10 7/10

Is argument “parameter” required in =LAMBDA?

Question 8 of 10 8/10

Is =LAMBDA volatile?

Question 9 of 10 9/10

In =LAMBDA, which is argument #1?

Question 10 of 10 10/10

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

Click a question to see the answer.

1. Which statement about =LAMBDA is correct?

A. Output is always a dynamic array
B. Lambda names and parameters follow the Excel syntax rules for names, with one exception: don't use a period (.) in a parameter name. For more information, see Names in formulas. ✓
C. Make sure you follow best practices when creating a LAMBDA function as you do with any native Excel formula, such as passing of the correct number and type of arguments, matching open and close parentheses, and entering numbers as unformatted . Also, when you use the Evaluate command, Excel immediately returns the result of the LAMBDA function and you can't step into it. For more information, see Detect errors in formulas.
D. Select entire column for best performance

Explanation: Correct: Lambda names and parameters follow the Excel syntax rules for names, with one exception: don't use a period (.) in a parameter name. For more information, see Names in formulas.

2. What is the type of argument “calculation” in =LAMBDA?

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

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

3. What is the output type of =LAMBDA?

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

Explanation: Output is “Mixed”.

4. Since which Excel version is =LAMBDA available?

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

Explanation: Version: “Excel 365”.

5. Is argument “calculation” required in =LAMBDA?

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

Explanation: “calculation” is required.

6. In =LAMBDA, which is argument #2?

A. value
B. calculation ✓
C. range
D. parameter

Explanation: Argument #2 is “calculation”.

7. Is argument “parameter” required in =LAMBDA?

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

Explanation: “parameter” is optional.

8. Is =LAMBDA volatile?

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

Explanation: LAMBDA is not volatile.

9. In =LAMBDA, which is argument #1?

A. value
B. parameter ✓
C. range
D. criteria

Explanation: Argument #1 is “parameter”.

10. What is the fix for #CALC! in =LAMBDA?

A. Add the inputs in parentheses after the formula ✓
B. Requires add-in
C. بیش از ۲۵۳ پارامتر وارد شده یا تعداد آرگومان‌های ارسالی به تابع LAMBDA نادرست است.
D. Only works in old versions

Explanation: If you create a LAMBDA function in a cell without also calling it from within the cell, Excel returns a #CALC! error. — Fix: Add the inputs in parentheses after the formula