A formula is a cell entry that calculates data. Functions are ready made formulas that perform specialised calculations automatically.
Using the AutoSum button is the easiest way to add values.
When you copy formulas, Excel automatically changes the relative cell addresses to reflect their new location.
Instead of using cell references in formulas, you can use row and column labels. You type the row name, followed by a space, then the column name. To use this feature you first select the Accept label in formulas option.
Formulas automatically update results when values change because they refer to cell references, not the values they contain.
Excel identifies errors in formulas and helps you to correct them.