CBSE Class 10/Overview
Curriculum 2026–27
Practice
All Revision Notes
Information TechnologyCh-10 14 min comprehensive revision
CBSE Class 10 IT (402) — Part B: Unit 2 (Electronic Spreadsheet)

Link Data & Spreadsheets (LibreOffice Calc)

Managing multiple sheets (inserting, renaming, deleting), referencing cells across sheets, absolute vs relative sheet references, linking to external data (HTML tables, CSV), and registering external data sources.

Quick Key Takeaways:
Sheet Referencing Syntax: Cell reference across sheets is written as SheetName.CellAddress (e.g. Sheet2.A1 or 'Quarter 1'.B5).
External Data Linking: Sheet → Link to External Data... allows live streaming of HTML tables and CSV web data directly into spreadsheet cells with automatic periodic refresh.
Jump to Concept:1. Multiple Sheets & Referencing2. Hyperlinks & Linking to External Data
1

Multiple Sheets & Referencing

Workbook Arch

Working with multi-tab workbooks to organize complex departmental or temporal data.

• Sheet Management
Insert via Sheet → Insert Sheet (or click + tab icon). Rename via Right-click tab → Rename Sheet. Delete via Right-click → Delete Sheet.
• Cross-Sheet Referencing Methods
1. By Keyboard: Enter =Sheet2.B4 or ='Sales Summary'.C10; 2. By Mouse: Type = in formula cell, navigate to target tab, click cell, press Enter.
• Absolute vs Relative Linking
Use $ to lock references: $Sheet1.$A$1 remains constant when copied across rows or columns.
2

Hyperlinks & Linking to External Data

External Link

Connecting spreadsheet cells to external files, websites, and database tables.

• Inserting Hyperlinks
Menu Insert → Hyperlink (Ctrl+K). Types: Internet (URL), Mail (email), Document (file path/target), New Document.
• Link to External Data
Select destination cell → Sheet → Link to External Data... → Enter URL or file path of HTML/CSV table → Select available tables → Set update frequency (e.g. 'Update every 60 seconds') → Click OK.
• Registering Databases in Calc
Tools → Options → LibreOffice Base → Databases → New → Browse .odb file → Register. Press F4 in Calc to view registered data sources.
Authentic Board Question (3 Marks)Topic: Link Data & Spreadsheets (LibreOffice Calc) LibreOffice Menu Path & Practical Workflow
Write the step-by-step practical procedure, menu path, and configuration settings in LibreOffice for "Link Data & Spreadsheets (LibreOffice Calc)".

Official CBSE Step-by-Step Marking Breakdown:

Step 1: Exact Menu Navigation Pathway: State the precise menu sequence (e.g., Data -> Consolidate, Tools -> Scenarios, Format -> Styles and Formatting).
1 Mark
Step 2: Dialog Box Settings & Parameters: Specify the required input fields, source ranges, target cells, or style properties in the dialog window.
1 Mark
Step 3: Execution, Document Result & Shortcuts: Describe the resulting change in the document/sheet and provide the official keyboard shortcut (e.g., F11, Ctrl+F10).
1 Mark
Model Student Answer (Target: Full 3/3 Marks):
To score full 3 marks on "Link Data & Spreadsheets (LibreOffice Calc)" in CBSE IT (402):

1. GUI Menu Pathway: Menu →\to Submenu →\to Tool Name... (e.g. Data →\to Consolidate).
2. Configuration Steps: In the dialog window, define source ranges, select the mathematical function or style attributes, and choose the output destination.
3. Application & Verification: Click OK to apply changes. Confirm the updated formatting, scenario switch, or consolidated summary.
Examiner Mark Deduction Traps:
•Always write menu paths using arrows: Main Menu -> Submenu -> Command.
•Mention standard shortcut keys where applicable to demonstrate practical lab mastery.

High-Frequency Conceptual Doubts & FAQs

Curated answers to the most common questions asked by Class 10 students.
This chapter establishes the foundational principles, definitions, and operational workflows required for Class 10 board mastery.

Next Learning Steps & Active Practice

You have completed the revision notes. Now apply, test, and evaluate your understanding.
Notes Completed