Chapter 2: Electronic Spreadsheet (Advanced) using LibreOffice Calc

Important questions — the ones the board asked most (11)

1. Q1Short answer4 marksAsked: 2026

   18. Mr. Prasanna, a General Manager in a multinational company, has been given two spreadsheets : an original billing file Bill.ods and a reviewed version of the same spreadsheet Rev_Bill.ods. Both contain customer billing details prepared by different teams. Write the steps he should follow to compare these worksheets and identify the differences between them.

   

   Medha Ma’am

   AskMedha’s AI teacher

   Watch it on the board · 50 s

   Model answer · Comparing documents in Calc

   1. 1.Open the reviewed spreadsheet, Rev_Bill.ods, in LibreOffice Calc.1 mark
   2. 2.Select Edit > Track Changes > Compare Document.1 mark
   3. 3.In the dialog box, select the original file, Bill.ods, and click Open/Insert.1 mark
   4. 4.Calc compares the sheets, marks the differences with coloured change marks and lists them in the Manage Changes dialog, where each can be accepted or rejected.1 mark

   Marks split as in the board’s published marking scheme

2. Q2Short answer4 marksAsked: 2023

   Distinguish between the following with respect to spreadsheets : (a) Relative and Absolute hyperlink. (b) Internet hyperlink and Document hyperlink.

   

   Medha Ma’am

   AskMedha’s AI teacher

   Hear it from Medha Ma’am · 110 s

   Model answer · hyperlinks in spreadsheet

   1. 1.A relative hyperlink stores the location with respect to the current location. For example, Admin\Downloads\try.ods is a relative hyperlink as it is dependent on the current location and thus the folder admin is searched where the active spreadsheet is being stored. If the complete folder containing the active spreadsheet is moved, the relative link will still be accessible as it is bound to the source folder where the active spreadsheet is stored.1 mark
   2. 2.An absolute hyperlink stores the complete location where the file is stored, giving the full path or URL of the file. For example, C:\Users\ADMIN\Downloads\try.ods is an absolute link as it defines the complete path of the file. So, if the file is removed from the location, the absolute hyperlink will not work, whereas a relative path still works if the source folder is moved.1 mark
   3. 3.An internet hyperlink is used to link to web pages or external websites. Internet is a rich source of information, which is stored in the form of web pages, and these web pages are written in HTML documents, so an internet hyperlink points to a URL of such an external website.1 mark
   4. 4.A document hyperlink is used to navigate to a specific part of the same spreadsheet or another local file. It is possible to jump from a sheet in the same spreadsheet, a different spreadsheet or a website by creating such a hyperlink, and the Target in Document option helps to specifically choose a target in the document such as a sheet, table, frame, image or heading for navigation, instead of using a URL.1 mark

   • Write the exact example path 'C:\Users\ADMIN\Downloads\try.ods' for absolute hyperlink and 'Admin\Downloads\try.ods' for relative hyperlink to show full path vs relative path.
   • Mention that internet hyperlink links to web pages/external websites using a URL, while document hyperlink navigates within the same spreadsheet or another local file.
   • State clearly that moving the folder breaks an absolute hyperlink but not a relative hyperlink.

   Marks split from a structure derived from past papers (checked twice); not CBSE’s official scheme

3. Q3Long answer4 marksAsked: 2025

   Mr Amit, the Sales Manager of ABC Sales Corporation, has used a spreadsheet in LibreOffice Calc which lists the sales in different regions in different years in different worksheets. He wants to summarise it and take some decisions based on it. Help him by answering the following questions : (a) Which tool in Calc can be used to combine the sales data of different sheets into a single summary sheet ? (b) Name the menu option and sub-menu option which can be used to prepare a combined summary of all the worksheets. (c) Name the function which can be used to display the total of all the sales. (d) He wants to open a summary document stored at a different location from within the sheet by clicking on the text stored in a cell. How can this be done ?

   

   Medha Ma’am

   AskMedha’s AI teacher

   Hear it from Medha Ma’am · 110 s

   Model answer · Consolidating data, linking sheets

   1. 1.(a) The Consolidate function (Consolidate data tool) in Calc combines the sales data of different sheets into a single summary sheet. It combines information from two or more sheets into one, so the data can be viewed and compared in one sheet.1 mark
   2. 2.(b) The menu option is Data and the sub-menu option is Consolidate (Data > Consolidate). Mr Amit can add a new sheet for the summary, then click Data > Consolidate. In the dialog box he chooses a function and adds the source data ranges from each worksheet.1 mark
   3. 3.(c) The Sum() function displays the total of all the sales. In the Consolidate dialog box, Sum is chosen in the Function box so that the sales from all the sheets are added together.1 mark
   4. 4.(d) This can be done by creating a hyperlink on the text in the cell. The hyperlink points to the summary document saved at the other location. When Mr Amit clicks the text in the cell, the summary document opens.1 mark

   • For (b), write both the menu and the sub-menu: "Data > Consolidate".
   • For (d), write the word "hyperlink" and say that clicking the text in the cell opens the summary document.

   Marks split as in the board’s published marking scheme

4. Q4Short answer4 marksAsked: 2024

   Explain four types of hyperlinks that can be applied in spreadsheets.

   How the model answer begins

   1. A hyperlink lets us jump to a document stored at a different location from within a document. Four types of hyperlinks used in a spreadsheet are: (i) Absolute hyperlink: It stores the complete location where the file is…

   The full answer from Medha Ma’am →
5. Q5Short answer2 marksAsked: 2026

   Briefly explain the purpose of the Subtotal tool in the LibreOffice Calc software.

   How the model answer begins

   1. The Subtotal tool groups the data and automatically calculates summary results such as sum, average or count for each group.

   The full answer from Medha Ma’am →
6. Q6Short answer2 marksAsked: 2026

   Give any two prerequisites before consolidating data in Calc.

   How the model answer begins

   1. The data in each sheet should be arranged in the same layout — the same column headings in the same order.

   The full answer from Medha Ma’am →
7. Q7Very short answer2 marksAsked: 2023

   Why do we need to merge worksheets ?

8. Q8Short answer2 marksAsked: 2025

   What is a Macro ? Give any two rules that should be followed while naming a Macro or module in Calc.

   How the model answer begins

   1. A Macro is a group of instructions executing a single instruction. The actions recorded by a macro are stored as instructions in a programming language called BASIC. These instructions are executed when the macro is…

   The full answer from Medha Ma’am →
9. Q9Short answer2 marksAsked: 2025

   What is the main purpose of Goal Seek in Calc ? Give an example to support your answer.

   How the model answer begins

   1. The main purpose of Goal Seek in LibreOffice Calc is to help in finding out the input for the specific output. It works in reverse order, doing a backward calculation: we give the desired result in the Target value box,…

   The full answer from Medha Ma’am →
10. Q10Short answer2 marksAsked: 2024

    What is the purpose of consolidating data in spreadsheets ? Discuss briefly.

11. Q11Short answer2 marksAsked: 2024

    What are the two parts of a cell reference while referencing data on other sheets ? Explain with an example.

Objective questions with the board’s key (10)

1. 1. CBSE 2026

   Ravi is analysing monthly sales data in Calc. He wants to test how changing the discount rate affects total revenue. Which feature should he use to simulate different outcomes ?

   • (A) Sort
   • (B) Indexing
   • (C) What-if Scenarios ✓
   • (D) Filter

   Answer: (C)

2. 2. CBSE 2026

   While reviewing a shared spreadsheet, Priya notices that some cells have been modified, but she’s unsure who made the changes. Which feature should she use to identify the editor ?

   • (A) Data Validation
   • (B) Track Changes ✓
   • (C) Observe Changes
   • (D) AutoFilter

   Answer: (B)

3. 3. CBSE 2026

   Which of the following is the correct way to record a macro in LibreOffice Calc?

   • (A) Tools → Macros → Record Macro ✓
   • (B) File → Options → Record Macro
   • (C) Insert → Macro → Record
   • (D) View → Macros → Record

   Answer: (A)

4. 4. CBSE 2026

   When the Consolidate dialog box opens in LibreOffice Calc, which of the following is the default function?

   • (A) Average
   • (B) Sum ✓
   • (C) Max
   • (D) Var

   Answer: (B)

5. 5. CBSE 2026

   Which Calc feature allows multiple users to suggest modifications while preserving the original data ?

   • (A) Protect Sheet
   • (B) Share Document
   • (C) Track Changes ✓
   • (D) Insert Comments

   Answer: (C)

6. 6. CBSE 2026

   In Calc, which of the following type of hyperlink uses the complete location where the file to be linked is stored?

   • (A) Absolute hyperlink ✓
   • (B) Mixed hyperlink
   • (C) Relative hyperlink
   • (D) Static hyperlink

   Answer: (A)

7. 7. CBSE 2025

   To add your own comments in Calc, select __________ → Track changes → Comment.

   • (A) File
   • (B) Edit ✓
   • (C) Insert
   • (D) Data

   Answer: (B)

8. 8. CBSE 2025

   To add a new sheet in the spreadsheet, click on the __________ sign located at the left bottom of the spreadsheet.

   • (A) *
   • (B) 
   • (C) %
   • (D) + ✓

   Answer: (D)

9. 9. CBSE 2025

   __________ is a set of values that can be used within the calculations in the spreadsheet to explore and compare various alternatives depending on changing conditions.

   • (A) Sort
   • (B) Filter
   • (C) What-if Scenarios ✓
   • (D) Comments

   Answer: (C)

10. 10. CBSE 2025

    Which creating a hyperlink in calc, if the complete path along with filename is given then it is an example of _________.

    • (A) Relative hyperlink
    • (B) Mixed hyperlink
    • (C) Absolute hyperlink ✓
    • (D) Folder hyperlink

    Answer: (C)

Questions parents and students ask

How many marks does "Electronic Spreadsheet (Advanced) using LibreOffice Calc" carry in CBSE Class 10 Information Technology?

In the CBSE papers of 2023–2026, this chapter carried about 10 marks and about 8 questions a year; by marks it ranks 2 in Information Technology.

Which are the most important (VVI) questions of "Electronic Spreadsheet (Advanced) using LibreOffice Calc"?

The 11 questions above are from the board’s real papers, each with the years it was asked; the most-asked come first with their full model answers. All 11 written questions of this chapter, with answers, are in the AskMedha app.

Do the answers follow the board’s marking scheme?

Yes. CBSE publishes its marking schemes; every model answer here is written point by point to the marks the board’s own scheme gives, and checked by a second, independent model.