Electronic spreadsheet Class 10 IT Code 402 Notes PDF

Unit 2: Electronic spreadsheet Class 10 IT Code 402

CBSE class 10 IT code 402 Electronic Spreadsheet Notes. In class 10 IT code 402 there are two parts One is Employability Skills and the other is Subject Specific skills. In unit 2 The chapter is an Electronic Spreadsheet. Here you will get complete notes of IT code 402 Electronic Spreadsheet advance. Go through this article and download topic wise notes for free, all the notes are according to the new pattern of CBSE examination of class 10.

1. Analyse data using scenarios and goal seek.

In Unit 2 of Information Technology code 402 Class 10 you are going to read about spreadsheets. In the very first topic scenarios and goal seek are present. First of all consolidating data is to be read. this is very important for spreadsheets. Then subtotal and scenarios. Goal seek is another important topic you should keep in mind. There will be at least one question related to goal seek.

• Using consolidating data.
• Creating subtotals.
• Using “what if” scenarios.
• Using “what if” tools.
• Using goal seek and solver.

2. Link spreadsheet data

In this topic, we are going to learn linking data to spreadsheets. The following topics given below are discussed. 

• Setting up multiple sheets.
• Creating reference to other sheets by using keyboard and mouse.
• Creating reference to other document by using keyboard and mouse.
• Relative and absolute Hyperlinks.
• Hyperlinks to the sheet.
• Linking to external data.
• Linking to registered data sources.

3. Share and review a Spreadsheet

• Setting up a spreadsheet for sharing.
• Opening and saving a shared spreadsheet.
• Recording changes.
• Add, Edit and Format the comments.
• Reviewing changes - view, accept or reject changes.
• Merging and comparing.

4. Use Macros in Spreadsheet

• Using the macro recorder.
• Creating a simple macro.
• Using a macro as a function.
• Passing arguments to a macro.
• Passing the arguments are as values.
• Macros to work like built-in functions.
• Accessing cells directly.
• Sorting the columns using macro

Download The PDF: Click Here

I hope you all have got benefitted from these notes. These notes will definitely help you in your board examinations. If you really think that our work helps you then please comment below your feedback.