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.