Microsoft Excel

MS-Excel is a very powerful and easy to use spreadsheet package: perhaps the most commonly used these days. It is a member application included in the MS- Office suite. It works very well with numbers and their complex calculations.

Excel helps prepare the data in an organized, orderly and meaningful fashion. Excel finds its major application in:
    • Creating Reports
    • Scientific and Statistical Analysis.
    • Preparing Balance Sheet.
    • Profit and Loss Accounts
    • Tax Statements.
    • Analytical reports including forecasting and regression analysis.

It works well for both simple as well as complex numbers. Good looking charts can be created which depict data in clear and meaningful fashion. It is also useful in establishing relations between different types of data.

Data Entry in MS- Excel
The smallest unit of addressable data container in Excel is a Cell. A cell is a room created by the intersection of a row and column. Each row has a unique number in a worksheet -1,2,3,……65536; each column has a unique column name in a worksheet- A,B,C…….Z,AA,AB…. And therefore each cell has a unique address in a worksheet like D13.

A worksheet is a rectangular collection of many cells. A single Excel worksheet contains as many as 65536 rows, 256 Columns and thus 16777216 cells. Each worksheet in a workbook has a unique name- sheet1, sheet2, sheet3 etc. A workbook is a collection of one or more worksheets. It is a workbook that is saved as a file on a secondary storage. Each workbook is stored in a file having a unique name – Sales.xls. xls is the default extension of the Excel workbook files. Each Excel workbook has about maximum 255 worksheets.

To start Excel:
  1. Click on the Start Button at Windows Taskbar.
  2. Select Program Option.
  3. Click at the Microsoft Excel Option.


Excel Window has the following parts:
  1. Title Bar: Title bar shows the name of the application and the name of workbook and...