Excel is also a wonderful tool for introducing the concept of sequences and series. It is a very useful teaching tool for mathematics at this level even if it was not intended to be used as such. And, since most personal computers now have Excel or some other spread-sheet software, such as Lotus 1-2-3, installed,... Jan 25, 2012 · In XLM if you create a macro and define it as a function you can call it directly from a worksheet cell. In both these cases a name is defined and pointed to your code, you do it yourself in XLM, Excel does it automatically for you in VBA (and it overwrites any existing XLM/XLL names called the same thing). The series formula is an Excel formula like any other. You can click in the formula bar, and edit the formula manually, to change aspects of the charted series. Select part of the formula, type in the text you want there instead, and press Enter to apply the changes (or sometimes to cause an error!). Using averages within Excel is easy, assuming you understand the syntax for the command and you are aware of how to enter formulas into cells in Excel. To use a formula in Excel, make sure that the formula bar is able to be written in by going in to the VIEW button on the toolbar in Microsoft Excel. Function (--) convert a return value of “TRUE” into 1 and a return value of “FALSE” into 0. It does not not effect the result.It is generally used with logical functions to convert Boolean type result to 0 or 1 form. It is also used with SUMPRODUCT formula in excel as it neglects non -numeric values. Dec 19, 2007 · It refers to a formula that is absolute as opposed to relative. Meaning that when you autofill a formula or function down, it doesn't flip over to be relative to the row or column but stays absolute to that one cell.