Introduction to Spreadsheet | What is the meaning of Spreadsheet?
Definition of a Spreadsheet.
A Spreadsheet is a sheet of paper or programs where by the user can enter, edit, and manipulate numerical data or statistical data.
A Spreadsheet consists of rows & columns.
Types of
Spreadsheets:
The following are 2 types
of spreadsheets:
1). Manual
spreadsheet:
A Manual spreadsheet is a paper or book with many sheets of papers divided into rows and columns for
entering/writing data. The data is entered manually in a paper using a pen or pencil. People where using this type of spreadsheet long time ago before the introduction of electronic device
2). Electronic
Spreadsheet:
A computer program with
rows & columns for entering and manipulating data mathematically using
of formula or functions.
Advantages of Electronic Spreadsheets
over Manual Worksheets.
An electronic
spreadsheet:
1. Has a large worksheet for data entry that means you can enter a lot of data compared to manual worksheet
2. It has inbuilt formula called Functions, these functions
enable the users to quickly manipulate mathematical data easily.
3. You can format easily and editing qualities compared to manual worksheet
4. In Electronic the user can very quickly & efficiently
perform complicated computations using the information stored in an electronic
spreadsheet.
5. It offers graphical representation of data
leading to comprehensive decisions.
The following are examples of the commonly used Spreadsheet packages
- Microsoft Excel.
- Corel Quattro-Pro
- Microsoft Works Excel.
- Vp-Planner
- VisiCalc
- Lotus 123
Advertisemen
COMPONENTS
OF A SPREADSHEET
A spreadsheet has three main components as follows:
- Workbook.
- Database.
- Graphs / Charts.
1. Workbook
This is a file in a spreadsheet
package that contains one or more worksheets.
The
worksheets are made up of rows & columns in which you work and store your data. This
component allows the user to organize various kinds of related information in a single file.
worksheets are made up of rows & columns in which you work and store your data. This
component allows the user to organize various kinds of related information in a single file.
2. Database
This component can help to manage data
values entered in the cells of the spreadsheet.
The features which are found on the Data menu,
were incorporated in Excel but they belong to Database Management System
software.
3. Graphs/Charts
This is a graphical or pictorial representation of data in a worksheet that can be easily understood. Charts are used to summarize data in a worksheet in a pictorial form.
Examples of charts
are: Pie charts, Line graphs, Bar charts, Histograms, Column charts, etc.
0 Response to "Introduction to Spreadsheet | What is the meaning of Spreadsheet?"