• Ms-Excel is very easy to use.
• We can easily perform calculations by using different functions available in this program.
• We can work with two or more than two worksheets at a single time.
• We can represent data through different charts and graphs.

Starting MS Excel 2007

To start Ms-excel program, we should follow the following steps:

• Step 1:Click on the start button.
• Step 2:Move the mouse pointer over All Program Option.
• Step 3:Move the mouse pointer over Microsoft office option.
• Step 4:lick on the Microsoft Excel 2007.
  Then the window appears on the screen.

• Relative cell reference: Relative referencing means that the cell address changes as you copy or move it; i.e. the cell reference is relative to its location.
• Absolute cell reference: This means the cell reference stays the same if you copy or move the cell to any other cell. This is done by anchoring the row and column, so it does not change when copied or moved.
• Mixed cell reference: This means you can choose to anchor either the row or the column when you copy or move the cell, so that one change and the other does not. For example, you could anchor the row reference then move a cell down two rows and across four columns and the row reference stays the same.

• Step 1: Select two or more adjacent cells that you want to merge.
• Step 2: Click on Merge & Center button situated at Home tab.

• Step 1: Type two numbers in the cell from the sequential numbers.
• Step 2: Select both cells.
• Step 3: When you drag the cell to the right corner, the cursor changes into "+" symbol. This is called fill handle. If u click and drag the fill handle then you can get the numbers serially in different cells.

• Step 1: Click on the cell in which you want to carry out function.
• Step 2: Type "=" sign in the same cell.
• Step 3: Type SUM and '(' and range of the cells which are to be added. Then type ')' and enter to see the result.
• Step 4: If the same formula is to be used in other cells then click on fill handle and drag the mouse to those cells.

• Step 1: Click on the cell.
• Step 2: Type "=" and use MIN function.
• Step 3: Type MIN and '(' and range of the cells in which you want to find the smallest number. Then type ')' and enter to see the result.
• Step 4: If the same formula is to be used in other cells then click on fill handle and drag the mouse to those cells.

• Step 1: Click on the cell in which you want to calculate result.
• Step 2: Evaluate marks of different subjects by using If function.
• Step 3: Result is calculated according to marks obtained.
• Step 4: If the same formula is to be used in other cells then click on fill handle and drag the mouse in those cells.

Formatting

• Step 1: Select the cell or range of cells where you want to change the font name.
• Step 2: Select the font name and size from the font group of home menu's ribbon.

• Step 1: Select the data which needs to be sorted.
• Step 2: Click on Data tab.
• Step 3: Click on Sort button.
• Step 4: Type criteria on the window.
• Step 5: If the selected data are header then tick on check box 'my data has header'.
• Step 6: Click on the sorting option A to Z or Z to A from the Sort & Filter group of Data menu's Ribbon.

• Step 1: Select the range of data include in chart.
• Step 2: Click on the Insert menu.
• Step 3: Select on the Flayer menu of the Chart group from the Ribbon of Insert menu.
• Step 4: Select the appropriate Template for the graph.
• Step 5: Select the desired type of graph.

To change the types of chart

• Step 1: Click on available chart.
• Step 2: Click on change chart type button of design tab.
• Step 3: Windows with different charts are opened.
• Step 4: Click on required chart you want.
• Step 5: Then click on OK button.

To add title of chart