Electronic Spreadsheet Advance it402 it 402 class x

  1. Introduction to Calc

  2. Consolidating Data

  3. Senarios or Senarios Manager

  4. Multiple Operations

  5. Goal Seek

  6. Linking Data and Spreadsheet

  7. Sharing Working Data

  8. Working with Macros

Introduction to Calc:
Calc is the spreadsheet software of LibreOffice. it is similar software  as MS Excel and Google Sheet. Calc is a free and open-source software. it is also known as Spreadsheets software. Spreadsheets allow us to organize, analyze and store data in tabular form. Calc software main features are to copying and reusing data, creating sheets and use formulas for calculations. A lot of features are available in calc that do our tasks very easier like calculations, graphs and charts, data validation, what-if analysis and performing statistical analysis. All these tools are available under the Menu or Tab options.


The Main features of this  Calc software are:

  • Functions or formulas, that can be used to calculations on data.

  • Database functions to arrange, store, and filter data.

  • Creating charts giving a wide range of 2D and 3D charts.

  • Ability to open, edit, and save other software file like Microsoft Excel  & Google spreadsheets .

In Calc you create files that are called spreadsheets. A spreadsheet consist of a number of individual sheets, each sheet containing cells arranged in rows and columns. A particular cell is identified by its row number and column letter (for example cell A1). Each spreadsheet can have many sheets, and each sheet has a large number of individual cells. Each cell can contain 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.

MS Excel
Google Sheet
Introduction to calc

Consolidating Data-: