What is the SEQUENCE function in Excel 365 and how is it used?

Question

Microsoft Excel — Hard

What is the SEQUENCE function in Excel 365 and how is it used?

Accepted Answer

The SEQUENCE function in Excel 365 generates a sequence of numbers with a specified start, step, and shape. It's a dynamic array function, making it useful for creating dynamic arrays and serial numbers. This distinguishes it from other functions that simply return a value or sequence dates. The correct answer accurately describes its functionality.