Unit 4: Electronic Spreadsheet (LibreOffice Calc)


 

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

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

  1. Select a cell.

  2. Type data.

  3. 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

  1. Select column.

  2. Drag column boundary.


Change Row Height

Steps

  1. Select row.

  2. 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

Operator

Purpose

+

Addition

-

Subtraction

*

Multiplication

/

Division

^

Exponent


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

  1. Click File.

  2. Select Print.

  3. Choose Printer.

  4. 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

  1. What is an electronic spreadsheet?

  2. What is LibreOffice Calc?

  3. Define workbook.

  4. Define worksheet.

  5. What is a cell?

  6. What is a cell address?

  7. What is a formula?

  8. What is a function?

  9. What is sorting?

  10. What is filtering?


Important Functions

Function

Purpose

SUM()

Adds values

AVERAGE()

Finds average

MAX()

Finds highest value

MIN()

Finds lowest value

COUNT()

Counts numerical values


Important Shortcut Keys

Shortcut

Function

Ctrl + N

New Workbook

Ctrl + O

Open Workbook

Ctrl + S

Save Workbook

Ctrl + P

Print Workbook

Ctrl + C

Copy

Ctrl + X

Cut

Ctrl + V

Paste

Ctrl + Z

Undo

Ctrl + Y

Redo

F2

Edit Cell


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()

  • Relative Cell Referencing

  • 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