Chapter 6 Linking Spreadsheet Data Class 10 Question Answers
Chapter 6 Linking Spreadsheet Data Class 10 Question Answers
A. Multiple choice questions
1. Insert Sheet dialog can be invoked from __________________.
(a) sheet
(b) insert
(c) tools
(d) Windows
2. __________________ refers to cell G5 of sheet named My Sheet.
(a) $My Sheet.’G5’
(b) $My Sheet_’G5’
(c) $‘My Sheet’.G5
(d) $‘MySheet’_G5
3. The path of a file has _________________ forward slashes.
(a) four
(b) three
(c) two
(d) one
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
B. Fill in the blanks
1. A relative hyperlink stores the location with respect to the __________________ location.
2. While inserting tables from a webpage _______________ selects the entire HTML document.
3. The extension of LibreOffice base is _________________________.
4. ______________________ are used to enclose sheet names as there might be a space within sheet names.
5. The From file option of _____________________ Dialog box allows to insert sheet from another file.
C. State whether the following statements are True or False notes
1. A sheet can only be added before the current sheet.
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.
3. It is not possible to link a sheet as a reference in another sheet.
4. We can insert data from a table created on a web page into a spreadsheet.
5. A hyperlink once created on a sheet cannot be deleted.
D. Answer the following questions
Q1. Name the two ways to link the sheets in a LibreOffice Calc.
1. Creating reference to other sheets/documents by using keyboard and mouse. 2. By linking external data.
Q2. Differentiate between Relative and Absolute Hyperlink.
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. 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.
Q3. Write steps to extract a table from a web page in a spreadsheet.
1. Open the spreadsheet where external data is to be inserted. 2. Select Sheet > External Links… 3. The External Data dialog box will open. 4. Type the URL of the source document and press enter. 5. A dialog box is displayed to select the language for import. Selecting Automatic shows data in the same language as in the webpage. 6. From the Available Tables/Ranges list, choose the desired table and click OK. 7. Table will be inserted in the spreadsheet
Q4. Write steps to register a data source that is in *.odb format.
1. Select Tools > Options > LibreOffice Base > Databases. The Options – LibreOffice Base-Databases dialog box appears. 2. Click the New button to open the Create Database Link dialog box. 3. Click Browse to open a file browser and select the database file. 4. Type a name to use as the registered name for the database and click OK.
Q5. State advantages of extracting data from a web page into spreadsheet.
Important links of Class X (IT – 402)
Unit 1: Digital Documentation (Advanced) using LibreOffice Writer
Chapter 1. Introduction to Styles – NOTES
Chapter 1. Introduction to Styles – Question Answers
Chapter 2. Working with Images – NOTES
Chapter 2. Working with Images – Question Answers
Chapter 3. Advanced features of Writer – NOTES
Chapter 3. Advanced features of Writer – Question Answers
Unit 2: Electronic Spreadsheet (Advanced) using LibreOffice Calc
Chapter 4. Analyse Data using Scenarios and Goal Seek – NOTES
Chapter 4. Analyse Data using Scenarios and Goal Seek – Question Answers
Chapter 5. Using Macros in Spreadsheet – NOTES
Chapter 5. Using Macros in Spreadsheet – Question Answers
UNIT 1: DIGITAL DOCUMENTATION (ADVANCED) – MCQ
UNIT-2: ELECTRONIC SPREADSHEET (ADVANCED) – MCQ
UNIT-3 RELATIONAL DATABASE MANAGEMENT SYSTEMS (BASIC) – MCQ
Disclaimer : I tried to give you the Answers of “Chapter 6 Linking Spreadsheet Data Class 10 Question Answers“ , but if you feel that there is/are mistakes in the Answers of “Chapter 6 Linking Spreadsheet Data Class 10 Question Answers“ given above, you can directly contact me at csiplearninghub@gmail.com. NCERT Book and Study material available on CBSE Website are used to create above article “Chapter 6 Linking Spreadsheet Data Class 10 Question Answers“