Using Formulas and Functions in Your Worksheets

Many of your worksheets will likely need to perform calculations with your data. To perform calculations in Excel, you enter formulas and functions in the appropriate cells in the worksheets. This chapter will explain what formulas and functions are, and what the difference between them is, and then shows you how to use each. Along the way, you will learn how to refer to cells and ranges, meet the calculation operators that Excel supports, and discover how to use them. You will also learn about common problems that occur with formulas and ways to troubleshoot them.