If you named a cell or a range of cells, you can use the name in formulas to refer to values in the range. Excel actually uses the values for the particular column. You can refer to the intersection of two ranges using each range's name separated by a space. Functions Excel has lots of built-in functions that perform many different types of calculations. A function can be the only element in a formula or part of a larger formula.
Arguments can be numbers, text, cell references, range names or even formulas containing functions.
The AutoSum button on the Standard toolbar is a shortcut for creating a formula that totals values in a range of cells using the Excel SUM function. For example, look at the Blue Sky Airline Sales Report. In proposing a sum range, Excel assumes that you are adding values down a column or across a row. If the proposed range is incorrect, just select the right range by clicking and dragging and then press Enter . In Step 1 of the Paste Function , select the function by clicking on its name.