In this post I am going to discuss NCERT solutions Information Technology Class 10 Chapter 6 Linking Spreadsheet Data. Lets begin!
Topics Covered
NCERT solutions Information Technology Class 10 Chapter 6 Linking Spreadsheet Data
Chapter 6 Linking spreadsheet data NCERT solutions we are going to discuss. As we have seed earlier there are MCQs, True False, Fill in the blanks and Short/Long Answer questions are there. So let us begin now!
Watch this video instead of reading:
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) $ ‘MySheet’.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
[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
[1] Name the two ways to link the sheets in a LibreOffice Calc.
[2] Differentiate between Relative and Absolute Hyperlink.
| Relative Hyperlink | Absolute Hyperlink |
| Relative hyperlink accepts file to be linked from same directory where the spreadsheet is saved. | Absolute Hyperlink accepts file to be linked from another directory from where the spreadsheet is saved. |
| It contains partial file path or only filename. | It contains full path or complete address of file. |
| It will stop working if the target is moved. | It will stop working only if the source and target locations change relative to each other. |
| Example: ‘Result.ods’ | Example: ‘D:\School Work\Result.ods’ |
[3] Write steps to extract a table from a web page in a spreadsheet.
[4] Write steps to register a data source that is in *.odb format.
[5] State advantages of extracting data from a web page into spreadsheet.
Watch this video for more understanding with practical explanation: