Functions perform specific calculations in a particular order based on the specified values, called arguments, or parameters.įor example, instead of specifying each value to be summed like in the above formula, you can use the SUM function to add up a range of cells: =SUM(A2:A4) Function is a predefined formula already available in Excel.Formula is an expression that calculates values in a cell or in a range of cells.įor example, =A2+A2+A3+A4 is a formula that adds up the values in cells A2 through A4.
So, what do we call an Excel formula and Excel function? Before providing the basic Excel formulas list, let's define the key terms just to make sure we are on the same page.
