Page 264 - Trackpad IT-402_Class-IX
P. 264
UNIT
4 Electronic Spreadsheet
Topics Covered 95%
Introduction to Spreadsheet Getting Started with OpenOffice Calc
Creating a Workbook Saving a Workbook
Opening an Existing Workbook Printing a Worksheet
Navigation In A Worksheet Entering Data
Types of Data Insert a Column/Row
Delete Row or Column What are Functions?
Formatting Data in the Worksheet Speeding up the Data Entry
Find and Replace Sorting
Cell Referencing Filtering Data
Creating Charts
A spreadsheet can be defined as text and numbers that have been organized into rows and columns. OpenOffice Calc
is of great importance to those who maintain accounts for sales, bills, or do mathematical calculations as it is used to
create electronic spreadsheets using the data. Let us now read about OpenOffice Calc.
INTRODUCTION TO SPREADSHEET
The electronic spreadsheet program is used for storing numeric data in an organised form so that the calculation and
analysis of the data can easily be done. OpenOffice Calc is an open-source spreadsheet available in the OpenOffice
Apache suite. This application software is most commonly used for managing financial and accounting documents,
creating data reports, generating invoices, data analysis from scientific and statistical research, and doing a variety of
calculations on data.
Some other commonly used spreadsheet software are Microsoft Excel, LibreOffice Calc, and Apple Inc. Numbers and
Google Sheets.
The basic reasons for using a spreadsheet are as follows:
• Data can easily be organised in tabular form using rows and columns.
• Mathematical calculations like sum, average, minimum, etc. can easily be done either by using user-defined formulae
or by using built-in functions.
• Data once created can be rearranged in ascending or descending order, filtered based on a criterion and so on.
• Data validation and data analysis can be done by using the Pivot table, Goal seek, etc.
• Graphical representation of data can be done using charts.
Commonly Used Spreadsheet Software
Some commonly used spreadsheet software are as follows:
Office 365 Excel Microsoft Excel OpenOffice Calc Lotus Symphony LibreOffice Calc Google Sheets
264 Trackpad Information Technology-IX

