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
   288   289   290   291   292   293   294   295   296   297   298