What is Spreadsheet?
Spreadsheet is a large worksheet
having data and information arranged in rows and columns. It is
one of the most widely used applications by using of computation and useful in entering, editing, analyzing and
storing data. Arithmetic operations with numerical data such as addition,
subtraction, multiplication and division can be done using on spreadsheet. You can sort
numbers/ characters according to some given criteria such like ascending,
descending etc. and by use simple financial, mathematical and statistical
formulas. In Industry, spreadsheet are a big help by preparing some reports such as Gantt chart, scheduling & planning, forecasting and inventory for warehouse monitoring stock products for logistic delivery. In the field of education, spreadsheet is the one powerful software application to help in computing grades, data analysis and assessment report.
Some of the Main Features of Spreadsheets:
1. Auto Sum - helps you to add the contents of a cluster of
adjacent cells.
2. List Auto Fill - automatically extends cell formatting
when a new item is added to the end of a list.
3. Auto Fill - allows you to quickly fill cells with
repetitive or sequential data such as chronological dates or numbers, and repeated
text. Auto Fill can also be used to copy functions. You can also alter text and
numbers with this feature.
4. Auto Shapes toolbar will allow you to draw a number of
geometrical shapes, arrows, flowchart elements, stars and more. With these
shapes you can draw your own graphs.
5. Wizard - guides you to work effectively while you work by
displaying various helpful tips and techniques based on what you are doing.
6. Drag and Drop - it will help you to reposition the data
and text by simply dragging the data with the help of mouse.
7. Charts - it will help you in presenting a graphical
representation of your data in the form of Pie, Bar, Line charts and more.
8. Pivot Table - it flips and sums data in seconds and allows
you to perform data analysis and generating reports like periodic financial
statements, statistical reports, etc. You can also analyse complex data
relationships graphically.
9. Shortcut Menus - the commands that are appropriate to the
task that you are doing will appear by clicking the right mouse button.
As a future educator, we must enhance our knowledge and skills in the usage of spreadsheet to presents the best result in our learning skills and strategies in performing computations.