One of Excel ... worksheet. Formulas can execute basic arithmetic operations, such as addition, subtraction, multiplication, and division, as well as more complex operations. The primary function ...

Because the functions you're about to use produce spilled arrays, and spilled arrays don't work in formatted Excel tables, you need to type the formulas ... in the same worksheet, you can also ...