Home > CBSE IT 402 > Quizzes > IT 402 Unit 2 Electronic Spreadsheet Advanced Class 10 Practice Test: Link Data And Spreadsheet
IT 402 Unit 2 Electronic Spreadsheet Advanced Class 10 Practice Test: Link Data And Spreadsheet
Fast practice, instant feedback. Timer auto-submits when time’s up.
Avg score: 33% • Most missed: “A _________ refers to a cell or range of cells on a worksheet and can be used to…”
IT 402 Unit 2 Electronic Spreadsheet Advanced Class 10 Practice Test: Link Data And Spreadsheet
Time left 00:00
20 Questions

1. The links are always updated automatically by default in spreadsheet software if
2. Ankit is setting up multiple sheets for linking. But he is not identifying the sheets. Help him which component help to identify the worksheets?
3. There are __________ ways to rename a worksheet.
4. Ruma is working in spreadsheet software. She needs to insert a worksheet in her file. Which of the option is correct to insert the worksheet from the menu?
5. The target refers to
6. Which of the following statement is correct for cell reference with respect to linking
7. A _________ refers to a cell or range of cells on a worksheet and can be used to find the values or data for calculations.
8. Arrange the following steps for linking worksheet using the mouse in proper order:
A) select the cell address you want to use as a reference
B) place the cursor in the formula bar
C) type =
D) move to the worksheet from where you want to take reference
9. Which of the following option is not present in the insert sheet dialog
10. Which of the link will stop working if the start and target locations change the relative of each other?
11. A _________ refers to a cell or range of cells on a worksheet and can be used to find the values or data for calculations.
12. Which of the following is not a type of hyperlink?
13. Which of the link will stop working if the start and target locations change the relative of each other?
14. Link to external data option is available under _____________ menu.
15. Link to external data option is available under _____________ menu.
16. The copy and linking cells are similar.
17. The target refers to
18. Dev is reading the concept of linking to external data. But he is not understanding it. Choose the correct answer for him:
19. There are _________ ways to provide a reference for linking.
20. There are _________ ways to provide a reference for linking.

⚡ Recently practiced quizzes in this topic
Live quiz activity
IT-402 Data Entry and Keyboarding Skills Class 9 Practice Test IT 402 Important Communication Skills Class 9 Practice Test IT 402 Unit 3 RDBMS Class 10 Practice Test IT 402 Important Communication Skills Class 10 Practice Test 2 IT 402 Digital Documentation Class 10 Practice Test IT 402 ICT Skills Class 10 Practice Test 2 IT 402 Unit 2 Electronic Spreadsheet Advanced Class 10 Practice Test IT-402 Digital Documentation Class 9 Practice Test IT 402 Digital Documentation Class 10 Practice Test IT 402 Self Management Skills Class 10 Practice Test 2
 
❤ If you liked Fatskills, consider supporting us by checking out The Life Manuals You Never Got.

🌈  Our mission is to help improve your scores in any subject and exam withonline quizzes, practice tests, study guides, & advice for students. Since 2018.
About | Explore | User Guide | Topics | Subjects | Doubt Solver | Career Aptitude Test | Answers | Free Tools | OSHA Basics Quiz | What Should We Know?
Privacy | Terms |
Without work one finishes nothing. - Ralph Waldo Emerson
© 2026 Fatskills.com

All trademarks, logos and brand names are the property of their respective owners. All company, product and service names used in this website are for identification purposes only. Use of these names, trademarks and brands does not imply endorsement.