MS EXCEL

MS EXCEL


MS excel window contains the following parts:
          1. Title Bar
          2. Menu Bar
          3. Standard Tool Bar
          4. Formatting Tool Bar
          5. Sheet Name
          6. Current Cell Reference
          7. Scroll Tools
          8. Cell pointer
Formatting Features
          Before entering, editing or formatting cells, they need to be selected. We can select a single cell or a group of continuous cells. To select a single cell, simply point and click on it to make it active. Click a row number to select the entire row.
Entering and Editing Text
          To enter any text, simply activate any cell by clicking on it and start typing.
Press Enter to conclude entry.
Creating and saving a workbook
          Choose New command from File menu and Click OK button. A new blank workbook would be displayed.
          Choose Save command from File menu and enter the file name then click Save button.
Insert Menu
          This command is used to insert or insert rows or columns anywhere in the worksheet.
Inserting Picture
          In MS excel inserting pictures with different ways ;
1.   Inserting Clip Art
2.   Picture from file
3.   AutoShapes menu
4.   Picture Organization Chart
5.   Word Art
6.   From Scanner, etc.
 Borders and color
          Borders and color provide further ways to highlight information in a worksheet. A border is a line drawn around a cell or a group of cells. Fill color is used to highlight the background of part of a worksheet ; fond color is applied to text.
 Aligning Text

General aligning text are Left, Center and right. Excel has a forth alignment called Merge and Center., which merges selected cells into one cell and centers the contents of the top left selected cell across the new merged cell.