Array formula in Excel
An array formula is a formula that returns one or many results from a range, calculated as a set rather than by copying the formula down each row.
Legacy array formulas had to be entered with Ctrl+Shift+Enter and are marked by braces in the formula bar; Excel’s dynamic arrays removed that requirement.
Reviews should check whether an array covers the whole block it was written for, because an array copied to the wrong range silently misses rows.
More definitions
Twenty-five terms a reviewer needs, each in one sentence followed by the context that matters.