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

Posted in: Excel