Page 293 - TP_IT_V1.0_C9_flipbpookl
P. 293
UNIT
4 Electronic Spreadsheet
Topics Covered 95%
Introduction to Spreadsheet LibreOffice
Getting Started with LibreOffice Calc Creating a Spreadsheet
Saving a Spreadsheet Opening an Existing Spreadsheet
Printing a Sheet Navigation in a Sheet
Entering Data Mathematical Operators Used in a Formula
Using Cell Address in Formula Insert a Column or a Row
Delete a Column or a Row What are Functions?
Formatting data in the Sheet Speeding Up the Data Entry
Find and Replace Cell Referencing
Creating Charts
A spreadsheet can be defined as text and numbers that have been organised into rows and columns. LibreOffice 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 LibreOffice 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. LibreOffice Calc is an open-source spreadsheet available in the LibreOffice 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, OpenOffice 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.
Electronic Spreadsheet 291

