Saturday, March 26, 2011

Insert Function in Microsoft Excel 2010

In Excel 2010 we have an option to select the a range of cells and insert function depending on the values and need. The database of the formulas in 2010 version has increased in numbers. It has become very easy to do simple calculations without typing any formula in the address bar. 

Steps to Insert Formula in Excel 2010: 


1) Place the cursor in the cell where we need to get the data using certain function. Say we need to average the number of days per month in an year. 






2) Click on Formulas Menu and Click on Insert Function option just below the File Menu which has following icon. 


 3) Select the function average (for current example) and click on OK




3) When we click OK on the above dialog box we will get another dialog box asking for the range of data. we can select using mouse from the worksheet




When we drag to select the data, it will note the range automatically. Click on OK to get the average of number of days in a month. 






This is the easiest method of doing simple calculations on Microsoft Excel. For simple mathematical calculations we can use this method to get the function inserted and executed automatically. 

7 comments:

Intersting and beautiful blog lovely presentation thanks for sharing your views...microsoft office 2010 support We24support tech team are available 24/7 for repairs on computers, printers, laptops, desktops. Our tech team taken to new heights with our technician’s knowledge and support.at 1-866-978-0799 microsoft office 2010 tech support .

Intersting and beautiful blog lovely presentation thanks for sharing your views...microsoft excel support|Excel Support|microsoft excel 2010

Intersting and beautiful blog lovely presentation thanks for sharing your views...microsoft excel support|Excel Support|microsoft excel 2010

Onspotsupport tech team are available 24/7 for repairs on computers, printers, laptops, desktops. Our tech team taken to new heights with our technician’s knowledge and support.

Question
I have Excel 2010 by mistake I deleted or hided the f(x) row, now I don't know how to do in order to get it back..... Help me please :-(

Post a Comment

Search This Blog

Followers

Related Posts Plugin for WordPress, Blogger...
Twitter Delicious Facebook Digg Stumbleupon Favorites More