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
- Employability: Communication Skills – I
- Employability: Self-Management Skills – I
- Employability: ICT Skills – I
- Employability: Entrepreneurial Skills – I
- Employability: Green Skills – I
- Introduction to IT–ITeS Industry
- Data Entry and Keyboarding Skills
- Digital Documentation using LibreOffice Writer
- Electronic Spreadsheet using LibreOffice Calc
- Digital Presentation using LibreOffice Impress
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 freeFree to start · No credit card needed