Curriculum
Grade IX IT(402)
Lessons
0/5
Notes
0/5
Work Sheets
0/5
All Notes and All Work Sheets
0/2
Chapter 4-Electronic Spreadsheet
School Revise · Class 9 Information Technology · Chapter 4
Electronic Spreadsheet
Code 402, Class 9. A spreadsheet works with numbers in a grid. Here we enter data, use formulas and functions, and make a chart.
|
|
What this chapter is about
A spreadsheet stores data in a grid of rows and columns. Each box is a cell, named by its column letter and row number, such as B3.
1. Cells, rows and columns
Columns are named by letters (A, B, C) and rows by numbers (1, 2, 3). The cell address is the column and row together, like C5. You type data straight into a cell.
2. Formulas and functions
A formula starts with = and calculates, for example =A1+A2. A function is a ready made formula, such as SUM, AVERAGE, MAX and MIN, for example =SUM(A1:A5).
|
=SUM(B2:B6) (adds the values in cells B2 to B6) |
3. Charts and formatting
A chart shows data as a picture (a bar or line chart). You can also format cells: change the font, add borders and colour, and sort the data.
Practise with the interactive
Explore the idea by tapping. The interactive opens right here in the lesson.
Practice set A, multiple choice
1. A box in a spreadsheet is a …
cell.
2. A formula always starts with …
the = sign.
3. Which function adds a range of cells?
SUM.
4. The name of a cell (like C5) is its …
cell address.
Practice set B, short answer
1. What is a cell address?
The column letter and row number of a cell, such as C5.
2. What does =SUM(A1:A5) do?
It adds the values in cells A1 to A5.
3. Name any two spreadsheet functions.
SUM, AVERAGE, MAX or MIN. [any two]
Quick summary
|
A spreadsheet stores data in a grid of rows (numbers) and columns (letters); each cell has an address like C5. A formula starts with = and calculates, such as =A1+A2. Functions are ready made formulas: SUM, AVERAGE, MAX and MIN. A chart shows data as a picture, and cells can be formatted and sorted. |
| Open the Virtual Lab |
These free Class 9 Information Technology (Code 402) notes explain the electronic spreadsheet, cells rows and columns, cell addresses, formulas and functions like SUM and AVERAGE, and charts with clear steps and practice, for CBSE students across India and the Gulf including the UAE, Saudi Arabia, Qatar, Oman, Kuwait and Bahrain.
© 2026 School Revise. All rights reserved. Original content aligned to the CBSE and NCERT Class 9 Information Technology syllabus. Unauthorised copying is not permitted.
Google