25-08-2017, 09:32 PM
INSERT FUNCTION
INSERT FUNCTION.docx (Size: 26.48 KB / Downloads: 24)
Introduction
A function is a predefined formula that performs calculations using specific values in a particular order. While you may think of formulas as being short mathematical equations, like 2 + 2 or F2 * C2, they can actually be very lengthy and involve complex mathematical calculations.
One of the key benefits of functions is that they can save you time since you do not have to write the formula yourself. For example, you could use an Excel function called Average to quickly find the average of a range of numbers or the Sum function to find the sum of a cell range.
In this lesson, you will learn how to use basic functions such as SUM and AVG, use functions with more than one argument, and how to access the other Excel 2007 functions.
The Parts of a Function:
Each function has a specific order, called syntax, which must be strictly followed for the function to work correctly.
Syntax Order:
1. All functions begin with the = sign.
2. After the = sign define the function name (e.g., Sum).
3. Then there will be an argument. An argument is the cell range or cell references that are enclosed by parentheses. If there is more than one argument, separate each by a comma.