Practice - 5 Tasks
Answer the questions below
1fill in blank
easyComplete the formula to create a simple LAMBDA that adds 5 to a number.
Excel
=LAMBDA(x, x [1] 5)
Drag options to blanks, or click blank then click option'
Attempts:
3 left
💡 Hint
Common Mistakes
Using minus (-) instead of plus (+)
Using multiplication (*) or division (/)
✗ Incorrect
The plus sign (+) adds 5 to the input x.
2fill in blank
mediumComplete the formula to create a LAMBDA that multiplies two numbers a and b.
Excel
=LAMBDA(a, b, a [1] b) Drag options to blanks, or click blank then click option'
Attempts:
3 left
💡 Hint
Common Mistakes
Using plus (+) or minus (-) instead of multiplication
Using division (/) by mistake
✗ Incorrect
The asterisk (*) multiplies a and b in Excel formulas.
3fill in blank
hardFix the error in the LAMBDA formula that should subtract b from a.
Excel
=LAMBDA(a, b, a [1] b) Drag options to blanks, or click blank then click option'
Attempts:
3 left
💡 Hint
Common Mistakes
Using plus (+) instead of minus (-)
Using multiplication (*) or division (/)
✗ Incorrect
The minus sign (-) subtracts b from a.
4fill in blank
hardFill the blank to create a LAMBDA that returns TRUE if x is greater than y.
Excel
=LAMBDA(x, y, x [1] y) Drag options to blanks, or click blank then click option'
Attempts:
3 left
💡 Hint
Common Mistakes
Using less than (<) or equals (=) instead of greater than (>)
Using not equal (<>) by mistake
✗ Incorrect
The greater than symbol (>) checks if x is greater than y.
5fill in blank
hardFill the blank to create a LAMBDA that returns the maximum of two numbers a and b.
Excel
=LAMBDA(a, b, IF(a [1] b, a, b)) Drag options to blanks, or click blank then click option'
Attempts:
3 left
💡 Hint
Common Mistakes
Using less than (<) instead of greater than (>)
Using equals (=) or not equal (<>) incorrectly
✗ Incorrect
The IF function checks if a is greater than b using >. If true, it returns a; otherwise, b.