AskMedha

CBSE Class 10 · Information Technology · board exam 2027

Chapter 2: Electronic Spreadsheet (Advanced) using LibreOffice Calc — notes

The chapter’s 8 parts in the book’s order — the first idea of each and the points Medha Ma’am writes on the board — and the summary at the end. The full lesson and a check question for each part are in the app.

This chapter’s important questions →

  1. 1. Consolidating data

    Okay, so, analysing data just means pulling out the useful part of it, so you can decide things better.

    • • Consolidate: combine data from many sheets into one
    • • Check first: data types match, labels match
    • • Data > Consolidate (ALT+D)
    • • Function: Sum (default)
    • • Select range > Add (ABC_Branch, XYZ_Branch)
    • • Options: Row labels, Column labels, Link to source data

  2. 2. Groups and Subtotals

    Okay, so let's talk about groups and subtotals.

    • • Group and Outline: Data > Group and Outline
    • • Subtotal: Data > Subtotals
    • • Group by: Class
    • • Calculate subtotals for: each subject
    • • Use function: Average (else Sum)
    • • Remove: Data > Group and Outline > Remove Outline

  3. 3. What-if Scenarios

    Okay, so let's talk about what-if scenarios.

    • • Scenario: a named set of values
    • • Many scenarios on one sheet
    • • EMI B3: = ABS(PMT(B2/1200,E1*12,B1))
    • • Total Amount B4: = B3*E1*12
    • • Total Interest B8: = B4-B1
    • • Select B1, E1 > Tools > Scenarios > name > OK

  4. 4. What-if Analysis Tool

    Okay, so let's look at the what-if tool now.

    • • Data > Multiple Operations
    • • Two arrays: input values, formula results
    • • B5: = B4 * ( B1 – B2) – B3
    • • Select D2:E11
    • • Formulas: $B$5
    • • Column input cell: $B$4

  5. 5. Goal Seek

    Okay, so usually you type in values, write a formula, and get a result.

    • • Goal Seek: finds input for a specific output
    • • B7: = Average(B2:B6)
    • • Tools > Goal Seek
    • • Formula cell: B7
    • • Variable cell: B6
    • • Target value: 70

  6. 6. Recording and running a macro

    Okay, so let's talk about macros.

    • • Macro: one instruction runs a set of instructions
    • • Enable: Tools > Options > LibreOffice > Advanced
    • • Tools > Macros > Record Macro > Stop Recording
    • • Default: Main, Standard Library, Module1
    • • Name: begins with a letter, no spaces, only _
    • • Run: Tools > Macros > Run Macro

  7. 7. Macro code and macro as a function

    Okay, so, a recorded macro isn't just a click — it's stored as code, in a language called BASIC.

    • • Macro code: BASIC
    • • Sub Name ... End Sub
    • • IDE = Integrated Development Environment
    • • Print "Hello" > run with F5
    • • Function ... End Function: takes arguments, returns result
    • • ' (single quote) starts a comment

  8. 8. Linking spreadsheet data

    Say Term1 and Term2 marks are kept in separate sheets.

    • • Add sheet: (+) or Sheet > Insert Sheet
    • • Result C4: (Term1 + Term2)/2
    • • Other sheet: $‛Term 1’.C4
    • • Other file: ‘file:///C:/Users/ADMIN/Documents/X-A.ods’# $Result.C4
    • • Insert Sheet > From File > tick Link
    • • Linked = live data

Summary

Okay, so let's look back at everything we covered. First, you learned to analyse data in LibreOffice Calc. Consolidate combines several sheets into one. Subtotals groups your data and applies functions like Sum or Average to it. Then, you saw what-if scenarios — they let you compare named sets of values, like different loan amounts and years. The Multiple Operations tool shows you the result of a formula for a whole list of inputs at once. Goal Seek does the opposite — it works backwards, to find the input that gives you the output you want. After that, you learned to record, name, and run macros. You also looked at their BASIC code, and wrote a macro as a function, between Function and End Function. Finally, you linked data across sheets and files, using references like $'Term 1'.C4, with linked sheets that keep the data live. So — out of all this, which tool do you think would save you the most time in your own work?

AskMedha · Medha Ma’am — CBSE Class 10 Information Technology, Chapter 2. Written from the textbook, checked twice.

Questions parents and students ask

How do I get the "Electronic Spreadsheet (Advanced) using LibreOffice Calc" notes as a PDF?
Press "Save as PDF" — the phone’s print sheet opens; choose "Save as PDF" there. The PDF holds the notes only.
Where are these notes written from?
From the chapter’s own textbook text, part by part, in the book’s own terms; a second, independent model then checked every part against the book. The full lesson, a check question for each part and the practice are in the AskMedha app.

The same preparation, with Medha Ma’am — on your phone

Every question of every chapter with its model answer, practice questions in the board’s own shapes, 60 minutes of class a day, written answers marked, a test every Sunday and a WhatsApp report to parents.

StartAbout the course

Medha Ma’am is an AI teacher, not a live tutor. Every answer is checked twice; a person takes responsibility.