What is a Table array in Excel?

An array is a list of related values of the same data type. Excel can deal with arrays and actually has some specialised array formulas. You can do things like in a single formula multiply corresponding values in two separate lists and total the result. You would type in the formula as normal:

=SUM(C10:C20*D10:D20)

Then press the Ctrl, shift and Enter keys, rather than just the Enter key. The formula will then appear with the braces around it to indicate that it is an array formula as follows:

{=SUM(C10:C20*D10:D20)}

That formula will multiply what is in C10 by D10, C11 by D11 and so on up to multiplying C20 by D20, and then total all the results in one single formula.