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 arguments does =LAMBDA have in total?

Question 2 of 10 2/10

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

Question 3 of 10 3/10

What usually causes #VALUE! in =LAMBDA?

Question 4 of 10 4/10

What usually causes #NUM! in =LAMBDA?

Question 5 of 10 5/10

Which function is related to =LAMBDA?

Question 6 of 10 6/10

Which formula is a valid example of =LAMBDA?

Question 7 of 10 7/10

Is argument “calculation” required in =LAMBDA?

Question 8 of 10 8/10

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

Question 9 of 10 9/10

What usually causes #CALC! in =LAMBDA?

Question 10 of 10 10/10

Which category does =LAMBDA belong to?

Click a question to see the answer.

1. How many arguments does =LAMBDA have in total?

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

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

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

A. شرط خروج بازگشت را بررسی و اصلاح کنید تا حلقه بی‌نهایت ایجاد نشود. ✓
B. تابع LAMBDA در سلول تعریف شده اما از داخل همان سلول فراخوانی نشده است.
C. Select entire column for best performance
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: شرط خروج بازگشت را بررسی و اصلاح کنید تا حلقه بی‌نهایت ایجاد نشود.

3. What usually causes #VALUE! in =LAMBDA?

A. If you enter more than 253 parameters, Excel returns a #VALUE! error. If an incorrect number of arguments is passed to a LAMBDA function, Excel returns a #VALUE! error. ✓
B. Only works in old versions
C. تابع LAMBDA در سلول تعریف شده اما از داخل همان سلول فراخوانی نشده است.
D. Text is always ignored

Explanation: If you enter more than 253 parameters, Excel returns a #VALUE! error. If an incorrect number of arguments is passed to a LAMBDA function, Excel returns a #VALUE! error. — Fix: تعداد پارامترها را به ۲۵۳ یا کمتر محدود کنید و مطمئن شوید هنگام فراخوانی دقیقاً به تعداد پارامترهای تعریف‌شده مقدار می‌دهید.

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

A. Volatile and recalculates every time
B. بیش از ۲۵۳ پارامتر وارد شده یا تعداد آرگومان‌های ارسالی به تابع LAMBDA نادرست است.
C. Only works in old versions
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. ✓

5. Which function is related to =LAMBDA?

A. BYCOL ✓
B. QUARTILE.INC
C. FREQUENCY
D. IMSEC

Explanation: “BYCOL” is related to LAMBDA.

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

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

Explanation: Correct example: =TOCELSIUS(A2)

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

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

Explanation: “calculation” is required.

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

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

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

9. What usually causes #CALC! in =LAMBDA?

A. If you create a LAMBDA function in a cell without also calling it from within the cell, Excel returns a #CALC! error. ✓
B. Output is always a dynamic array
C. بیش از ۲۵۳ پارامتر وارد شده یا تعداد آرگومان‌های ارسالی به تابع LAMBDA نادرست است.
D. Volatile and recalculates every time

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

10. Which category does =LAMBDA belong to?

A. Logical ✓
B. Statistical
C. Information
D. Database

Explanation: Category is “Logical”.