Chapter 6 Linking Spreadsheet Data Question Answer Class 10 IT using LibreOffice CBSE Python

Chapter 6 Linking Spreadsheet Data Question Answer Class 10 IT

A. Multiple choice questions

1. Insert Sheet dialog can be invoked from _______________.
(a) sheet
(b) insert
(c) tools
(d) Windows

Answer:(a) sheet

2. ______________ refers to cell G5 of sheet named My Sheet.
(a) $My Sheet.’G5’
(b) $My Sheet_’G5’
(c) $ ‘MySheet’.G5
(d) $ ‘MySheet’_G5

Answer:(c) $ ‘MySheet’.G5

3. The path of a file has ____________ forward slashes.
(a) four
(b) three
(c) two
(d) one

Answer:(b) three

4. Which of the following feature is used to jump to a different spreadsheet from the current spreadsheet in LibreOffice Calc?
(a) Macro
(b) Hyperlink
(c) connect
(d) Copy

Answer:(b) Hyperlink

Linking Spreadsheet Data Question Answer Class 10 IT

B. Fill in the blanks

1. A relative hyperlink stores the location with respect to the ___________ location.

current

2. While inserting tables from a webpage _____________selects the entire HTML document.

HTML_all

3. The extension of LibreOffice base is ______________.

.odb

4. __________ are used to enclose sheet names as there might be a space within sheet names.

Single quotes (‘ ’)

5. The From file option of ___________ Dialog box allows to insert sheet from another file.

Insert Sheet

Linking Spreadsheet Data Question Answer Class 10 IT

C. State whether the following statements are True or False notes

1. A sheet can only be added before the current sheet. [False]

2. If ‘sales’ sheet has a reference to ‘cost’ sheet then any changes made to ‘cost’ sheet will be reflected in the sales sheet as well. [True]

3. It is not possible to link a sheet as a reference in another sheet. [False]

4. We can insert data from a table created on a web page into a spreadsheet. [True]

5. A hyperlink once created on a sheet cannot be deleted. [False]

Linking Spreadsheet Data Question Answer Class 10 IT

D. Answer the following questions

1. Name the two ways to link the sheets in a LibreOffice Calc.

Answer: The two ways to link sheets in LibreOffice Calc are:

i) By using cell references: You can link cells from different sheets by using cell references. For example, to link to cell A1 from Sheet2 in Sheet1, you can enter =Sheet2.A1 in a cell in Sheet1.

ii) By using hyperlinks: You can create hyperlinks to specific sheets within the same workbook. This can be done through the “Insert” menu by selecting “Hyperlink” and then linking to the desired sheet.

Linking Spreadsheet Data Question Answer Class 10 IT

2. Differentiate between Relative and Absolute Hyperlink.

Answer:

i) Relative Hyperlink: A relative hyperlink points to a location that is relative to the current document’s location. If the document is moved, the link may remain functional as long as the relative path remains the same. For example, if you have a link to ../folder/file.html, it points to a file that is one directory up from the current location.

ii) Absolute Hyperlink: An absolute hyperlink points to a specific location, regardless of the current document’s location. It includes the full path or URL. For example, http://www.example.com/folder/file.html points directly to the file, no matter where the document containing the link is moved.

Linking Spreadsheet Data Question Answer Class 10 IT

3. Write steps to extract a table from a web page in a spreadsheet.

Answer: Steps to extract a table from a web page into a spreadsheet:

Step 1: Open LibreOffice Calc.

Step 2: Go to the “Sheet” menu and select “Insert Sheet from File.”

Step 3: In the dialog that appears, choose “Insert from URL.”

Step 4: Enter the URL of the web page containing the table.

Step 5: Click “Open” to load the web page.

Step 6: A dialog box will appear showing the available tables on the web page. Select the table you want to import.

Step 7: Click “OK” to import the selected table into your spreadsheet.

Linking Spreadsheet Data Question Answer Class 10 IT

4. Write steps to register a data source that is in *.odb format.

Answer:Steps to register a data source in LibreOffice:

Step 1: Open LibreOffice and go to “File” > “New” > “Database.”

Step 2: In the Database Wizard, select “Connect to an existing database” and choose “LibreOffice Base” (which is *.odb format).

Step 3: Click “Next” and browse to the location of the *.odb file.

Step 4: Select the *.odb file and click “Open.”

Step 5: Follow the prompts to complete the connection setup.

Step 6: After completing the setup, go to “Tools” > “Options” > “LibreOffice Base” > “Databases.”

Step 7:Click “New” to register the database, provide a name for the data source, and browse to select the *.odb file.

Step 8: Click “OK” to register the database.

Linking Spreadsheet Data Question Answer Class 10 IT

5. State advantages of extracting data from a web page into spreadsheet.

Answer: Advantages of extracting data from a web page into a spreadsheet:

Automated Data Collection: It simplifies the process of collecting and organizing data from web sources, saving time and reducing manual entry errors.
Data Analysis: Spreadsheets offer powerful tools for analyzing and visualizing data, such as charts, pivot tables, and various functions for statistical analysis.
Data Manipulation: Spreadsheets allow for easy manipulation of data, including sorting, filtering, and formatting, which can help in drawing insights and making informed decisions.
Real-time Updates: If the web data is frequently updated, setting up automated imports can ensure that the spreadsheet always contains the most current information.
Integration with Other Tools: Data in spreadsheets can be easily integrated with other applications for further processing, reporting, or sharing.

You May also Check:

Class 10 IT 402 Chapter wise Important Questions

Chapter 11: Queries in Base

Chapter 12: Forms and Reports

Unit 4: Maintain Healthy, Safe and Secure Working Environment

Chapter 13: Health, Safety and Security at Workplace

Chapter 14: Workplace Quality Measures

Chapter 15: Prevent Accidents and Emergencies

Chapter 6 Linking Spreadsheet Data Question Answer Class 10 IT using LibreOffice