An array is a collection of items. In Excel, items that comprise an array can be individually or collectively addressed in simple mathematical terms. Here is some basic array terminology you should know:

• An array formula acts on two or more sets of values, called array arguments, to return either a single result or multiple results.
  
  
• An array range is a block of cells that share a common array formula.
  
  
• An array constant is a specially organized list of constant values that you can use as arguments in your array formulas.