Ms excel 2013 tutorial in telugu Part 7 - Computer Telugu Video Tutorials BUY TELUGU TUTORIAL DVD'S:::: SEO::3500/-,DCA(DOS,WINDOWS,WORD,EXCEL,POWER POINT, MS ACCESS, INTERNET CONCEPTS)::499/-,DTP(PHOTOSHOP,PAGEMAKER, CORELDRAW,TELUGU TYPING)::999/-,C::700,C++::900,TALLY ERP 9:: 999,ORACLE:999/-,CORE JAVA::1000/-,SPOKEN HINDI:500,HTML::500/-,AUTOCAD::2500/-,DCA+DTP::1000/-,DCA+TALLY::1000,C,C++,JAVA::1500, ALL COURSES(DCA,DTP,C,C++,JAVA,ORACLE,TALLY,HTML,SPOKEN HINDI,AUTOCAD):: 3500/-..CONTACT : SYED HAFIZ, SHOPPING COMPLEX,8INCLINE COLONY,GODAVARI KHANI,KARIMNAGAR, TELANGANA,CELL:9395306603,EMAIL:COOLHAFI7@GMAIL.COM.
Home / Ms Office / Ms Excel 2013 / Ms excel 2013 tutorial in telugu Part 7

Ms excel 2013 tutorial in telugu Part 7

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.

 

About timecomputers

Check Also

microsoft excel training in telugu

Microsoft excel training in telugu Part 4

Microsoft excel training in telugu   In Microsoft Excel 2013 in telugu Number formats allow …

Leave a Reply

Your email address will not be published. Required fields are marked *

STATE BANK OF HYDERABAD, ***NAME:Hafiz SD, BRANCH:JALLARAM, ACCOUNT.NO:62041435239, IFSC CODE:SBHY0020609,****, ANDRA BANK*** NAME:SYED HAFEEZ BABA, BRANCH:8INCLINE COLONY, ACCOUNT.NO:116710100037533****SBI****NAME:SYED HAFEEZ BABA,ACCOUNT NO:35321924009,IFSC CODE:SBIN0013338,BRANCH:GODAVARIKHANI.,...