NCERT GRADE 10

 

   Unit II: Electronic Spreadsheet (Advanced) using LibreOffice Calc

1. What is an electronic spreadsheet?

An electronic spreadsheet is a computer program that helps you enter, store, and calculate data in rows and columns. You can use formulas to do quick calculations and create charts to show the data. Example: Microsoft Excel or LibreOffice Calc.

2. What is LibreOffice Calc?

LibreOffice Calc is a free spreadsheet software, just like Microsoft Excel. It is used to enter data, perform calculations, make graphs, and analyze information. It is a part of the LibreOffice package.

3. What is data analysis?

Data analysis means studying data to find useful information, patterns, or answers. It helps in making better decisions. For example, analyzing marks of students to find the average and highest score.

Chapter 4: Analyse Data Using Scenarios and Goal Seek

1. Define the terms:

(a) Consolidate function
It is used to combine data from different sheets or ranges into one summary sheet. It helps in totaling or averaging values from multiple sources.

(b) What-if analysis
It means checking how changes in input values affect the result. It helps to plan by testing different possibilities.

(c) Goal Seek
It is a tool that helps find the input value needed to get a specific result in a formula. You give the result, and it gives the required input.

2. Give one point of difference:

(a) Subtotal and What-if

• Subtotal is used to add data in groups (like by category).
• What-if is used to see how changing inputs will change the result.

(b) What-if Scenario and What-if Tool

• What-if Scenario saves different sets of input values to compare results.
• What-if Tool includes different tools like Scenarios, Goal Seek, etc., used to test input changes.

3. Give any two advantages of data analysis tools.

1. Helps in decision-making by checking different outcomes.
2. Saves time by quickly calculating results for many cases.

4. Name any two tools for data analysis.

1. Scenario Manager
2. Goal Seek

(Also: Consolidate and Subtotal are data analysis tools.)

5. What are the criteria for consolidating sheets?

1. Same structure in all sheets (same row/column labels).
2. Use of correct cell ranges.
3. Data should be in a list or table format.

6. Which tool is used to create an outline for the selected data?

Subtotal is used to create an outline that shows totals for groups of related data.

Chapter  5: Using Macros in Spreadsheet

Q1. What is a Macro? List any two real-life situations where they can be used.
Answer: A macro is a set of recorded instructions or commands that automate repetitive tasks in a software application like LibreOffice.
Two real-life situations where macros can be used:

1. Automatically formatting a marksheet for students.
2. Generating monthly reports in the same format.

Q2. List the actions that are not recorded by a macro.
Answer: Macros do not record the following actions:

1. Mouse pointer movements.
2. Dialog box interactions or menu navigation without selection.
3. Operations outside LibreOffice applications.

Q3. How is LibreOffice Macros Library different from My Macros?
Answer:

1. LibreOffice Macros Library contains predefined or system macros that are available globally across documents.
2. My Macros are user-defined macros created by the user and can be used across multiple documents but are not predefined.

Q4. Differentiate between predefined function in Calc and Macros as a function.
Answer:

Predefined Function in Calc	Macros as a Function
Built-in formulas like SUM(), AVERAGE(), etc.	User-defined set of instructions for custom tasks
Easy to use with fixed structure	Require recording or writing using Basic or Macro editor
Limited to mathematical or logical operations	Can automate any sequence of commands in LibreOffice

Q5. List the rules that should be kept in mind while naming a macro.

Answer:

1. The name must begin with a letter (A–Z or a–z).
2. It can include letters, numbers, and underscores.
3. Spaces and special characters are not allowed.
4. The name should not be the same as a predefined function or keyword.

Q6. Give any one advantage of macros.
Answer: Advantage: Macros help in saving time by automating repetitive tasks, increasing efficiency and reducing the chances of human error.

Chapter 6: Linking Spreadsheet Data

Q1. Name the two ways to link the sheets in a LibreOffice Calc.
Answer: The two ways to link sheets in LibreOffice Calc are:

1. Using Cell Reference: Referring to a cell in another sheet using the syntax SheetName.CellAddress (e.g., Sheet2.A1).
2. Using Hyperlink: Inserting a clickable link that redirects to a different sheet or cell within the same workbook.

Q2. Differentiate between Relative and Absolute Hyperlink.

Relative Hyperlink	Absolute Hyperlink
Points to a file or location relative to the current document’s location.	Points to the full path of the file or location regardless of the current location.
Example: docs/report.ods	Example: C:/Users/Admin/docs/report.ods
Useful when moving files within the same folder structure.	Remains fixed, even if file is moved to a different location.

Q3. Write steps to extract a table from a web page in a spreadsheet.
Answer: Steps to extract a table from a web page in LibreOffice Calc:

1. Open LibreOffice Calc.
2. Click on Sheet → Link to External Data.
3. In the URL field, enter the web page address that contains the table.
4. Click Enter and wait for Calc to list the available importable items.
5. Select the desired table from the list.
6. Set the refresh interval (optional) and click OK.
7. The table will be imported into the spreadsheet.

Q4. Write steps to register a data source that is in .odb format.
Answer: Steps to register a data source in .odb format:

1. Open LibreOffice and go to Tools → Options.
2. In the left pane, expand LibreOffice Base and select Databases.
3. Click New to register a new database.
4. Browse and select the .odb file.
5. Give a name to the data source.
6. Click OK to register the data source.

Q5. State advantages of extracting data from a web page into spreadsheet.
Answer: Advantages of extracting data from a web page into a spreadsheet:

1. Automatic Updates: Data can be refreshed regularly without manual input.
2. Time-saving: Avoids copying data manually from the web.
3. Data Analysis: Enables sorting, filtering, and calculations using spreadsheet tools.
4. Data Centralization: Useful for compiling real-time data (like prices, statistics) into one sheet for analysis.

Chapter 7: Share and Review a Spreadsheet

Q1. Define the terms
(a) Sharing Spreadsheet
Answer: Sharing a spreadsheet means allowing multiple users to work on the same spreadsheet file simultaneously. In LibreOffice Calc, this enables collaboration by permitting others to make edits while tracking who made the changes.

(b) Record Changes
Answer: Record Changes (also known as Track Changes) is a feature in LibreOffice Calc that records all the modifications made to a spreadsheet, such as cell edits, additions, or deletions, along with the editor's name and timestamp.

Q2. Write the commands to perform
(a) Sharing Spreadsheet
Answer:

1. Open the spreadsheet.
2. Click on Edit → Changes → Share Document.
3. Check the box Share this spreadsheet with other users.
4. Click OK.

(b) Record Changes
Answer:

1. Open the spreadsheet.
2. Click on Edit → Changes → Record.
3. Now all changes made will be recorded.

Q3. Which menu is used to perform the functions
(a) Track Changes
Answer:
Edit menu → Changes

(b) Saving Spreadsheet
Answer:
File menu → Save or Save As

Q4. What do you understand by reviewing the changes in the spreadsheet?
Answer: Reviewing changes in a spreadsheet means going through the modifications made by different users. It allows the original author or editor to accept or reject each change after examining it. This helps maintain the accuracy and consistency of the data in collaborative environments.

Q5. Differentiate between Merging and Comparing Spreadsheet.

Merging Spreadsheet	Comparing Spreadsheet
Combines changes from multiple versions of a shared spreadsheet into one.	Finds differences between two versions of a spreadsheet.
Used after collecting edited copies from various users.	Used to analyze what is changed between original and modified versions.
Found under: Edit → Changes → Merge Document	Found under: Edit → Track Changes → Compare Document