📊 Spreadsheet Revision

Grade IX Information Technology

Complete Revision of Spreadsheet Concepts

Learning Objectives

Revise all spreadsheet concepts learned so far.
Recall formulas and functions.
Understand cell referencing.
Practice formatting and data entry.
Prepare for practical and theory examinations.

Topics Covered

Unit	Concept
Spreadsheet Basics	Workbook, Worksheet, Rows, Columns, Cells
Cell Referencing	Relative, Absolute, Mixed
Data Entry	Fill Handle, Auto Fill
Operators	+, −, *, /, ^
Functions	SUM, AVERAGE, COUNT, MAX, MIN
Formatting	Fonts, Alignment, Borders, Cell Colour
Charts	Bar, Pie, Column, Line Charts
Sorting & Filtering	Ascending, Descending, Filter Records

Important Spreadsheet Functions

Function	Example	Purpose
SUM()	`=SUM(B2:B10)`	Adds numbers
AVERAGE()	`=AVERAGE(B2:B10)`	Calculates average
COUNT()	`=COUNT(B2:B10)`	Counts numeric cells
MAX()	`=MAX(B2:B10)`	Largest value
MIN()	`=MIN(B2:B10)`	Smallest value

Types of Cell Referencing

Reference	Example	Meaning
Relative	A1	Changes automatically
Absolute	$A$1	Never changes
Mixed	$A1 or A$1	One part remains fixed

Quick Formula Practice

Write formulas for the following:

Total Marks
Average Marks
Highest Marks
Lowest Marks
Count Students

Practical Activity

Create a spreadsheet for five students with the following columns:

Roll Number
Name
English
Science
Mathematics
Total
Average
Highest Marks

Apply formatting, use the Fill Handle, and create a Column Chart.

Examination Tips

✔ Always begin formulas with =.
✔ Double-check cell references.
✔ Save your workbook regularly.
✔ Read function names carefully.
✔ Practice with real datasets.

Quick Quiz

What is the difference between a workbook and a worksheet?
Which function finds the average?
Which reference remains fixed?
What does the Fill Handle do?
Name any two chart types.

Learning Outcomes

Students revise all spreadsheet concepts.
Students confidently use formulas and functions.
Students understand referencing techniques.
Students are prepared for practical examinations.

⬅ Back to Grade IX