CLASS 7 CHAPTER 5 NOTES

 

📊 Spreadsheet – Class 7 Notes

1. What is a Spreadsheet?

A spreadsheet is a software used to store, organize, calculate and analyze data .

Examples: Microsoft Excel, LibreOffice, Google Sheets.

---

2. What is a Workbook?

A workbook is a spreadsheet file that contains one or more worksheets.

Example: School_Result.xlsx

---

3. What is a Worksheet?

A worksheet is a single working page inside a workbook.

Components of a Worksheet

Component	Meaning
Row	Horizontal arrangement of cells(1,2..,n)
Column	Vertical arrangement of cells(A,B,C…)
Cell	Intersection of a row and a column(A1)
Cell Address	Name of a cell, such as A1 or B5
Active Cell	Currently selected cell
Formula Bar	Displays or allows editing of cell contents
Name Box	Shows the address of the active cell
Sheet Tab	Used to select a worksheet

Cell Address

A cell address is formed using the column letter + row number.

Example:

• A1 → Column A, Row 1
• B5 → Column B, Row 5
• C10 → Column C, Row 10

---

4. Advantages

1. Data can be stored in an organized manner.
2. Calculations can be performed quickly.
3. Formulas can be used to reduce manual calculation.
4. Data can be edited easily.
5. Data can be sorted and filtered.
6. Charts and graphs can be created.
7. Large amounts of data can be managed easily.
8. Changes in data can automatically update formula results.
9. Worksheets can be printed and shared.
10. Multiple worksheets can be stored in one workbook.

---

5. Steps to Create a New Workbook

1. Open Microsoft Excel.
2. Click File.
3. Select New.
4. Click Blank Workbook.

Shortcut

Ctrl + N → Creates a new workbook.

---

6. Important Spreadsheet Shortcut Keys

Shortcut Key	Function
Ctrl + N	Create a new workbook
Ctrl + O	Open a workbook
Ctrl + S	Save a workbook
Ctrl + P	Print a workbook
Ctrl + C	Copy selected data
Ctrl + X	Cut selected data
Ctrl + V	Paste data
Ctrl + Z	Undo the last action
Ctrl + Y	Redo
Ctrl + A	Select all
Ctrl + F	Find data
Ctrl + H	Find and replace
Ctrl + B	bold
Ctrl + I	Make text italic
Ctrl + U	Underline text
Delete	Delete cell contents
F2	Edit the active cell

---

7. Simple and Important Formulas

A formula is an expression used to perform calculations in a spreadsheet.

Every formula begins with an equal sign (=).

Addition

=A1+B1

Subtraction

=A1-B1

Multiplication

=A1*B1

Division

=A1/B1

SUM Function

=SUM(A1:A5)

AVERAGE Function

=AVERAGE(A1:A5)

MAX Function

=MAX(A1:A5)

MIN Function

=MIN(A1:A5)

---

9. How to Save a Workbook

1. Click File.
2. Click Save As.
3. Select the location
4. Type the file name.
5. Click Save.

Shortcut

Ctrl + S → Saves the current workbook.