Class 10 IT 402 practical questions best for practical file

This article is provides you Class 10 IT 402 practical questions best for practical file. These are lab activities based on practical portion from Unit 2 Electronic Spreadsheet Advanced.

The complete reference

Unit 2 Electronic Spreadsheet (Advanced)

Practical topics from Electronic Spread Sheet Advanced for Class 10 IT 402 practical questions

The followings topics are marked as practical in the revised syllabus of 2020-21.

Learning OutcomeTopic
Link data and spreadsheetsCreating reference to other document by using keyboard and mouse
Share and review a
spreadsheet
Setting up a spreadsheet for sharing.

Link Data and Spreadsheet – Class 10 IT 402 practical questions

  1. Create a new file in spreadsheet software. Enter the data such as Roll no, GR NO, First Name, Last Name, Date of Birth, Father Name, Mother Name. Enter records for at least 15 students.
  2. Rename this worksheet as “Student Profile”.
  3. Insert 3 new worksheets and rename as “Periodic Test I“, “Periodic Test II” and “Periodic Test III” respectively.
  4. In the Periodic Test I worksheet create a reference for Roll No, First Name, and Last Name columns from Student Profile by using the keyboard.
  5. In the Periodic Test II worksheet create a reference for Roll No, First Name, and Last Name columns from Student Profile by using the mouse.
  6. In the Periodic Test III worksheet create a reference for Roll No, First Name, and Last Name columns from Student Profile as you wish.
  7. Apply sheet tab color as follows:
    • Profile – Red
    • Periodic Test I – Green
    • Periodic Test II – Blue
    • Periodic Test III – Yellow
  8. Now enter the marks for different subjects in the worksheets.
  9. Delete the Worksheet Perdioc Text III.
  10. Insert a new worksheet and rename as “Consolidated Worksheet“.
  11. Create different references from the Student Profile and Marks to consolidate the result.
  12. Move the worksheet to the end of the workbook sheet tab.
  13. Insert a new worksheet at the beginning.
  14. Create a hyperlink to move to a particular worksheet from the newly inserted worksheet.
  15. Delete hyperlink for the consolidated worksheet.

Suggested Post: Practical File Guide

Share and Review a Spreadsheet – Class 10 IT 402 practical questions

  1. Create a new worksheet, enter data as you wish.
  2. Save your worksheet with your desired name.
  3. Enable sharing for your worksheet.
  4. Allow every users to change the data.
  5. Enable highlight changes to your worksheet.
  6. Insert appropriate comments on the changes made by another user.
  7. Edit any two comments.
  8. Format those comments as you wish.
  9. Accept all the changes made by another users.
  10. Copy your worksheet data into new blank workbook.
  11. Insert few records into copied workbook and save it.
  12. Now open the previous worksheet.
  13. Merge compare both worksheets.

Recommended: Practical Questions for Use and Consolidating data

As per revised syllabus these are the questions for Class 10 IT 402 practical questions.

Share this practical article with your loved ones and enjoy it.

Thank you for visiting my blog. Feel free to share your views on this article.

Have a look at this also – Index Page IT 402

Leave a Reply