Ch 6 Linking Spreadsheet Data Class 10 MCQ
Ch 6 Linking Spreadsheet Data Class 10 MCQ
Q1. We can link one worksheet to another worksheet.(T/F)
a. True
b. False
Q2. We can not add/insert more sheets in a spreadsheet.(T/F)
a. True
b. False
Ch 6 Linking Spreadsheet Data Class 10 MCQ
Q3. When you open a new spreadsheet, by default it has sheet named ______________.
a. Sheet1
b. Sheet_1
c. Sheet 1
d. None of the above
Q4. By default sheets tab are present at the _____________ of the spreadsheet.
a. Top
b. Bottom
c. Both of the above
d. None of the above
Q5. Which of the following elements are present in “Insert Sheet” dialog box.
a. After Current Sheet
b. Before Current Sheet
c. No. of Sheets
d. All of the above
Q6. By default ________________ sheets are present in Libre Office Calc.
a. 1
b. 2
c. 3
d. 4
Ch 6 Linking Spreadsheet Data Class 10 MCQ
Q7. We can rename a new sheet in Calc.
a. After inserting a new sheet
b. While inserting a new sheet
c. Both of the above
d. None of the above
Q8. We can rename an existing sheet in Calc by
a. Double click on one of the existing sheet
b. Right click on existing sheet and then choose rename
c. Both of the above
d. None of the above
Q9. Formula to refer a cell A3 in sheet named S1 is
a. =S1A3
b. =S1.A3
c. =”S1″.A3
d. None of the above
Q10. Hyperlink in Calc can be used
a. to jump from one sheet to another sheet.
b. to jump from one sheet to website
c. to jump from one section to another section of same sheet
d. All of the above
Q11. Hyperlink in Calc can be either relative or absolute.(T/F)
a. True
b. False
Ch 6 Linking Spreadsheet Data Class 10 MCQ
Q12. Absolute link will stop working only if the target is moved(T/F)
a. True
b. False
Q13. A relative link will stop working only if the target is moved.(T/F)
a. True
b. False
Q14. If you have two spreadsheets in the same folder linked to each other and you move the entire folder to a new location, a relative hyperlink will _____________
a. not work
b. work
c. may work
d. None of the above
Q15. Hyperlink option is available in ______ menu.
a. File
b. Edit
c. Format
d. Insert
Q16. Hyperlink icon is present on _________________
a. Format Toolbar
b. Standard Toolbar
c. Menu Bar
d. None of the Above
Ch 6 Linking Spreadsheet Data Class 10 MCQ
Q17. Hyperlink dialog box shows ___________ types of hyperlinks on left hand side.
a. 1
b. 2
c. 3
d. 4
Q18. We can link a text in spreadsheet to any Web URL.(T/F)
a. True
b. False
Q19. Hyperlink dialog box in Calc shows ________ options on left hand side.
a. Internet
b. Document
c. New Document
d. All of the above
Q20. In Calc link to external data is present in _____________ menu.
a. File
b. Edit
c. Insert
d. View
Q21. Which of the following symbol is clicked to add a new sheet in LibreOffice Calc?
a. –
b. +
c. @
d. /
Q22. Arun is working in Calc. He want to insert a new sheet. He right clicked on the sheet tab and he saw a menu but he forgot which option to select to insert a new sheet. Help him to choose the correct option.
a. Sheet
b. Insert Sheet
c. Add Sheet
d. New Sheet
Q23. Anshu want to insert a new sheet in Calc. Which of the following options can be used by her?
a. Right click on sheet tab and choose insert sheet option
b. Click on the ‘+’ icon on Sheet tab
c. Click on Sheet > Insert Sheet
d. All of the above
Q24. Anshuman is working in Calc and has opened a new file. He opened the Insert Sheet dialog box. Can you tell the default sheet name shown in the dialog box?
a. Sheet1
b. Sheet_2
c. Sheet2
d. Sheet_1
Q25. Gurmat is a student of class 10. He wants to refer the “D5” of sheet named “Exam 1”. Identify the correct reference from the following
a. $’Exam 1′.D5
b. ‘Exam 1’.D5
c. $.’Exam 1′.D5
d. ‘Exam 1’.D5
Q26. To refer to a cell in another sheet precede the cell reference with a ‘$’ sign. It is then followed by the name of the sheet. Under which condition is the sheet name enclosed in single quotes?
a. When sheet name contains more than 10 character.
b. When sheet name starts with any digits.
c. When sheet name contain space.
d. When sheet name starts with capital alphabet
Q27. While referring the cell in a different spreadsheet the path of the file has _______________ forward slashes.
a. 2
b. 1
c. 4
d. 3
Q28. A _____________ data means that the data is always the same as in the original file.
a. Living
b. Live
c. Current
d. Lively
Q29. Arun wants to insert the sheet “Exam” from “Examination” spreadsheet in “CBSE” spreadsheet. Which of the following option will help him?
a. Sheet > Insert Sheet > From File
b. Insert > Sheet > From File
c. Sheet > Insert from Sheet
d. Sheet > From File
Q30. Which of the following checkbox option in Insert Sheet Dialog box help us to access the Live data in Calc?
a. Click Data
b. Link Data
c. Click
d. Link
Q31. Suman wants to jump to a document stored at a different location from within a document. Which of the following option will help her to do this?
a. Click n Link
b. Alignment
c. Format
d. Hyperlink
Q32. With the help of hyperlink we can jump from _________________
a. a sheet in the same spreadsheet
b. a sheet to different spreadsheet
c. a sheet to a website
d. All of the above
Q33. _______________ hyperlink stores the complete location where the file is stored.
a. Absolute
b. Relative
c. Normal
d. None of the above
Q34. C:\User\admin\document\admin.ods is an example of __________________ hyperlink.
a. Relative
b. Normal
c. Accurate
d. Absolute
Q35. Admin\document\exam.ods is an example of _________________ hyperlink.
a. Relative
b. Normal
c. Accurate
d. Absolute
Q36. An Hyperlink dialog box can be opened by _______________
a. Clicking Insert > Hyperlink
b. Clicking hyperlink icon on standard toolbar
c. Pressing Ctrl + K from keyboard
d. All of the above
Q37. Which of the following options are available in Hyperlink dialog box in LibreOffice Calc?
a. Internet
b. Mail
c. Document
d. All of the above
Q38. Arjun wants to create a hyperlink to an existing document in Calc. Which of the following option should he choose from the hyperlink dialog box?
a. Internet
b. Document
c. New Document
d. Mail
Q39. Suman is working in Calc. She has to create a hyperlink to a particular web page. Which option is suitable for her?
a. Internet
b. Document
c. New Document
d. Mail
Q40. To open a hyperlinked sheet in Calc, press the _________________ key and click on the hyperlinked word and the sheet will be opened in ____________ window.
a. Ctrl, Same
b. Alt, Same
c. Ctrl, New
d. Alt, New
Q41. Anshuman created a hyperlink in Calc. Now he want to modify the existing hyperlink. He right clicked on the hyperlinked text, and a context menu appeared. Which of the following should he choose to modify the hyperlink?
a. Modify Hyperlink
b. Change Hyperlink
c. New Hyperlink
d. Edit Hyperlink
Q42. Data on a webpage can be stored in the form of tables in Calc.(T/F)
a. True
b. False
Q43. Which of the following option is available in LibreOffice Calc in reference to linking?
a. Linking to external data
b. Linking to Registered data
c. Both of the above
d. None of the above
Q44. We can insert the new sheet in Calc by clicking on ________________ menu.
a. Format
b. Edit
c. Insert
d. Tool
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
Chapter 6. Linking Spreadsheet Data – NOTES
Chapter 6. Linking Spreadsheet Data – Question Answers
Chapter 7. Share and Review a Spreadsheet – NOTES
Chapter 7. Share and Review a Spreadsheet – Question Answers
Unit 3: Database Management system using LibreOffice Base
Chapter 8. Introduction to DBMS – NOTES
Chapter 8. Introduction to DBMS – Question Answers
Chapter 9. Starting with LibreOffice Base – NOTES
Chapter 9. Starting with LibreOffice Base – Question Answers
Chapter 10. Working with Multiples Tables – NOTES
Chapter 10. Working with Multiples Tables – Question Answers
Chapter 11. Queries in LibreOffice Base – NOTES
Chapter 11. Queries in LibreOffice Base – Question Answers
Chapter 12. Forms and Reports – NOTES
Chapter 12. Forms and Reports – Question Answers
Unit 4: Prevent Accident and Emergencies
Chapter 13. Health, Safety and Security at Workplace – NOTES
Chapter 13. Health, Safety and Security at Workplace – Question Answers
Chapter 14. Workplace Safety Measures – NOTES
Chapter 14. Workplace Safety Measures – Question Answers
Chapter 15. Prevent Accidents and Emergencies – NOTES
Chapter 15. Prevent Accidents and Emergencies – 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 practice of Linking Spreadsheet Data Class 10 MCQ. This way you can find out your weak areas of Ch-6 Linking Spreadsheet Data Class 10 MCQ . All the questions given above of Linking Spreadsheet Data Class 10 MCQ are designed from NCERT book. If you find any mistake in the above questions of Linking Spreadsheet Data Class 10 MCQ, you can directly contact me at csiplearninghub.com
Ch 6 Linking Spreadsheet Data Class 10 MCQ
Ch 6 Linking Spreadsheet Data Class 10 MCQ
Ch 6 Linking Spreadsheet Data Class 10 MCQ
v v v v v v v v v v v v v v v v v v v v v v v v v v v v v v v v v v v v v v v v v v v v v v v v v v v v v v v v v v v v v v v v v v v v v v v v v v v v v v v v v v v v v v v v v v v v v v v v