Microsoft Excel — Hard
Key points
- SCAN and REDUCE both utilize LAMBDA functions
- Intermediate results are returned by SCAN, not REDUCE
- REDUCE is suited for final accumulation, not intermediate values
- SCAN's output resembles a running total
Ready to go further?
Related questions