Part B – Unit 4: Electronic Spreadsheet (LibreOffice Calc)
This unit introduces Electronic Spreadsheets using LibreOffice Calc. It covers worksheets, cells, formulas, functions, formatting, and data management.
1. Electronic Spreadsheet
Definition
An Electronic Spreadsheet is a software application used to organize, calculate, analyze, and present data in tabular form.
Examples
LibreOffice Calc
Uses
Maintaining records
Budget preparation
Mark sheets
Salary calculations
Data analysis
2. Spreadsheet Software
Definition
Spreadsheet software helps users perform calculations, organize data, and create charts.
Features
✅ Data storage
✅ Calculations
✅ Data analysis
✅ Chart creation
✅ Data sorting
✅ Data filtering
3. LibreOffice Calc
Definition
LibreOffice Calc is the spreadsheet application of LibreOffice Suite.
Uses
Creating worksheets
Applying formulas
Managing records
Preparing reports
Creating charts
4. Components of Calc Window
A. Title Bar
Displays workbook name.
B. Menu Bar
Contains menus such as:
File
Edit
View
Insert
Format
Sheet
Data
Tools
C. Standard Toolbar
Contains common commands.
Examples
New
Open
Save
Print
Undo
Redo
D. Formula Bar
Used to enter and edit data or formulas.
E. Worksheet Area
Main area where data is entered.
F. Sheet Tabs
Used to switch between worksheets.
G. Status Bar
Displays information about current worksheet.
5. Workbook and Worksheet
Workbook
A workbook is a spreadsheet file containing one or more worksheets.
Example
StudentResult.ods
Worksheet
A worksheet is a single spreadsheet page within a workbook.
6. Rows and Columns
Row
Horizontal arrangement of cells.
Identification
Rows are identified by numbers.
Examples: 1, 2, 3, 4...
Column
Vertical arrangement of cells.
Identification
Columns are identified by letters.
Examples: A, B, C, D...
7. Cell
Definition
A cell is the intersection of a row and a column.
Examples
A1
B5
C10
D7
Active Cell
The currently selected cell where data can be entered.
8. Cell Address
Definition
A cell address identifies the location of a cell.
Formula
Column Name + Row Number
Examples
A1
B2
C5
D10
9. Data Types in Spreadsheet
A. Label (Text)
Contains letters or text values.
Example
Ravindra
Computer
B. Value (Number)
Contains numerical data.
Example
100
2500
75
C. Formula
Used to perform calculations.
Example
= A1+A2
10. Entering Data
Steps
Select a cell.
Type data.
Press Enter.
11. Editing Data
Methods
Double-click cell.
Press F2.
Edit through Formula Bar.
12. Formatting Data
Formatting improves appearance of worksheet data.
Font Formatting
Options
Font Style
Font Size
Font Color
Text Formatting
Bold
Shortcut: Ctrl + B
Italic
Shortcut: Ctrl + I
Underline
Shortcut: Ctrl + U
13. Adjusting Rows and Columns
Change Column Width
Used when data does not fit properly.
Steps
Select column.
Drag column boundary.
Change Row Height
Steps
Select row.
Drag row boundary.
14. Formula
Definition
A formula is an expression used to perform calculations.
Rule
All formulas begin with an equal sign (=).
Examples
Addition
=A1+A2
Subtraction
=A1-A2
``
Multiplication
=A1*A2
Division
=A1/A2
15. Operators in Calc
16. Functions
Definition
Functions are predefined formulas used to perform calculations quickly.
SUM Function
Adds values.
Syntax
=SUM(A1:A5)
Example
Adds numbers from A1 to A5.
AVERAGE Function
Calculates average value.
Syntax
=AVERAGE(A1:A5)
MAX Function
Finds highest value.
Syntax
=MAX(A1:A5)
MIN Function
Finds smallest value.
Syntax
=MIN(A1:A5)
COUNT Function
Counts numerical entries.
Syntax
=COUNT(A1:A5)
17. Cell Range
Definition
A group of cells is called a range.
Examples
A1:A10
B1:B5
C2:F8
18. Relative Cell Reference
Definition
Cell reference changes automatically when copied.
Example
=A1+B1
When copied to next row:
=A2+B2
19. Sorting Data
Definition
Sorting arranges data in a specific order.
Types
Ascending Order
A to Z
Smallest to Largest
Descending Order
Z to A
Largest to Smallest
20. Filtering Data
Definition
Filtering displays only selected records and hides others.
Benefits
Easy analysis
Quick retrieval
Better data management
21. Charts
Definition
Charts are graphical representations of data.
Importance
Easy understanding
Better presentation
Quick analysis
Types of Charts
Column Chart
Represents data using vertical bars.
Bar Chart
Represents data using horizontal bars.
Pie Chart
Represents parts of a whole.
Line Chart
Shows trends over time.
22. Printing Spreadsheet
Steps
Click File.
Select Print.
Choose Printer.
Click Print.
Shortcut
Ctrl + P
Important Definitions for Exam
Spreadsheet
A software application used to organize and calculate data.
Workbook
A spreadsheet file containing worksheets.
Worksheet
A single spreadsheet page.
Cell
Intersection of a row and a column.
Formula
Expression used for calculations.
Function
Predefined formula used for calculations.
Cell Range
A group of selected cells.
Chart
Graphical representation of data.
Important One-Line Questions
What is an electronic spreadsheet?
What is LibreOffice Calc?
Define workbook.
Define worksheet.
What is a cell?
What is a cell address?
What is a formula?
What is a function?
What is sorting?
What is filtering?
Important Functions
Important Shortcut Keys
Quick Revision Points
✅ LibreOffice Calc is used for spreadsheet management.
✅ A workbook contains one or more worksheets.
✅ Rows are numbered and columns are lettered.
✅ Cell address is column name + row number.
✅ Formulas always begin with "=".
✅ Functions are predefined formulas.
✅ Important functions: SUM, AVERAGE, MAX, MIN, COUNT.
✅ Sorting arranges data in ascending or descending order.
✅ Filtering displays selected records only.
✅ Charts help present data graphically.
✅ Cell ranges are represented as A1:A10.
Exam Tip
Most Important Topics from Unit 4 (Part B)
LibreOffice Calc Interface
Workbook and Worksheet
Rows, Columns, Cells
Cell Address and Cell Range
Data Types
Formula and Formula Operators
SUM(), AVERAGE(), MAX(), MIN(), COUNT()
Sorting and Filtering
Charts and Their Types
These topics are frequently asked in MCQs, Practical Exams, Viva Questions, Competency-Based Questions, and Theory Exams in Class 9 Information Technology (402).

Comments
Post a Comment