Notes · Class 9 · CBSE Information Technology (402)

Electronic Spreadsheet using LibreOffice Calc notes

Revision notes for the chapter: the key points, definitions and exam tips to remember.

LibreOffice Calc is a spreadsheet program used to organise, calculate and analyse data in rows and columns (.ods files).

BASICS

  • A file is a workbook; it contains sheets (worksheets).
  • Columns are lettered (A, B, C…), rows numbered (1, 2, 3…); their intersection is a cell (e.g. B3). The active cell has a dark border.
  • A range is a group of cells: A1:A10.
  • Name Box shows the cell address; Formula Bar shows the cell contents.

ENTERING DATA

  • Text, numbers, dates and formulas. Edit a cell with F2.
  • Fill handle: drag to copy or create a series (1, 2, 3…; Monday, Tuesday…).

FORMULAS AND FUNCTIONS

  • Every formula starts with "=". Operators: + − * / ^.
  • Order of operations: brackets, exponents, multiply/divide, add/subtract (BODMAS).
  • Functions: =SUM(A1:A5), =AVERAGE(), =MAX(), =MIN(), =COUNT().
  • Relative reference (A1) changes when copied; absolute reference ($A$1) stays fixed; mixed ($A1 or A$1).

FORMATTING

  • Number formats (currency, percentage, date), alignment, merge cells, borders, background colour, wrap text.
  • Insert/delete rows and columns, adjust width and height.
  • Sort and filter data.

SHEETS

  • Insert, rename, delete, move sheets (right-click the sheet tab).
Memory hook: "Start with = and Calc will calculate."

Electronic Spreadsheet using LibreOffice Calc: practice questionsElectronic Spreadsheet using LibreOffice Calc cheat sheet

More Class 9 · CBSE Information Technology (402) notes

Practise Electronic Spreadsheet using LibreOffice Calc

Sign up free to practise the full chapter after revising. Questions you get wrong come back until you've mastered them.

Start practising free

Free to start · No credit card needed