Page 212 - IT_Play_V1.0 Class9
P. 212
UNIT-4 ELECTRONIC SPREADSHEET
1 CREATE A SPREADSHEET
In our daily lives and at work, we often need to do different types
of calculations. We use various methods based on the kind of
calculations we need to perform. Mathematical or statistical analysis,
long calculations, comparisons between different data sets, graphical
representation of data, etc. are the tasks that produce useful information
and provide proper data to help decision-making. Such tasks, if done
manually, prove to be tedious and time-consuming.
INTRODUCTION TO SPREADSHEET APPLICATIONS
A spreadsheet package enables you to accomplish such tasks quickly and efficiently. A spreadsheet package
is application software that does analysis, calculations, comparisons and displays information in the required
format like tables, charts, graphs, etc. By using a spreadsheet application, a user can arrange data in a
systematic manner and can also make use of logical functions to compute and analyse the data in different
ways. Spreadsheet packages are commonly used for keeping data, displaying organised data, generating
results, planning budgets, making annual reports of business organisations, generating salary statements,
doing tax calculations, etc. LibreOffice Calc, Microsoft Excel and OpenOffice Calc are the common spreadsheet
packages that are used today.
LibreOffice Calc is the spreadsheet application of the LibreOffice suite. It has been developed by The
Document Foundation. It is available free of cost and can be easily downloaded from www.libreoffice.org.
FEATURES OF CALC SPREADSHEET
LibreOffice Calc is a powerful, open-source spreadsheet application that offers a range of features comparable
to other popular spreadsheet software.
Here are some key features of LibreOffice Calc:
Open Source and Free: LibreOffice Calc is free to use and open source, meaning anyone can download,
use, and modify it without any licensing fees.
User-Friendly Interface: LibreOffice Calc provides an intuitive and customisable interface, making it easy
for users to navigate and perform tasks.
Functions and Formulas: LibreOffice Calc includes a comprehensive set of functions and formulas for
mathematical, statistical, financial, and database operations. It also supports complex formula editing.
Charting and Graphs: Users can create a variety of charts and graphs to visually represent data. LibreOffice
Calc supports column, line, pie, bar, and other chart types.
Cross-Platform Support: LibreOffice Calc is available on multiple operating systems, including Windows,
macOS, and Linux, ensuring accessibility across different platforms.
210 Information Technology Play (Ver 1.0)-IX

