All language subtitles for 2. Excel 2016 Functions

Functions in excel are pre-built formulas Excel has a large number of built in functions just as you

type operators in formulas.

You provide arguments to functions.

The general form of function is equal to function name and arguments in the bracket.

In this worksheet let us find the total sales for the year.

To add the total sales in Cell C 14 click Cell C 14 click the insert function tool right next to the

formula but excel displays the insert function dialog box into insert function dialog box.

You can search for a particular function.

You can also select a category of functions and then select the desired function from the list.

Click the category selection dropdown list since we need a mathematical some function.

Select math and trigonometric category.

Scroll down the list of functions and selecting some function in the function selection list.

Then you select the function Excel displays the syntax and description of the function at the bottom

of the insert function dialog box.

Notice that in Cell C 14 the SUM function is inserted for cells C 2 to C 13.

The default selection for the sum function is the continuous range of cells above or to the left of

the cell where you insert the sum function.

And sure that the range of cells inside the brackets is correct.

You can also see the function syntax in the formula about kick.

Okay Excel adds up the values in Cell C 14.

We can now see the total sales for the year.

You can also use the formula step in the ribbon to quickly access excel functions.

Select the category to browse its functions.

Every new version of Excel introduces some new functions depending upon the version of Excel you are

using.

You will see the list of available functions when you hover the mouse over each function Excel displays

up to click the function to get detailed information about it.

You can also use auto sum to do fine.

Total sales volume for that year.

Click Sell be 14 click the auto sum tool a market outlines the columns B to to be 13.

Notice that the default selection for the sum function is the continuous range of cells above.

Ensure that the range of cells inside the brackets is correct and press enter Excel adds up the values

for total sales value.

If you click the arrow in the auto sum tool you can access other mathematical functions to find the

sum of values.

You can also type equal to sum in the cell Excel displays a list of functions that start with sum double

click on some Excel hides the list of functions and displays the format of some.

Click the first cell with the value you want to add hold down the left mouse button and drag the mouse

to select the range of cells with the values type the closing bracket and press enter.

Excel sums up the values from the selected range Excel does not have a function to subtract numbers

you need to create a formula with the minus sign between the numbers or cells.

You need to subtract.

Let us find out the difference between the sales of January and February type.

Equal to select sales for the month of January.

Type minus sign and then select sales for the month of February.

Press enter it then subtract the sales for the two months.