Excel Terminology

Point Mode is activated when editing an expression in Excel and the user points to a range.  [click the link to see a screenshot of the Point Mode flag]

The term "Product of Comparison" is used on this site to describe the substitution of an expression that multiplies the results of two or more comparison operations to apply a logical AND to a set of values.  Since the AND function cannot be used in an array expression, except where all conditions are to be evaluated at once, the use of a product of two or more comparisons enables evaluation cell-by-cell of logical AND conditions thus: (A1:A10>10)*(B1:B10<10)>0 will return TRUE for each of the ten rows only if both conditions are met.