To create a basic spreadsheet, some of the core tasks involve entering formulas and functions. Both formulas and functions are instructions for Excel to do calculations for you, by referring to values in the spreadsheet or within the formula. Introduction to Formulas Entering Formulas Working with Functions Writing Formulas and Functions with the Point Method Introduction to Formulas Excel formulas can include constant numbers or cell references.
Functions are simply preprogrammed formulas.
The following table of formula operators displays which key will perform which operation. The table also indicates the order in which the calculations will be performed. A formula of constants may be appropriate for fixed values, or when you do not want to grab your calculator. Constants should not be used when the value is likely to be changing. If the values may be changing, you should be using a formula referencing a cell.