Computer

Introduction to Spreadsheets

Class 4

🎯 Learning Objectives

Know what a spreadsheet is and what MS Excel is used for.
Understand rows, columns, and cells in a spreadsheet.
Learn how to enter data in cells.
Use a simple addition formula: =A1+B1.
Know real-life uses of spreadsheets.

📖 Let Us Begin!

Arjun's father runs a small shop in Pune. He keeps a record of all his sales in a notebook — items sold, prices, and totals. One day, Arjun showed him how to do the same thing on the computer using Microsoft Excel. The computer could even add up all the numbers automatically!

A spreadsheet is a program that organises data in rows and columns, like a table. It can also do calculations for you. Let us learn how it works.

What is a Spreadsheet?

A spreadsheet is a computer program that organises data in a grid of rows and columns. Microsoft Excel (MS Excel) is the most popular spreadsheet program.

Think about it: A spreadsheet is like a very smart table. You can enter numbers, and it can add, subtract, multiply, and divide them for you automatically!

Rows, Columns, and Cells

The spreadsheet is made up of a grid. Understanding this grid is the first step.

Term	What it is	How it is named
Row	A horizontal line of boxes going left to right	Numbered: Row 1, Row 2, Row 3...
Column	A vertical line of boxes going up and down	Named with letters: Column A, Column B, Column C...
Cell	A single box where a row and column meet	Named by column letter + row number: A1, B2, C3...

Cell Names

Cell A1 = Column A, Row 1 (top-left cell)

Cell B3 = Column B, Row 3

Cell C2 = Column C, Row 2

The cell you are currently working in is called the active cell. It is highlighted with a border.

Entering Data in Cells

How to Enter Data

Step 1: Click on a cell (e.g., cell A1).

Step 2: Type your data (a number, word, or formula).

Step 3: Press Enter to move to the next row, or press Tab to move to the next column.

You can enter text (like names), numbers (like marks), or formulas (like =A1+B1).

Simple Formulas

A formula in Excel always starts with the = (equals) sign. It tells Excel to calculate something.

Addition Formula Example

Suppose cell A1 has the number 45 (Ravi's Maths marks) and cell B1 has 38 (Ravi's Science marks).

To find the total, click on cell C1 and type: =A1+B1

Press Enter. Excel will show 83 in cell C1 automatically!

If you change the number in A1 or B1, the total in C1 updates automatically too.

Formula	What it does	Example
=A1+B1	Adds the values in A1 and B1	=45+38 gives 83
=A1-B1	Subtracts B1 from A1	=50-20 gives 30
=A1*B1	Multiplies A1 and B1	=5*6 gives 30
=SUM(A1:A5)	Adds all values from A1 to A5	Adds five numbers at once

Uses of Spreadsheets

Use	Example
Marks table	Meena's teacher records all students' marks in Excel
Expense list	Arjun's father tracks shop expenses in a spreadsheet
Timetable	Sita makes her weekly study timetable in Excel
Shopping list	Ravi's mother lists items and prices for monthly shopping

📝 Key Words

Word	Meaning
Spreadsheet	A program that organises data in rows and columns
MS Excel	Microsoft Excel — the most popular spreadsheet program
Row	A horizontal line of cells in a spreadsheet
Column	A vertical line of cells in a spreadsheet
Cell	A single box in a spreadsheet where data is entered
Formula	An instruction starting with = that tells Excel to calculate
Active Cell	The currently selected cell, highlighted with a border

⭐ Key Points to Remember

A spreadsheet organises data in rows and columns.
MS Excel is the most popular spreadsheet program.
Rows are horizontal (numbered 1, 2, 3...). Columns are vertical (named A, B, C...).
A cell is named by its column letter and row number (e.g., A1, B3).
Formulas in Excel always start with the = sign.
=A1+B1 adds the values in cells A1 and B1.
Spreadsheets are used for marks tables, expense lists, and timetables.

✏️ Practice Questions

A. Fill in the Blanks

1. A spreadsheet organises data in and .

2. The most popular spreadsheet program is .

3. Rows are numbered and columns are named with .

4. A formula in Excel always starts with the sign.

5. The formula to add cells A1 and B1 is .

B. Multiple Choice Questions

1. What is a cell in a spreadsheet?

(a) A row(b) A column(c) A single box where row and column meet

2. Cell B3 is in which column?

(a) Column A(b) Column B(c) Column C

3. Which formula adds the values in cells A1 and B1?

(a) A1+B1(b) =A1+B1(c) SUM A1 B1

C. Short Answer

1. What is a spreadsheet? Name one program used for spreadsheets.

2. What is the difference between a row and a column?

3. Write two uses of spreadsheets in daily life.

Make a Marks Table!

Open MS Excel. Create a marks table for 5 students in your class. Use these columns: Name (Column A), Maths (Column B), English (Column C), Total (Column D).

Enter marks for each student. In Column D, use the formula =B2+C2 (and so on for each row) to calculate the total automatically.

In your notebook, draw the table and write the formula you used.

Want to use this as a worksheet? Switch to the A4 printable view.

Learning Objectives

Know what a spreadsheet is and what MS Excel is used for.
Understand rows, columns, and cells.
Use a simple addition formula: =A1+B1.

What is a Spreadsheet?

A spreadsheet is a computer program that organises data in a grid of rows and columns. Microsoft Excel (MS Excel) is the most popular spreadsheet program. It can store data and do calculations automatically.

Rows, Columns, and Cells

Term	What it is	How it is named
Row	Horizontal line of boxes (left to right)	Numbered: 1, 2, 3...
Column	Vertical line of boxes (up and down)	Letters: A, B, C...
Cell	A single box where row and column meet	Column + Row: A1, B2, C3...

Simple Formulas

A formula in Excel always starts with the = sign.

Example: Cell A1 has 45 (Maths marks), Cell B1 has 38 (Science marks).

Type =A1+B1 in cell C1. Press Enter. Excel shows 83 automatically!

If you change A1 or B1, the total in C1 updates automatically.

Formula	What it does
=A1+B1	Adds the values in A1 and B1
=A1-B1	Subtracts B1 from A1
=SUM(A1:A5)	Adds all values from A1 to A5

Uses of Spreadsheets

Marks table, expense list, timetable, shopping list with prices.

Key Words

Word	Meaning
Spreadsheet	A program that organises data in rows and columns
MS Excel	Microsoft Excel -- the most popular spreadsheet program
Cell	A single box in a spreadsheet where data is entered
Formula	An instruction starting with = that tells Excel to calculate

Key Points to Remember

A spreadsheet organises data in rows and columns.
MS Excel is the most popular spreadsheet program.
Rows are horizontal (numbered 1, 2, 3...). Columns are vertical (named A, B, C...).
A cell is named by its column letter and row number (e.g., A1, B3).
Formulas in Excel always start with the = sign.
=A1+B1 adds the values in cells A1 and B1.

A. Fill in the Blanks

A spreadsheet organises data in and .
The most popular spreadsheet program is .
Rows are numbered and columns are named with .
A formula in Excel always starts with the sign.
The formula to add cells A1 and B1 is .

B. Multiple Choice Questions

What is a cell in a spreadsheet?
(a) A row(b) A column(c) A single box where row and column meet
Cell B3 is in which column?
(a) Column A(b) Column B(c) Column C
Which formula adds the values in cells A1 and B1?
(a) A1+B1(b) =A1+B1(c) SUM A1 B1

C. Short Answer

What is a spreadsheet? Name one program used for spreadsheets.
What is the difference between a row and a column?
Write two uses of spreadsheets in daily life.

Make a Marks Table!

Draw a spreadsheet table in the box below. Add 3 students (Ravi, Meena, Sita), their Maths marks, English marks, and a Total column. Write the formula you would use to calculate the total.

Name (A)	Maths (B)	English (C)	Total (D)
Ravi
Meena
Sita

Formula used in Total column:

Introduction to Spreadsheets

🎯 Learning Objectives

📖 Let Us Begin!

What is a Spreadsheet?

Rows, Columns, and Cells

Entering Data in Cells

Simple Formulas

Uses of Spreadsheets

📝 Key Words

✏️ Practice Questions

Computer Science -- Class 4

Computer Science -- Class 4 (continued)