You're learning LAMBDA, Excel's anonymous-function builder. The simplest possible LAMBDA: a function that doubles a single input.
Columns A–B contain 10 numbers and an empty Doubled column. Your task:
- Define a LAMBDA
x → x*2 and invoke it inline on each row's Number. The pattern is =LAMBDA(x, x*2)(A2) — the second pair of parentheses calls the just-defined function with A2 as the argument.
- Drag-fill from B2 → B11.
In production you'd also use LAMBDA with the Name Manager to publish a reusable =DOUBLE(x) everywhere in the workbook — but the inline pattern is the right starting point for learning.
Graded cells: B2 (5 → 10), B7 (−3 → −6), B10 (50 → 100).
Open this problem on a desktop to attempt it.