Using Functions in Ms Excel

          Functions are predefined formulas that perform calculations by using specific values, called arguments, in a particular order, or structure. Functions can be used to perform simple or complex calculations.
a. The structure of a function
The structure of a function begins with an equal sign (=), followed by the function name, an opening parenthesis, the arguments for the function separated by commas, and a closing parenthesis.
b. Function name.
For a list of available functions, click a cell and press SHIFT+F3
c. Arguments.
Arguments can be numbers, text, logical values such as TRUE or FALSE.
d. Argument tool tip.
A tool tip with the syntax and arguments appears when you type the function. For example, type =ROUND (and the tool tip appears. Tool tips appear only for built-in functions..
e. Create a Formula
          The formulas perform calculations on values in your worksheet. A formula starts with an equal sign (=). For example, the following formula multiplies 2 by 3 and then adds 5 to the result. =5+2*3


Post a Comment