Introduction To Excel

Download as docx, pdf, or txt
Download as docx, pdf, or txt
You are on page 1of 2

Applications arranged in the rows and

columns of a grid and can be manipulated


and used in calculations.

A spreadsheet is a sheet of paper that shows


accounting or other data in rows and columns; a
spreadsheet is also a computer application program
that simulates a physical spreadsheet by capturing,
displaying, and manipulating data arranged in rows
and columns. The spreadsheet is one of the most
popular uses of the personal computer.
In a spreadsheet, spaces that hold items of data are called cells. Each cell is labeled according to
its placement (for example, A1, A2, A3...) and may have an absolute or relative reference to the
cells around it. A spreadsheet is generally designed to hold numerical data and short text strings.
Spreadsheets usually provide the ability to portray data relationships graphically. Spreadsheets
generally do not offer the ability to structure and label data items as fully as a database and
usually do not offer the ability to query the database. In general, a spreadsheet is a much simpler
program than a database program.

Examples of spreadsheet
VisiCalc (for "visible calculator"). Lotus 1-2-3 came next,
followed by Microsoft Excel.
Types of spreadsheets
Electronics and manual/traditional
The Advantages of Electronic Spreadsheets
Electronic spreadsheets like those created with Excel, Numbers and OpenOffice are a key part of
modern personal and corporate finance. Electronic spreadsheets bring a number of advantages
over traditional physical worksheets. Many of these benefits come from the ability of computers
to make instant calculations and adjustments, which would take a human many times as long to
enter.

One of the key advantages of electronic spreadsheets over their manual


counterparts is in their accuracy. Given accurate data, a spreadsheet will
always produce accurate results. A second advantage is the fact that
spreadsheets can be modified easily. Consider as an example the gradelevel media budget pictured in
Figure 5.2. If it had been done manually
and the cost of printer cartridges turned out to be $10 instead of the budgeted $8, you would have to
erase and recalculate a number of different entries on the spreadsheet.

Microsoft Excel is a commercial spreadsheet application written and


distributed by Microsoft for Microsoft Windows and Mac OS X. The current
versions at the time of writing this tutorial are 2010 for Microsoft Windows
and 2011 for Mac OS X.

Microsoft Excel is a spreadsheet tool capable of performing calculations,


analyzing data and integrating information from different programs.

You might also like