PUMPA - SMART LEARNING

எங்கள் ஆசிரியர்களுடன் 1-ஆன்-1 ஆலோசனை நேரத்தைப் பெறுங்கள். டாப்பர் ஆவதற்கு நாங்கள் பயிற்சி அளிப்போம்

Book Free Demo
LibreOffice Calc is the spreadsheet part of LibreOffice.
 
Spreadsheets enable us to organise, analyse, and store data in tabular form. Furthermore, in a spreadsheet, we can manage this data to produce specific results.
 
Other features provided by LibreOffice Calc include:
  • Functions, which can be used to formulate formulas to do complex calculations on data.
  • Database functions to organise, store, and filter data.
  • Dynamic charts are giving a wide range of \(2D\) and \(3D\ \)charts.
  • Ability to open, edit, and save Microsoft Excel spreadsheets.
In LibreOffice Calc, you create files that are known as spreadsheets. A spreadsheet consists of many individual sheets, each sheet comprising cells ordered in rows and columns.
 
Flow.png
 
A particular cell is known by its row number and column letter (for example, cell \(B4\)).
 
Cell.jpg
 
Each spreadsheet can have many sheets, and each sheet has a large number of individual cells.
 
sheets.jpg
 
Each cell can carry data in the form of text, numbers, or formulas. In Calc, each sheet can have a maximum of \(1,048,576\) rows and a maximum of \(1024\) columns.
 
rows and columns.jpg
 
r&c.jpg
 
Saving and Exporting spreadsheets:

LibreOffice Calc uses the Open Document Format with the extension *.ods to save spreadsheets. If you want to exchange files with users who use Microsoft Office, LibreOffice Calc supports saving the files to *.Xls format. Of course, you can export a spreadsheet to various file formats, including *.CSV, *.PDF, *.HTML and other formats.