ELECTRONIC
SPREADSHEET
1. NEED FOR CALCULATIONS IN DAILY LIFE
• Simple calculations: done mentally or using fingers.
• Longer calculations: calculator is used.
• Complex scientific/engineering calculations: scientific calculators.
• Spreadsheet software: a tool that performs all kinds of calculations easily, quickly, and accurately.
• 2. What is a Spreadsheet?
• A grid of rows and columns on a computer screen.
• Used to organize, analyze, and calculate data.
• Also called Electronic Spreadsheet.
• Similar to a notebook with small cells used in childhood for practicing mathematics.
• Uses of Spreadsheet:
• Managing financial and accounting documents.
• Preparing data reports.
• Generating invoices.
• Data analysis in science and statistics.
• Performing mathematical, financial, logical operations.
• Universal tool for structured data preparation and processing.
• 3. Features of Spreadsheet Software
• Store, manipulate, and represent data graphically.
• Enter, format, calculate, and analyze data.
• Provide built-in formulae and functions for common operations.
• Support decision making.
• Allow use of workbooks to manage large data.
• 4. Activities Possible in LibreOffice Calc
• Tabulation of data.
• Simple and complex calculations using formulas and functions.
• Sorting (ascending/descending).
• Filtering data.
• Checking validity of data.
• Protecting data with passwords.
• Saving data for future use.
• 5. Popular Spreadsheet Software
• Microsoft Excel
• LibreOffice Calc
• OpenOffice Calc
• Apple Numbers
• Starting LibreOffice Calc
• In Windows:
• Open from Start Menu or Desktop Shortcut.
• Or click Windows Menu → LibreOffice → Calc.
• In Linux (Ubuntu):
• LibreOffice is pre-installed.
• Find the Calc icon in Application Launcher.
• Or click Show Applications → Calc.
MAIN COMPONENTS OF CALC
•Title bar
•At the top.
•Shows the name of the current spreadsheet (Untitled 1, Untitled 2… until saved).
•Menu bar
•Just below Title bar.
•Contains menus (File, Edit, View, Insert, Format, Styles, Sheet, Data, Tools, Window, Help).
•Each has submenus (e.g., File → Save, Print, Export as PDF).
•Toolbars
•Standard toolbar – icons for common operations (open, save, cut, copy, paste, undo, redo, etc.).
•Formatting toolbar – font, size, alignment, cell formatting.
•Formula toolbar – has:
•Name box (cell reference, e.g., A1).
•Functions wizard.
•Sum tool.
•Function (= sign).
•Input line (displays/edits content of selected cell).
•Worksheet
•Also called spreadsheet.
•Multiple sheets (Sheet1, Sheet2, …).
•Made of rows and columns.
•Rows and Columns
•Rows: horizontal, numbered 1 → 1,048,576.
•Columns: vertical, lettered A → AMJ (1024 columns).
•Cell & Cell Address
•Intersection of row & column = cell.
•Example: D4 (Column D, Row 4).
•Active cell = the currently selected cell (shown with bold border).
•Range of Cells
•Block of adjacent cells.
•Types:
•Column range: e.g., C2:C7 → (C2, C3, C4, C5, C6, C7).
•Row range: e.g., B3:D3 → (B3, C3, D3).
•Row & Column (matrix) range: e.g., B2:C7 → rectangular block.
• Keyboard Shortcuts for Navigation
• Arrow keys → move one cell.
• Ctrl + Arrow → jump to end of data in that direction.
• Home → first column in row.
• Ctrl + Home → first cell (A1).
• Ctrl + End → last used cell.
• Page Up / Down → scroll screen.
• Practice Question (Cell Addresses)
• First row & first column → A1
• First column & last row → A1048576
• First row & last column → AMJ1
• Last column first row → AMJ1 (same as above).
• Seventh column & tenth row → G10
• Tenth column & nineteenth row → J19
• LK89 → Row 89, Column LK
ENTERING DATA IN A WORKSHEET (CALC)
Before entering data, the cell must be selected. Data entered can be of three types:
(a) Label
•Any text entered using the keyboard.
•May include letters, numbers, special symbols.
•Default alignment: Left-aligned.
•Example: Name, Roll No., Sales-2025.
(b) Values
•Numerical data consisting only of numbers.
•Can be integers, decimals, percentages, etc.
•Default alignment: Right-aligned.
•Example: 250, 45.6, 1000.
(c) Formulae
•Any expression starting with an equals (=) sign.
•Can include values, cell addresses, operators, functions.
•When entered:
•The result is shown in the cell.
•The formula itself is displayed in the Formula Bar.
•Example:
•=10+5 → displays 15.
•=A1+B1 → displays sum of values in cells A1 and B1.
•NOTE
•By default, numerical values do not display any preceding zero (0).
•Example: If you type a telephone number like 0987654321 in a cell,
Calc will automatically remove the first 0 and display it as 987654321.
Solution: To display numbers with a leading zero (like phone numbers, PIN codes, roll numbers, etc.), the data type
must be set to “Text” instead of “Value.”
MATHEMATICAL OPERATORS USED IN FORMULAE
•A formula is an expression used to perform calculations.
•Every formula begins with an equal (=) sign.
•Example: =A1+B1 adds the values of cells A1 and B1.
•Formulas can contain:
•Operands (numbers, cell references)
•Operators (+, -, *, /, ^)
•Types of operators:
•Arithmetic operators: +, -, *, /, ^
•Comparison operators: =, <, >, <=, >=, <>,!=
•Text concatenation operator: &
•Reference operator: : (range)
3. Functions
•Functions are predefined formulas that perform specific tasks automatically.
•Functions save time and reduce errors.
•All functions begin with = and use parentheses () to enclose arguments.
Example: =SUM(A1:A5) adds values from A1 to A5.
Commonly used functions:
[Link]() – Adds numbers.
Example: =SUM(B2:B5)
[Link]() – Finds the mean value.
Example: =AVERAGE(C1:C4)
[Link]() – Finds the largest number.
[Link]() – Finds the smallest number.
[Link]() – Counts the number of numeric entries.
[Link]() – Checks a condition and returns a value based on TRUE/FALSE.
Example: =IF(A1>=33,"Pass","Fail")
4. Cell Referencing
•Cell reference indicates the location of data used in a formula.
•Types of cell references:
[Link] Reference: Changes when copied to another cell (e.g., A1).
[Link] Reference: Remains constant; uses $ (e.g., $A$1).
[Link] Reference: One part fixed, one part changes (e.g., $A1 or A$1).
• 5. Fill Handle or speeding up the data entry
• The fill handle is a small square at the bottom-right corner of a selected cell.
• It helps copy formulas or continue a series (e.g., days, numbers).
• When dragged, Calc automatically adjusts relative references.
6. Formatting Cells (ctrl+1 )
•Formatting improves the appearance of data.
•Common formatting features:
•Changing font, size, color
•Aligning text (left, right, center)
•Applying borders and shading
•Formatting numbers, currency, and dates
•To format cells:
•Select the cell → Choose Format > Cells or use the Formatting toolbar.
7. AutoSum and Function Wizard
•AutoSum (Σ) button automatically adds a range of numbers.
•Function Wizard (Insert → Function) helps choose and insert functions easily.
8. Error Indicators in Formulas
•Common errors in spreadsheets:
•#DIV/0! – Division by zero.
•#NAME? – Function name is misspelled.
•#VALUE! – Wrong data type.
•#REF! – Invalid cell reference.
• 9. Importance of Formulas and Functions
• Reduces manual effort and saves time.
• Ensures accuracy and consistency.
• Simplifies large data handling and analysis.
• Allows easy updates—changing one cell updates all dependent formulas.