For example, instead of manually calculating an average with a formula like =(A1+A2+A3)/3, you can use the AVERAGE function (=AVERAGE(A1:A3)) function to accomplish the task more efficiently.

The key difference between formulas and functions is that anyone can create a formula, whereas functions are predefined by Microsoft's programmers. Excel Formulas Excel's formulas enable you to ...