Chapter 2: Electronic Spreadsheet (LibreOffice Calc) 📌 Chapter 2 – Important Topics: Introduction to Spreadsheet & LibreOffice Calc Components of Spreadsheet (Cell, Range, Workbook, Worksheet) Data Types – Value, Label, Formula Cell Referencing – Relative, Absolute, Mixed Functions – Date & Time, Mathematical, Statistical, Logical, Text, Lookup, Financial (with exact syntax) Data Entry, Validation, Formatting Output Reports – Pivot Table, One/Two‑variable Data Table Common Error Codes Previous Year Exam Questions What is a Spreadsheet? A spreadsheet is a computer program that allows the user to store data in a grid of rows and columns. It is used to record, calculate and compare numerical or financial data. Eg: Microsoft Excel 2007, LibreOffice Calc, Lotus 1-2-3 etc. 📌 Live Example 1 – Business: Lakshmi, a teacher, wants to prepare a list of 180 students (Commerce, Science, Humanities) with their exam scores. Using LibreOffice ...