Share this Page URL

Chapter 8. Building a Worksheet with Exc... > Performing Calculations Using Functi... - Pg. 302

Building a Worksheet with Excel 302 Performing Calculations Using Functions Functions save you time and trouble of creating commonly used or complex equations. Functions are pre-designed formulas that involve one or more values, performing an operation, and returning one or more values. Excel includes hundreds of functions that you can use alone or in combination with other formulas or functions. Functions perform a variety of calculations, from adding, averaging, and counting to more complicated tasks, such as calculating the monthly payment amount of a loan. You can enter a function manually if you know its name and all the required arguments, or you can easily insert a function using Insert Function. Enter a Function 1. Click the cell where you want to enter the function. 2. Type an equal sign (=), type the name of the function, and then type (, an opening parenthesis. For example, to insert the AVERAGE function, type =AVERAGE(. 3.