The classic interview warm-up, in spreadsheet form. For each number in column A, return:
"FizzBuzz" if divisible by both 3 and 5 (i.e., divisible by 15)
"Fizz" if divisible by 3 only
"Buzz" if divisible by 5 only
- the number itself otherwise
Your task:
- Define a single-parameter LAMBDA that implements the FizzBuzz rule and invoke it inline on each row's value.
- Drag-fill from B2 → B11.
The check ordering matters: test the most-specific case first (MOD(n, 15) = 0), otherwise a number divisible by 15 returns "Fizz" because the MOD(n, 3) = 0 branch fires first.
Graded cells: B2 (1 → 1), B5 (9 → Fizz), B11 (50 → Buzz).
Open this problem on a desktop to attempt it.