Introduction The basic concept of MS-EXCEL and function

MS-EXCEL 2000 is a window based spreadsheet package, which is used for entering, editing, analysis, and storing of data. The arithmetic operation such as addition, subtraction, multiplication, and division can also be performed with Excel. you could type the variety/characters according to a few given criteria (like ascending, descending, etc.), Solve simple financial, mathematical and statistical, formulas and also a present graphical representation of data, such as in piecharts, bar diagram, in MS-EXCEL.

Some Basic Features Excel.

• AutoSum - Allows adding the contents of a cluster of adjacent cells.
• AutoFill - Allows filling cells with repetitive or sequential data such as chronological dates of number.
• AutoShapes - Allow you to draw an of geometrical shapes, arrows, flowchart elements, stars and more. With those shapes, you could draw your own graphs.
• Wizard - Help to function effectively while we work by displaying various helpful tips and techniques based on what we are doing.
• Charts - Help in presenting a graphical representation in data in the form of Pie, Bar, Line, etc. 
• PivotTable - Flips and sum data and allows to perform data analysis and generating reports.

Starting Excel

Click on the start - Programs - MS EXCEL or Select start - Programs - Microsoft Excel commands from your menu bar.

Excel worksheet

Excel allows you to create worksheets much like paper like that can perform the automatic calculation. Every Excel record is a workbook that could maintain many worksheets. The worksheet is a grid column (denoted by letters) and rows (denoted by number). The latter and number of the columns and rows (called labels) are shown in gray buttons across the top and left a side of the worksheet. Every intersection of a column and a row is called a cell. Each cell on the spreadsheet has a called cell address which is the column letter and the row number. A cell can contain either text, numbers, or mathematical formulas.

Cell References 

Every worksheet contains a number of columns and rows. Every the cell of the worksheet has a unique reference. For example, E7 refers to the cell containing column number E and row number7.
Selecting Cells and Ranges. To enter data into your worksheet you must first select a cell of a range. When we open an excel worksheet, cell AI is already active. An active cell has a darker border around in then other cells. The easiest way to select a cell is with a mouse pointer. To the desired cell and click on it with right button cell. To select a range of cell, clicks on one cell, hold down the left mouse button and drag the mouse pointer to the last cell of the range you desire to select. you can also use keyboard shortcuts for selecting a cell.

Data Entry

we can enter various kind of data in a cell

• Number: Number can be from a numeric values:whole number (example,25), decimals (example, 25.67) and scientific notation (example, 0.2567E+2).
• Text: Select the cell in which data has entry. This entered text is displayed in the active cell as well as in the formula bar.
• Date and Time: When we enter date and times, Excel converts these entries into serial numbers and keeps as a piece of background information. However, the dates and times are displayed to you on the worksheet in a format outed by us.

Editing Data

Editing Excel worksheet data is very simple. we can edit your data by a number of ways.

• Select the cell containing data to be edited and press F2. use the backspace key to delete the wrong entry and retype the correct entry.
• Select the cell and retype the correct entry.
• If you want to clear the contents of the cell, select the cell and press Delete key.

Modifying Worksheet.

Adding Worksheet, Rowa, and Columns.

• Worksheets - To add worksheet to a workbook, select insert - worksheet from the menu bar.
• Row - To add a row to a worksheet on the row label, right-click with the mouse, and choose insert. 
• Column - To add a column select insert - column from the menu bar, or highlight the column by clicking on the column level, right-click with the mouse, and choose insert.

Resizing Rows and Columns

Rows and columns can be resized in two ways 

• Resize a row by dragging the lines below the label of the row you wish to resize. Resize a column by dragging the line to the right of the label corresponding to the column you wise to resize.                                                                                                                                               Or
• Click the row or column label and select the format - row - Height - or Format - Column - width - From the menu bar to enter a numerical the peak of the row or width of the column.

To active the contain of the cell, double - click on the cell or click once and press F2.
Entering a Formula: Entering Formula in an excel cell is different from what we. normally do in mathematics. A formula in excel always begins with and is always entered into the cell where the formula answer is desired to be obtained. To obtain the result of a formula simple type the formula in a cell and press Enter.

File close and exit Excel

while your paintings are completed and it's been saved nicely:

• Select File - Close command and then click the mouse to close your file.
• Select File - Exit command and then click the mouse to close your file.