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
   259   260   261   262   263   264   265   266   267   268   269