Chapter 6 Linking Spreadsheet Data Class 10 Question Answers Chapter 6 Linking Spreadsheet Data Class 10 Question Answers
Linking spreadsheet Data Class 10
A. Multiple choice questions 1. Insert Sheet dialog can be invoked from __________________
(a) sheet
Ans. (a) sheet
2. __________________
(a) $My Sheet.’G5’
Ans. (c) $‘My Sheet’.G5
3. The path of a file has _________________
(a) four
Ans. (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
Ans. (b) Hyperlink
B. Fill in the blanks
1. A relative hyperlink stores the location with respect to the __________________ location.
Ans. 1. A relative hyperlink stores the location with respect to the current
2. While inserting tables from a webpage _______________
Ans. 2. While inserting tables from a webpage HTML_all
3. The extension of LibreOffice base is _________________________
Ans. 3. The extension of LibreOffice base is .odb
4. ______________________ are used to enclose sheet names as there might be a space within sheet names.
Ans. 4. Single quotes
5. The From file option of _____________________ Dialog box allows to insert sheet from another file.
Ans. 5. The From file option of Insert Sheet
Linking spreadsheet Data
C. State whether the following statements are True or False notes
1. A sheet can only be added before the current sheet.
Ans. 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.
Ans. 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.
Ans. False
4. We can insert data from a table created on a web page into a spreadsheet.
Ans. True
5. A hyperlink once created on a sheet cannot be deleted.
Ans. False
Linking spreadsheet Data
D. Answer the following questions
Q1. Name the two ways to link the sheets in a LibreOffice Calc.
Ans. 1. Creating reference to other sheets/documents by using keyboard and mouse.
2. By linking external data.
Q2. Differentiate between Relative and Absolute Hyperlink.
Ans. 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.
Ans. 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.
Ans. 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.
Ans. Advantages of extracting data from a web page into spreadsheet are:
Accuracy: Extracting data directly from a webpage, ensure that the information is up-to-date and accurate. Efficiency: Extracting data automates the process of gathering data from a webpage. Collaboration: It also facilitates organization and collaboration of data.
Linking spreadsheet Data
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 Answer , but if you feel that there is/are mistakes in the Answers of “Chapter 6 Linking Spreadsheet Data Class 10 Question Answer 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 Answer
Linking Spreadsheet Data Class 10 Question Answers Linking Spreadsheet Data Class 10 Question Answers Linking Spreadsheet Data Class 10 Question Answers Linking Spreadsheet Data Class 10 Question Answers Linking Spreadsheet Data Class 10 Question Answers Linking Spreadsheet Data Class 10 Question Answers Linking Spreadsheet Data Class 10 Question Answers Linking Spreadsheet Data Class 10 Question Answers Like this: Like Loading...
Related
