Microsoft Office Excel

It has two types of Extension .xls and .xlsx. In old version, up to 2003 is .xls and now is .xlsx up to 2013.

An Excel file called Workbook and a Workbook have many Worksheet or Electronic Spreadsheet (256).

Electronic Spreadsheet: An electronic spreadsheet application accepts data values and relationships between the data values in a tabular format consisting of rows and columns. It allows user to perform calculation on these values. If any information is changed the worksheet program automatically recalculates all results.

Create an excel file: Computer>>Local Disk (D:)>>New Folder>>Microsoft Office Excel Worksheet>>Open.

Excel specifications and limits:

  1. First Column Name: A
  2. First Row Number: 1
  3. Last Column Name: XFD
  4. Last Row Number: 1048576
  5. First Cell Name: A1
  6. Last Cell Name: XFD1048576
  7. Total Column Number: A to XFD=16384
  8. Total Row Number: 1048576
  9. Total Cell Number: XFD1048576=16384X1048576=17179869184

Cell Reference: A reference that identifies a cell or a range of a cells on a worksheet that user want to use in a formula. There are three types of cell reference are as follows.

1. Relative Cell Reference: When user copy formula from one cell to another cell, the cell address is changed accordingly. For example:-

2. Mixed Cell Reference: For fixed a column or row in a formula user should to fixed ($) column or row. When user copy formula from one cell to another cell, then one part of cell is fixed and other is relative. For example:-

3. Absolute Cell Reference: For fixed a cell value in a formula user should to fixed ($) column as well as row. When user copy formula from one cell to another cell, then cell address will not be change accordingly. For example:-

Comment: A comment is a note that attach to a cell and separate from other cell content. Comments are useful as remainders.

Filtering Record: Filtering is a quick and easy way to find and work with a subset of data in a range. It displays only the rows that meet the criteria that user specify for a column. There are two types of filtering: a)Auto Filter and b)Advance Filter.

Chart: Chart is a Pictorial representation of data in the worksheet. It give user to represent data in the most effect manner by using any type of chart. There are 11 type of chart in Excel 2007.

Goal Seek: Goal Seek is the part of a suite of commands sometimes called what-if analysis tools. Microsoft Excel use the value in one specific cell until a formula that’s dependent on that cell for return the result which user want.

18 Replies to “Microsoft Office Excel”

  1. Praesent urna velit, auctor nec turpis et, vehicula lobortis sem. Vivamus convallis mi sagittis eleifend laoreet. Praesent vitae venenatis enim. Nulla tincidunt Varys et lectus rhoncus laoreet. Alysia Natal Linkoski

  2. If you are going for best contents like I do, only go to see this web page all the time because it presents feature contents, thanks Florentia Raimundo Dulcy

  3. Thank you for the sensible critique. Me and my friend were just preparing to do a little research about this. We got a book from our local library but I think I learned better from this post. I am very glad to see such fantastic information being shared freely out there. Christine Salem Retha

  4. I think the last time we visited a zoo was in Australia back in 2004. That was a great place to see native Australian animals that we would likely not have seen otherwise. Stormi Ryley Baggs

  5. Hey there. I found your site by means of Google at the same time as searching for a comparable matter, your site got here up. It looks great. I have bookmarked it in my google bookmarks to come back then. Daile Francois Puklich

  6. I simply had to say thanks yet again. I am not sure the things that I would’ve created without the actual concepts shown by you concerning my problem. It previously was a real alarming condition in my circumstances, but understanding your specialised strategy you processed it forced me to weep with joy. I will be grateful for the guidance and hope that you find out what a powerful job you happen to be undertaking instructing most people via your website. I’m certain you’ve never encountered any of us.

  7. Can I just say what a relief to discover somebody
    who really knows what they are discussing online.

    You certainly realize how to bring a problem
    to light and make it important. More and more people ought
    to look at this and understand this side of the story.
    It’s surprising you are not more popular since you surely possess the gift.

  8. I simply wanted to jot down a quick note to be able to thank you for those magnificent guidelines you are sharing here. My time-consuming internet search has now been recognized with professional facts and techniques to talk about with my friends and classmates. I would admit that many of us site visitors are quite lucky to dwell in a decent place with so many marvellous individuals with very helpful plans. I feel truly grateful to have used your entire web pages and look forward to plenty of more enjoyable times reading here. Thanks a lot once again for everything.

Leave a Reply

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