An array formula (one that spans multiple cells) can do calculations on rows and columns of cells where you might otherwise need to use several formulas.
Structured references make it easier to use formulas with Excel tables by replacing cell references, such as C2:C7, with names for the items in a table.