CLASS 10:UNIT 2: CHAPTER 6(Linking Spreadsheet Data) IMPORTANT NOTES

✅ 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: (a) $My Sheet.’G5’
(Sheet name with space uses single quotes: ‘My Sheet’)

---

3. The path of a file has ____________ forward slashes.

(a) four
(b) three
(c) two
(d) one
✅ Answer: (b) three

---

4. Which 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

---

✅ B. FILL IN THE BLANKS

1. A relative hyperlink stores the location with respect to the current location.
2. While inserting tables from a webpage HTML_all selects the entire HTML document.
3. The extension of LibreOffice Base is .odb.
4. Single quotes (‘ ’) are used to enclose sheet names as there might be a space within sheet names.
5. The From file option of Insert Sheet dialog box allows to insert sheet from another file.

---

✅ C. TRUE / FALSE

1. A sheet can only be added before the current sheet.
   ❌ False
   (You can insert before or after.)
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
   (It is possible using =SheetName.Cell.)
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
   (It can be removed.)

---

✅ D. ANSWER THE FOLLOWING QUESTIONS (IN SIMPLE EXPLANATION)

---

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

✅ Two ways to link sheets are:

1. Using cell reference
   Example:
2. =Sheet2.A1
3. Using Insert Sheet From File
   (Links entire sheet from another Calc file.)

---

2. Difference between Relative and Absolute Hyperlink

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

Steps:

1. Copy the webpage URL from the browser.
2. In Calc, go to Sheet → Insert Sheet From File → Link to External Data.
3. Paste the URL in the dialog box.
4. Press Enter → A list of tables or HTML parts appears.
5. Select the table you want (often called HTML_1, HTML_all, etc.).
6. Click OK → The webpage table is inserted into the spreadsheet.

---

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

Steps:

1. Go to Tools → Options.
2. Expand LibreOffice Base → Databases.
3. Click New.
4. Browse and select your .odb file.
5. Give a registered name.
6. Click OK.
   Now the database becomes available to Calc and other LibreOffice tools.

---

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

✅ Advantages:

1. Saves time — no need to type data manually.
2. Ensures accurate data, without typing mistakes.
3. Data becomes available for calculations, charts, and analysis.
4. Dynamic web tables can be refreshed when updated.
5. Useful for live data, such as stock prices or weather updates.