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

Quiz =LAMBDA — 15 Questions

15 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 — 15 questions 1 of 15

Question 1 of 15 1/15

What usually causes #CALC! in =LAMBDA?

Question 2 of 15 2/15

How many optional arguments does =LAMBDA have?

Question 3 of 15 3/15

Is argument “parameter” required in =LAMBDA?

Question 4 of 15 4/15

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

Question 5 of 15 5/15

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

Question 6 of 15 6/15

Which formula is a valid example of =LAMBDA?

Question 7 of 15 7/15

Is =LAMBDA volatile?

Question 8 of 15 8/15

Which is the correct syntax of =LAMBDA?

Question 9 of 15 9/15

Which statement about =LAMBDA is correct?

Question 10 of 15 10/15

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

Question 11 of 15 11/15

Which function is NOT related to =LAMBDA?

Question 12 of 15 12/15

In =LAMBDA, which is argument #1?

Question 13 of 15 13/15

Which category does =LAMBDA belong to?

Question 14 of 15 14/15

How many required arguments does =LAMBDA have?

Question 15 of 15 15/15

How many arguments does =LAMBDA have in total?

Click a question to see the answer.

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

A. Output is always a dynamic array
B. If you create a LAMBDA function in a cell without also calling it from within the cell, Excel returns a #CALC! error. ✓
C. Text is always ignored
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

2. How many optional arguments does =LAMBDA have?

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

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

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

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

Explanation: “parameter” is optional.

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

A. تابع LAMBDA در سلول تعریف شده اما از داخل همان سلول فراخوانی نشده است.
B. بیش از ۲۵۳ پارامتر وارد شده یا تعداد آرگومان‌های ارسالی به تابع LAMBDA نادرست است.
C. Volatile and recalculates every time
D. شرط خروج بازگشت را بررسی و اصلاح کنید تا حلقه بی‌نهایت ایجاد نشود. ✓

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: شرط خروج بازگشت را بررسی و اصلاح کنید تا حلقه بی‌نهایت ایجاد نشود.

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

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

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

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

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

Explanation: Correct example: =TOCELSIUS(A2)

7. Is =LAMBDA volatile?

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

Explanation: LAMBDA is not volatile.

8. Which is the correct syntax of =LAMBDA?

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

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

9. 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.

10. What is the type of argument “parameter” in =LAMBDA?

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

Explanation: Type of “parameter” is “Text”.

11. Which function is NOT related to =LAMBDA?

A. BYROW
B. BYCOL
C. COUNTA ✓
D. ISOMITTED

Explanation: “COUNTA” is not related to LAMBDA.

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

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

Explanation: Argument #1 is “parameter”.

13. Which category does =LAMBDA belong to?

A. Math & Trig
B. Web
C. Text
D. Logical ✓

Explanation: Category is “Logical”.

14. How many required arguments does =LAMBDA have?

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

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

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

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

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