{"id":4897,"date":"2024-05-03T22:15:04","date_gmt":"2024-05-03T16:45:04","guid":{"rendered":"https:\/\/cbsepython.in\/?p=4897"},"modified":"2024-05-18T11:25:03","modified_gmt":"2024-05-18T05:55:03","slug":"linking-spreadsheet-data-question-answer-class-10","status":"publish","type":"post","link":"https:\/\/cbsepython.in\/linking-spreadsheet-data-question-answer-class-10\/","title":{"rendered":"Chapter 6 Linking Spreadsheet Data Question Answer Class 10 IT using LibreOffice"},"content":{"rendered":"

Chapter 6 Linking Spreadsheet Data Question Answer Class 10 IT<\/span><\/h2>\n
\"Linking
Linking Spreadsheet Data Question Answer Class 10 IT<\/figcaption><\/figure>\n

A. Multiple choice questions<\/strong><\/span><\/p>\n

1. Insert Sheet dialog can be invoked from _______________.<\/span>
\n(a) sheet<\/span>
\n(b) insert<\/span>
\n(c) tools<\/span>
\n(d) Windows<\/span><\/p>\n

Answer:(a) sheet\u00a0<\/strong><\/span><\/p>\n

 <\/p>\n

2. ______________ refers to cell G5 of sheet named My Sheet.<\/span><\/strong>
\n(a) $My Sheet.\u2019G5\u2019<\/span>
\n(b) $My Sheet_\u2019G5\u2019<\/span>
\n(c) $ \u2018MySheet\u2019.G5<\/span>
\n(d) $ \u2018MySheet\u2019_G5<\/span><\/p>\n

Answer:(c) $ \u2018MySheet\u2019.G5\u00a0<\/strong><\/span><\/p>\n

 <\/p>\n

3. The path of a file has ____________ forward slashes.<\/span><\/strong>
\n(a) four<\/span>
\n(b) three<\/span>
\n(c) two<\/span>
\n(d) one<\/span><\/p>\n

Answer:(b) three\u00a0<\/strong><\/span><\/p>\n

 <\/p>\n

4. Which of the following feature is used to jump to a different spreadsheet from the current spreadsheet in LibreOffice Calc?<\/span><\/strong>
\n(a) Macro<\/span>
\n(b) Hyperlink<\/span>
\n(c) connect<\/span>
\n(d) Copy<\/span><\/p>\n

Answer:(b) Hyperlink\u00a0<\/strong><\/span><\/p>\n

Linking Spreadsheet Data Question Answer Class 10 IT<\/span><\/h3>\n

B. Fill in the blanks<\/strong><\/span><\/p>\n

1. A relative hyperlink stores the location with respect to the ___________ location.<\/span><\/p>\n

current<\/strong><\/span><\/p>\n

 <\/p>\n

2. While inserting tables from a webpage _____________selects the entire HTML document.<\/span><\/p>\n

HTML_all<\/strong><\/span><\/p>\n

 <\/p>\n

3. The extension of LibreOffice base is ______________.<\/span><\/p>\n

.odb<\/strong><\/span><\/p>\n

 <\/p>\n

4. __________ are used to enclose sheet names as there might be a space within sheet names.<\/span><\/p>\n

Single quotes (\u2018 \u2019)<\/strong><\/span><\/p>\n

 <\/p>\n

5. The From file option of ___________ Dialog box allows to insert sheet from another file.<\/span><\/p>\n

Insert Sheet<\/strong><\/span><\/p>\n

Linking Spreadsheet Data Question Answer Class 10 IT<\/span><\/h3>\n

C. State whether the following statements are True or False notes<\/strong><\/span><\/p>\n

1. A sheet can only be added before the current sheet. [False]<\/strong><\/span><\/p>\n

2. If \u2018sales\u2019 sheet has a reference to \u2018cost\u2019 sheet then any changes made to \u2018cost\u2019 sheet will be reflected in the sales sheet as well. [True]<\/strong><\/span><\/p>\n

3. It is not possible to link a sheet as a reference in another sheet. [False]<\/strong><\/span><\/p>\n

4. We can insert data from a table created on a web page into a spreadsheet. [True]<\/strong><\/span><\/p>\n

5. A hyperlink once created on a sheet cannot be deleted. [False]<\/strong><\/span><\/p>\n

Linking Spreadsheet Data Question Answer Class 10 IT<\/span><\/h3>\n

D. Answer the following questions<\/strong><\/span><\/p>\n

1. Name the two ways to link the sheets in a LibreOffice Calc.<\/span><\/strong><\/p>\n

Answer:<\/strong> The two ways to link sheets in LibreOffice Calc are:<\/span><\/p>\n

i) By using cell references<\/strong>: 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<\/code> in a cell in Sheet1.<\/span><\/p>\n

ii) By using hyperlinks<\/strong>: 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.<\/span><\/p>\n

Linking Spreadsheet Data Question Answer Class 10 IT<\/span><\/h3>\n

2. Differentiate between Relative and Absolute Hyperlink.<\/span><\/strong><\/p>\n

Answer:<\/strong><\/span><\/p>\n

i) Relative Hyperlink<\/strong>: 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<\/code>, it points to a file that is one directory up from the current location.<\/span><\/p>\n

ii) Absolute Hyperlink<\/strong>: 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<\/code> points directly to the file, no matter where the document containing the link is moved.<\/span><\/p>\n

Linking Spreadsheet Data Question Answer Class 10 IT<\/span><\/h3>\n

3. Write steps to extract a table from a web page in a spreadsheet.<\/span><\/strong><\/p>\n

Answer:\u00a0<\/strong>Steps to extract a table from a web page into a spreadsheet:<\/span><\/p>\n

Step 1:<\/strong> Open LibreOffice Calc.<\/span><\/p>\n

Step 2: <\/strong>Go to the “Sheet” menu and select “Insert Sheet from File.”<\/span><\/p>\n

Step 3: <\/strong>In the dialog that appears, choose “Insert from URL.”<\/span><\/p>\n

Step 4: <\/strong>Enter the URL of the web page containing the table.<\/span><\/p>\n

Step 5: <\/strong>Click “Open” to load the web page.<\/span><\/p>\n

Step 6:<\/strong> A dialog box will appear showing the available tables on the web page. Select the table you want to import.<\/span><\/p>\n

Step 7:<\/strong> Click “OK” to import the selected table into your spreadsheet.<\/span><\/p>\n

Linking Spreadsheet Data Question Answer Class 10 IT<\/span><\/h3>\n

4. Write steps to register a data source that is in *.odb format.<\/span><\/strong><\/p>\n

Answer:<\/strong>Steps to register a data source in LibreOffice:<\/span><\/p>\n

Step 1:<\/strong> Open LibreOffice and go to “File” > “New” > “Database.”<\/span><\/p>\n

Step 2: <\/strong>In the Database Wizard, select “Connect to an existing database” and choose “LibreOffice Base” (which is *.odb format).<\/span><\/p>\n

Step 3: <\/strong>Click “Next” and browse to the location of the *.odb file.<\/span><\/p>\n

Step 4: <\/strong>Select the *.odb file and click “Open.”<\/span><\/p>\n

Step 5: <\/strong>Follow the prompts to complete the connection setup.<\/span><\/p>\n

Step 6: <\/strong>After completing the setup, go to “Tools” > “Options” > “LibreOffice Base” > “Databases.”<\/span><\/p>\n

Step 7:<\/strong>Click “New” to register the database, provide a name for the data source, and browse to select the *.odb file.<\/span><\/p>\n

Step 8: <\/strong>Click “OK” to register the database.<\/span><\/p>\n

Linking Spreadsheet Data Question Answer Class 10 IT<\/span><\/h3>\n

5. State advantages of extracting data from a web page into spreadsheet.<\/span><\/strong><\/p>\n

Answer: <\/strong>Advantages of extracting data from a web page into a spreadsheet:<\/span><\/p>\n