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

How many optional arguments does =LAMBDA have?

Question 2 of 10 2/10

Which formula is a valid example of =LAMBDA?

Question 3 of 10 3/10

Which is the correct syntax of =LAMBDA?

Question 4 of 10 4/10

In =LAMBDA, which is argument #1?

Question 5 of 10 5/10

Does =LAMBDA return a dynamic array?

Question 6 of 10 6/10

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

Question 7 of 10 7/10

What usually causes #NUM! in =LAMBDA?

Question 8 of 10 8/10

Which statement about =LAMBDA is correct?

Question 9 of 10 9/10

Which category does =LAMBDA belong to?

Question 10 of 10 10/10

Which function is related to =LAMBDA?

Click a question to see the answer.

1. How many optional arguments does =LAMBDA have?

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

Explanation: =LAMBDA has 1 required, 1 optional (2 total).

2. Which formula is a valid example of =LAMBDA?

A. =TOCELSIUS(A2, 0)
B. =BYCOL(A1)
C. TOCELSIUS(A2)
D. =TOCELSIUS(A2) ✓

Explanation: Correct example: =TOCELSIUS(A2)

3. Which is the correct syntax of =LAMBDA?

A. =BYCOL([parameter1, parameter2, …,] calculation)
B. =LAMBDA([parameter1, parameter2, …,] calculation) ✓
C. =LAMBDA([parameter1, parameter2, …,] calculation, 0)
D. LAMBDA([parameter1, parameter2, …,] calculation)

Explanation: Correct syntax: =LAMBDA([parameter1, parameter2, …,] calculation)

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

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

Explanation: Argument #1 is “parameter”.

5. Does =LAMBDA return a dynamic array?

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

Explanation: LAMBDA does not spill.

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

A. شرط خروج بازگشت را بررسی و اصلاح کنید تا حلقه بی‌نهایت ایجاد نشود. ✓
B. Requires add-in
C. Output is always a dynamic array
D. بیش از ۲۵۳ پارامتر وارد شده یا تعداد آرگومان‌های ارسالی به تابع LAMBDA نادرست است.

Explanation: If you call a LAMBDA function from within itself and the call is circular, Excel can return a #NUM! error if there are too many recursive calls. — Fix: شرط خروج بازگشت را بررسی و اصلاح کنید تا حلقه بی‌نهایت ایجاد نشود.

7. What usually causes #NUM! in =LAMBDA?

A. بیش از ۲۵۳ پارامتر وارد شده یا تعداد آرگومان‌های ارسالی به تابع LAMBDA نادرست است.
B. Select entire column for best performance
C. Requires add-in
D. If you call a LAMBDA function from within itself and the call is circular, Excel can return a #NUM! error if there are too many recursive calls. ✓

8. Which statement about =LAMBDA is correct?

A. 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.
B. Requires add-in
C. Select entire column for best performance
D. 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. ✓

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.

9. Which category does =LAMBDA belong to?

A. Logical ✓
B. Cube
C. Lookup & Reference
D. Compatibility

Explanation: Category is “Logical”.

10. Which function is related to =LAMBDA?

A. BYCOL ✓
B. CHISQ.INV
C. LOOKUP
D. XMATCH

Explanation: “BYCOL” is related to LAMBDA.