Ch 6 Linking Spreadsheet Data Class 10 Question Answers

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.

Q2. Differentiate between Relative and Absolute Hyperlink.

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

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

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“

---

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