Microsoft Excel 2019 houses an enormous number of functions. Duringthis part of the book, you will learn how to create a formula andinvestigate the difference between a formula and function, and learnabout operators and formula construction, using the correct order ofevaluation. After learning the different methods of constructing aformula, you will be introduced to a number of functions from differentcategories located in the FunctionLibrary.
The following list of topics are covered in this chapter:
- Learning basic formula operations
- Constructing a formula
- Using the Function Library
- Error checking in formulas
- Applying named ranges in a formula
At the end of the chapter, we will highlight common formulaerrors and learn how to use named ranges in a formula.