1) Need for spreadsheet and its uses

Need for spreadsheet and its uses

If you have a huge data say details of all students in your school, how will you classify and arrange the data?
Is it possible to sort the data in ascending or descending order?
Is it possible to pick the data related to a specific person/ thing?

When we have a huge data, it’s challenging to arrange it on paper manually . Likewise it is also difficult to order data or retrieve data from a data set manually. In such cases, the need for spreadsheet arises.

A spreadsheet is a piece of software for handling and manipulating numbers. It looks like an accounting worksheet that can be stored in computer and used to work with large data. A spreadsheet can be incredibly useful to:
Organize information in horizontal rows or vertical columns
Sort data alphabetically and numerically, in ascending and descending order
Do any kind of mathematical calculation on the data
Manipulate the data to produce certain results
line up groups and lists and sort them
whole calculation can be recalculated instantly after even a single value changes
represent data visually
Save data in a range of formats