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

