Most of the standard math, business, statistical, and scientific calculations are implemented in terms of functions. While the documentation generally refers to functions in all caps, their use is not actually case sensitive. Where a function takes multiple arguments such as the SUM example, the number of arguments effectively unlimited. Names Names help to simplify complex formulae. A name is assinged to a formula which will be evaluated when it is referred to in another formula.
Names are particularly useful for labeling cell ranges.
Names are defined using the Insert Name dialog. This allows manipulation of all the names in the related workbook. A name is restrained from taking that of a function, since this would cause confusion. It is periodically useful or necessary to have an expression return a matrix rather than a single value. The first example most people think of are matrix operations such as multiplication, transpose, and inverse.