analysis using Microsoft Excel
excel is an Electronic spreadsheet Program. These spreadsheet programs
have evolved dramatically over the past decade, and now comprise
one of the most widely used categories of software products. Among
these Excel is versatile as it has more user interface features
in common with other Microsoft Office applications such as MS Word,
MS Power point MS Access etc.
is software, which is a substitute to all types of applications
using paper worksheets. Spreadsheet displays data in the form of
rows and columns. An intersection of wows and columns is known as
cell. Data and formulae are entered in the cell. Spreadsheet allows
to perform the following.
All types of arithmetic calculations
Allows to perform many types of Statistical Analysis from simple
Allows to represents data in various graphical forms and hold
graphical objects like pictures and images
Important features of Excel Excel like all other applications has
tool bars, short cut Menus, templates, Wizards and online help.
Windows Environment: Excel like all
other all other applications has tools bars, Shortcut Menus, Templates,
Wizards and online help.
Workbooks: An Excel document is referred
to as workbook. There are 256 worksheets in each workbook. Each
worksheet contains 65,536 (256X256) rows and 256 (AA, BB,..BA,BB,
….IV) columns. Each single cell in and worksheet can accommodate
about 32,000 characters.
Formula bar: Below the tool bar (i.e.
Standard and Formatting), there is a Formula Bar.
Cell Address: On the left hand side
of Formula Bar is the address Box. The address of the cell which
is active is shown in the box. Ex. A1 refers the cell in first
column and first row.