NCERT Solutions Information Technology Class 10 Chapter 6 Linking Spreadsheet Data | TutorialAICSIP

In this post I am going to discuss NCERT solutions Information Technology Class 10 Chapter 6 Linking Spreadsheet Data. Lets begin!

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!

A. Multiple choice questions

[1] Insert Sheet dialog can be invoked from ________________.
(a) sheet
(b) insert
(c) tools
(d) Windows

Ans. (a) Sheet
Insert, tools and windows are not correct options.

[2] _______________ refers to cell G5 of sheet named My Sheet.
(a) $My Sheet.’G5’
(b) $My Sheet_’G5’
(c) $ ‘MySheet’.G5
(d) $ ‘MySheet’_G5

Ans. (c) $’My Sheet’.G5
Insert, tools and windows are not correct options.

[3] The path of a file has ________________ forward slashes.
(a) four
(b) three
(c) two
(d) one

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
(b) Hyperlink
(c) connect
(d) Copy

Ans. (b) Hyperlink

B. Fill in the blanks

[1] A relative hyperlink stores the location with respect to the _______________ location.

Ans.: current

[2] While inserting tables from a webpage _______________ selects the entire HTML document.

Ans.: HTML_all

[3] The extension of LibreOffice base is _______________.

Ans.: .odb.

[4] ____________ are used to enclose sheet names as there might be a space within sheet names.

Ans.:Single Quotes (”)

[5] The From file option of _________________ Dialog box allows to insert sheet from another file.

Ans.: Insert Sheet

C. State whether the following statements are True or False

[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.: 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

D. Answer the following questions

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

Ans.: Two insert sheet in a LibreOffice Calc are as follows:
1. Sheet > Insert Sheet
2. Click on + symbol on sheet tab

[2] Differentiate between Relative and Absolute Hyperlink.

[3] Write steps to extract a table from a web page in a spreadsheet.

Ans.: To extract table from a web page in a spreadsheet, follow these steps:
1. Open the spreadsheet where table is required.
2. Place the cursor from where table needs to be inserted.
3. Click on Sheet > Link to External Data.
4. The External Data Dialog box appears. Type the URL of source document or select it from Drop Down list.
5. Press enter.
6. A dialog box appear to choose language.
7. Chose the desired language and click on Import button.

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

Ans.: To register a data source, follow these steps:
1. Click on Tools > Options > LibreOffice Base > Databases.
2. The Options – LibreOffice Base-DataBases dialog box appears.
3. Click on the New button.
4. It will open Create Database Link dialog box.
5. Enter the location of database file or select from the file browser which is going to be linked.
6. Type name for Registered Database and Click on OK button.

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

Ans.: The advantages of extracting data from a web page are as follows:
1. It is useful in Market research, sentiment analysis, data aggregation etc.
2. Gathering data from online sources
3. It provides real time data updation
4. It is also saving time and cost of uses

Related