MS EXCEL
Electronic worksheet or Spreadsheet
An electronic worksheet or spreadsheet program is used to perform calculations,
store information in the memory of a computer and display the information or the results in the
required format on your computer screen. In other words, it replaces the normal paper sheet or
ledger, pencil(or pen), eraser and calculator. In such a worksheet information is entered through
the keyboard and displayed on the computer screen. The information already entered on the
screen can be changed very easily. Besides, when any information is changed, the spreadsheet
program automatically recalculates results on the basis of new information.
Microsoft Excel is an integrated electronic Worksheet (spreadsheet ) program
developed by Microsoft Corporation, USA. It includes three components —---worksheet, graph
(chart) and database management. It lets you create your worksheet and enter information. It
performs all kinds of calculations and displays results on the screen in the form of figures or
graphs. You can perform various database management functions on the data entered in the
worksheet.
Opening Excel:
Start>>Programs >>Microsoft Office>>Microsoft Office Excel 2003
Microsoft Excel will automatically open with a blank spreadsheet spanning many columns and
rows. You will notice a number of toolbars with many more options included.
Standard Toolbar:
1. New: Create a new, blank spreadsheet
2. Open: Open a previously saved spreadsheet
3. Save: Save your current spreadsheet
4. Permission: To protect a worksheet
5. Print: Prints the current document.
6. Print Preview: Preview the potential print of the current document.
7. Research: Microsoft has enabled Information Rights Management(IRM) within the new
version of Excel, which can help protect sensitive documents from being copied or
forwarded. Click this for more information and options.
8. Copy: Copies the current selection to the clipboard, which can then be pasted
elsewhere in the document.
9. Paste: Takes the current clipboard contents and insert them.
10. Undo: Undoes the last action in the document, reverting "back" a step in time.
11. Insert Hyperlink: Inserts a hyperlink to an Internet Location.
12. AutoSum: A drop-down menu of available mathematical operations to perform.
13. Sort Ascending: Sorts the current selection in ascending order.
14. Chart Wizard: Opens the" chart Wizard, " which will walk you through the creation of a
chart / diagram using the currently selected information.
15. Microsoft Excel Help: Brings up the Excel Help window, which will allow you to type in
a key-word for more information, or click anything on screen to directly bring up further
information on that subject.
16. More Options: There are a variety of extra options you can call or add to the toolbar,
such as spell Check, Sort Descending, cut, Redo, etc. By clicking the triangle, you can
Electronic worksheet or Spreadsheet
An electronic worksheet or spreadsheet program is used to perform calculations,
store information in the memory of a computer and display the information or the results in the
required format on your computer screen. In other words, it replaces the normal paper sheet or
ledger, pencil(or pen), eraser and calculator. In such a worksheet information is entered through
the keyboard and displayed on the computer screen. The information already entered on the
screen can be changed very easily. Besides, when any information is changed, the spreadsheet
program automatically recalculates results on the basis of new information.
Microsoft Excel is an integrated electronic Worksheet (spreadsheet ) program
developed by Microsoft Corporation, USA. It includes three components —---worksheet, graph
(chart) and database management. It lets you create your worksheet and enter information. It
performs all kinds of calculations and displays results on the screen in the form of figures or
graphs. You can perform various database management functions on the data entered in the
worksheet.
Opening Excel:
Start>>Programs >>Microsoft Office>>Microsoft Office Excel 2003
Microsoft Excel will automatically open with a blank spreadsheet spanning many columns and
rows. You will notice a number of toolbars with many more options included.
Standard Toolbar:
1. New: Create a new, blank spreadsheet
2. Open: Open a previously saved spreadsheet
3. Save: Save your current spreadsheet
4. Permission: To protect a worksheet
5. Print: Prints the current document.
6. Print Preview: Preview the potential print of the current document.
7. Research: Microsoft has enabled Information Rights Management(IRM) within the new
version of Excel, which can help protect sensitive documents from being copied or
forwarded. Click this for more information and options.
8. Copy: Copies the current selection to the clipboard, which can then be pasted
elsewhere in the document.
9. Paste: Takes the current clipboard contents and insert them.
10. Undo: Undoes the last action in the document, reverting "back" a step in time.
11. Insert Hyperlink: Inserts a hyperlink to an Internet Location.
12. AutoSum: A drop-down menu of available mathematical operations to perform.
13. Sort Ascending: Sorts the current selection in ascending order.
14. Chart Wizard: Opens the" chart Wizard, " which will walk you through the creation of a
chart / diagram using the currently selected information.
15. Microsoft Excel Help: Brings up the Excel Help window, which will allow you to type in
a key-word for more information, or click anything on screen to directly bring up further
information on that subject.
16. More Options: There are a variety of extra options you can call or add to the toolbar,
such as spell Check, Sort Descending, cut, Redo, etc. By clicking the triangle, you can
