What is the REDUCE function in Excel 365 and what problem does it solve?

Question

Microsoft Excel — Hard

What is the REDUCE function in Excel 365 and what problem does it solve?

Accepted Answer

The REDUCE function in Excel 365 applies a custom LAMBDA function to each element of an array, accumulating results. This solves complex array problems like running totals and string concatenation. Option B is correct as it accurately describes this functionality. Options A, C, and D are incorrect as they misrepresent the function's purpose.