MS-EXCEL

MS-Excel is a spreadsheet package. When you start excel, a blank workbook appears in the document window. The workbook is the main document using excel for storing and manipulating the data.
A workbook has individual worksheets each of consisting of data. Each work sheet is made up of 256 columns and 65,536 rows.

The FEATURES OF EXCEL:

  • The multiple Undo feature can Undo up to the last 16 actions.
  • When you quit Microsoft Excel with multiple files open, you get a YES to ALL option. You can choose this option to save all the files before exiting, instead of being prompted to close each open file.
  • Conditional Formats dynamically apply a different font style , pattern and the border to the cells whose values fall outside or with in the limit specified by you.. this lets you quickly spot areas of interest without reading through tables of values.
  • The Hyperlinks Feature helps you to create hyperlinks that connect to other office files on the system, your network. A hyperlink can be text in the cell , a graphic or you can write a formula that creates a hyperlink.
  • The Web Queries features allow you to create and run the queries to retrieve data available on the World Wide Web.
  • The Internet assistant wizard steps you through the process of saving the worksheet data and the charts in the HTML format. You can save the data and the chart as a complete new Web Page or add them to an existing Web Page.
  • The new Share Workbook feature lets multiple users open a workbook on the network and edit the document simultaneously.
  • CellTips and the ScrollTips automatically display the comments added to cell.
  • The worksheet has expanded to include 65,536 rows and you can type up to 32,000 characters in a cell.
  • Natural Language formulas allow you to create formulas that use row and the column headers instead of the range references.
  • The Auditing and the Validation facility allow you to circle the invalid data and to see at a glance all the entries that don’t meet your validation rules.
  • The enhanced Get External Data features enable you to query Access and the other databases either on the system or a network or the Internet or intranet resources.

Add to Technorati Favorites


// Related Posted - GOOGLE!

Loading



Related Websites
Wednesday, April 30th, 2008 at 23:09
No comments yet.

Leave a comment

XHTML: You can use these tags: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <strike> <strong>