ms excel 2013 tutorial in telugu

A function is a pre-defined formula that performs a particular type of calculation. The SUM function is one of the most commonly used functions in Excel. MIN, MAX, and AVERAGE are other simple functions used frequently. These functions only works if there are numbers in the specific cells.

How To Use the SUM function in telugu:

• Select the cell where you want the result to appear
• Type =SUM.
• Enter a parenthesis.
• Select the range of cells you want add together OR type in the cell references.
• Enter another parenthesis
• Press Enter.

How To Use the AVERAGE function In Telugu :

You can use the AVERAGE function to calculate the average of a list of numbers.

• Select the cell in which you want to result to appear.
• Type =AVERAGE
• Enter a parenthesis.
• Select the range of cells you want average OR type in the cell references.
• Enter another parenthesis
• Press Enter.

How To Use the MIN function Tutorial in telugu:

You can use the MIN or minimum function to calculate the smallest value in a list of numbers.

• Select the cell in which you want to result to appear.
• Type =MIN
• Enter a parenthesis.
• Select the range of cells you want average OR type in the cell references.
• Enter another parenthesis.
• Press Enter.

How To Use the MAX function Tutorial in telugu:

You can use the MAX or maximum function to calculate the largest value in a list of numbers.

• Select the cell in which you want to result to appear.
• Type =MAX
• Enter a parenthesis.
• Select the range of cells you want average OR type in the cell references.
• Enter another parenthesis.
• Press Enter.

How To Use AUTOSUM Tutorial in telugu :

You can use AUTOSUM to automatically enter the SUM function and add a list of numbers. When you click on the button, Excel will guess the range of cells you want to add. You are able to change that range.

1. Select the cell in which you want to result to appear.
2. Office 2013 : Click the AUTOSUM button in Toolbar (·). Office 2013: On the Home tab, in the Editing group, click on the SUM icon.
3. Observe the formula bar. The range that Excel guessed is displayed.
4. If the guess is correct, press Enter. You are done.
5. If the guess is incorrect, select the range of cells you want to use.
6. Press Enter.