Highlights
- Key operators used in formulas
- Correct syntax (structure) for formulas and function calculations
- Create basic formulas
- Create basic calculations using Excel functions
Formulas can use brackets and operators such as + - * and / to perform calculations. Functions are predefined calculations using key words such as SUM, MAX and AVERAGE. There are over 450 functions in Excel 2016.