Airfare Daily Deals eCigarettes Eyeglasses Hotels Jewelry Online Backup Online Dating Online Printing Online Tickets Skin Care Textbook Rentals Vitamins Web Hosting Weddings
Find coupons, reviews and similar sites for any retailer
SEARCH

Features of MS Excel

Features of MS Excel Some of the most important features of Excel are: Windows-based application: MS Excel has an interface similar to Windows operating system. Like all Windows applications, Excel has toolbars, shortcut menus, AutoCorrect, Online help and Wizards. This makes Excel easier to learn for users of Windows. Workbooks: Workbooks are containers that hold one or more worksheets. Keeping all sheets that are related to-a project in one file reduces the need to maintain different files.

Features of MS Excel

Some of the most important features of Excel are:

Windows-based application: MS Excel has an interface similar to Windows operating system. Like all Windows applications, Excel has toolbars, shortcut menus, AutoCorrect, Online help and Wizards. This makes Excel easier to learn for users of Windows.

Workbooks: Workbooks are containers that hold one or more worksheets. Keeping all sheets that are related to-a project in one file reduces the need to maintain different files.

Auditing: Worksheet auditing is a feature that checks a worksheet for errors. Auditing can be used to relate formulas in different cells and locate the source of a calculation error.

OLE support: Excel worksheets can contain any object, like a document, a picture or a video clip. This feature is known as Object Linking and Embedding (OLE). This capability can be used to integrate Excel with all other applications.

Data entry forms: You can create custom data entry forms within a worksheet. Validation rules and formatting can be included within a form.

Large data management capacity: Excel can maintain large volumes of data at a time. A worksheet can contain 65,536 rows and 256 columns. A single cell can contain a maximum of 255 characters. One workbook can contain a maximum of 255 worksheets. Such data management capacities make Excel a powerful spreadsheet application.

Data analysis features: Excel contains powerful tools that help in data analysis. Pivot tables, Microsoft Query and Data Map tools allow users to present data in different ways to facilitate analysis.

Starting Excel 2003

Excel can be loaded in one of the following ways:

• Select the Microsoft Excel button from the Programs group in the Start Menu.

•Click the short  icon twice shortcut on the desktop.

Create a Workbook file

To get started, create a workbook file. You can produce a new, blank workbook; or to save time, open an existing workbook or a template and fill in your data.

What's the difference between a workbook and a worksheet?

A workbook is a Microsoft Excel file containing one or more sheets; each worksheet is a "page" in the workbook on which you enter and work with data. Workbooks start with three worksheets but you can add worksheets and other kinds of sheets.

Need an answer?
Get insightful answers from community-recommended
experts
in Software on Knoji.
Would you recommend this author as an expert in Software?
You have 0 recommendations remaining to grant today.
Comments (0)
ARTICLE DETAILS
RELATED ARTICLES
ARTICLE KEYWORDS