cbse CLASS – X computer SUBJECT – INFORMATION TECHNOLOGY CHAPTER – 6 LINKING SPREADSHEET DATA

QUESTION BANK

CLASS – X

SUBJECT – INFORMATION TECHNOLOGY

CHAPTER – 6 LINKING SPREADSHEET DATA

Multiple Choice Questions (MCQs)

1. What is linking data in spreadsheets?

o A) Combining two spreadsheets into one

o B) Connecting cells from different spreadsheets to reflect changes

o C) Removing duplicates from a spreadsheet

o D) Sorting data in ascending order

Answer: B) Connecting cells from different spreadsheets to reflect changes

2. Which of the following is a valid way to create a link between two spreadsheets?

o A) Copying and pasting values

o B) Using the SUM function

o C) Referring to a cell in another workbook with its name

o D) Merging cells

Answer: C) Referring to a cell in another workbook with its name

3. When linking data, what symbol is used to indicate a reference to another

spreadsheet?

o A) &

o B) @

o C) !

o D) #

Answer: C) !

4. Which function can be used to link and sum values from another spreadsheet?

o A) LINK()

o B) ADD()

o C) SUM()

o D) JOIN()

Answer: C) SUM()

5. If you change the value in the source spreadsheet, how will it affect the linked

spreadsheet?

o A) The linked spreadsheet will not change

o B) The linked spreadsheet will update automatically

o C) You will need to refresh manually

o D) The link will be broken

Answer: B) The linked spreadsheet will update automatically

Short Answer Questions

6. Explain the steps to create a link between two different spreadsheets. Answer:

o Open both spreadsheets. o In the destination spreadsheet, select the cell where you want the linked data. o Type the equal sign =. o Switch to the source spreadsheet and click on the cell you want to link. o Press Enter, and the linked data will appear in the destination cell. 7. What is the purpose of using links in spreadsheets?

Answer: The purpose of using links is to allow real-time updates and to maintain

consistency across different spreadsheets. It helps in managing data efficiently without

the need to duplicate information. 

8. How do you break a link between two spreadsheets?

Answer: To break a link, go to the "Data" tab, select "Edit Links," choose the link you

want to break, and click on "Break Link." This will convert the linked data into static

values.

 Long Answer Questions

9. Discuss the advantages and disadvantages of linking data between spreadsheets. 

Answer: Advantages:

o Real-time Updates: Changes in the source spreadsheet are reflected

automatically, ensuring that data is current. o Reduced Duplication: Prevents the need to enter the same data multiple times

across different sheets. o Centralized Data Management: Changes can be made in one location, simplifying data management. Disadvantages:

o Link Breakage: If the source file is moved or deleted, links may break, resulting

in lost connections and errors. o Complexity: Managing multiple links can become complicated, especially if

many spreadsheets are involved. o Performance Issues: Excessive linking can slow down performance, particularly

in large spreadsheets. 

10. Create a hypothetical scenario where linking data between two spreadsheets would

be beneficial. Explain how you would set it up. 

Answer: Scenario: A school uses one spreadsheet to track student grades and another to

calculate class averages. Setup:

o In the grades spreadsheet, each student's grades for different subjects are recorded. o In the class average spreadsheet, I would link to the cells in the grades

spreadsheet where the final grades are calculated. o To do this, I would:  Open both spreadsheets.  In the class average spreadsheet, type =, switch to the grades spreadsheet, click on the cell with the final grade, and press Enter. o This way, whenever a teacher updates a student's grade in the first spreadsheet, the class average in the second spreadsheet will automatically update.