Page 294 - TP_IT_V1.0_C9_flipbpookl
P. 294

•  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.


                      LIBREOFFICE

              LibreOffice is  an  open  source online  office suite which
              includes applications like LibreOffice Writer, LibreOffice Calc
              etc., to enhance your productivity and creativity with tools
              and features available. LibreOffice Calc is the spreadsheet
              component of the LibreOffice software package.
              LibreOffice Calc is used to perform the following activities
              accurately and efficiently:
              •  Tabulation of data.
              •  Simple mathematical calculations.
              •  Complex calculations using formula and functions.

              •  Arranging data in ascending and descending order (sorting).
              •  Filtering the required data.
              •  Check the validity of data.
              •  Protection of data using passwords.                  Who invented Spreadsheet?
              •  Saving for future use.




                       GETTING STARTED WITH LIBREOFFICE CALC
              When installing the operating system Linux (Ubuntu), LibreOffice    gets installed by default along with the icons for
              each component of LibreOffice (Writer, Calc, Impress, etc.). These icons are then placed on the launcher.

              In Windows 11, you need to download LibreOffice from its official website and install it on your computer.
              After installing LibreOffice suite, you can use a spreadsheet following the given steps:

              Step 1:  Type LibreOffice Calc in the search bar at the Taskbar.
              Step 2:  Click on the LibreOffice Calc app.




























                292   Trackpad Information Technology (Ver. 1.0)-IX
   289   290   291   292   293   294   295   296   297   298   299