Find Preliminary Exam Notes
  • Home
  • About Us
  • CBSE Class 9
    • Class 9 Maths
    • Class 9 Science
    • CBSE CLASS 9 SOCIAL SCIENCE
    • Information Technology Class 9
    • MCQ
  • CBSE Class 10
    • Class 10 Chemistry
    • Class 10 Physics
    • Hindi Grammar Class 10
    • Class 10 English
    • Information Technology Class 10
    • Class 10 Social science
    • MCQ
  • CBSE Class 11
    • Class 11 BIOLOGY
    • Class 11 Chemistry
    • Class 11 Computer Science
    • Class 11 Maths
    • Class 11 PHYSICS
    • MCQ
  • CBSE Class 12
    • Class 12 Biology
    • Class 12 Chemistry
    • Class 12 Physics
    • Class 12 Hindi
    • Class 12 Maths
    • MCQ
  • Article
    • Mechanical
    • Electrical
    • Computer Science
    • Instrument
    • Safety
    • NCERT
    • Books
Facebook Twitter Instagram
  • HOME
  • Contact Us
  • About Us
  • Terms and Conditions
  • Privacy Policy
Facebook Twitter Instagram Pinterest Vimeo
Find Preliminary Exam Notes
  • Home
  • About Us
  • CBSE Class 9
    • Class 9 Maths
    • Class 9 Science
    • CBSE CLASS 9 SOCIAL SCIENCE
    • Information Technology Class 9
    • MCQ
  • CBSE Class 10
    • Class 10 Chemistry
    • Class 10 Physics
    • Hindi Grammar Class 10
    • Class 10 English
    • Information Technology Class 10
    • Class 10 Social science
    • MCQ
  • CBSE Class 11
    • Class 11 BIOLOGY
    • Class 11 Chemistry
    • Class 11 Computer Science
    • Class 11 Maths
    • Class 11 PHYSICS
    • MCQ
  • CBSE Class 12
    • Class 12 Biology
    • Class 12 Chemistry
    • Class 12 Physics
    • Class 12 Hindi
    • Class 12 Maths
    • MCQ
  • Article
    • Mechanical
    • Electrical
    • Computer Science
    • Instrument
    • Safety
    • NCERT
    • Books
Find Preliminary Exam Notes
You are at:Home»CBSE Class 10»Electronic Spreadsheet Class 10 Notes PDF | Class 10 IT Spreadsheet Notes PDF
CBSE Class 10

Electronic Spreadsheet Class 10 Notes PDF | Class 10 IT Spreadsheet Notes PDF

jyoti guptaBy jyoti guptaFebruary 21, 2021Updated:March 9, 2022No Comments2 Mins Read29 Views
Facebook Twitter Pinterest Telegram LinkedIn Tumblr Email Reddit
Electronic Spreadsheet Class 10 Notes PDF
Electronic Spreadsheet Class 10 Notes PDF
Share
Facebook Twitter LinkedIn Pinterest WhatsApp Email

Electronic Spreadsheet. In this post, we have shared class 10 IT unit 2 spreadsheet notes. The Electronic Spreadsheet Notes PDF has been given below. You can download the Electronic Spreadsheet Notes PDF for free.

Electronic Spreadsheet Class 10 Notes PDF
Electronic Spreadsheet Class 10 Notes PDF

This unit of the spreadsheet is explained in the video below so you can study this first and then jump into the Electronic Spreadsheet MCQ-type questions. Answers are at the end of this post.

Table of Contents

  • Electronic Spreadsheet Notes
  • Electronic Spreadsheet Class 10 Notes PDF

Electronic Spreadsheet Notes

  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.

  1. 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.
  2. 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.
  3. 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

Electronic Spreadsheet Class 10 Notes PDF

DOWNLOAD NOTES – CLICK HERE

Also See: Class 10th Information Technology Digital Documentation Question Bank

Electronic Spreadsheet MCQ with Answers

I hope this post helped you get the ELECTRONIC SPREADSHEET ADVANCED NOTES. Please share these CLASS 10 IT SPREADSHEET NOTES with your friends. Yes, you can score full marks after reading these IT CLASS 10 SPREADSHEET NOTES PDF..

class 10 electronic spreadsheet notes electronic spreadsheet class 10 explanation electronic spreadsheet class 10 mcq electronic spreadsheet class 10 ppt electronic spreadsheet class 9 notes pdf spreadsheet class 10 notes 402 unit 2 electronic spreadsheet (advanced class 10) pdf unit 4 spreadsheet class 10 notes
Share. Facebook Twitter Pinterest LinkedIn Reddit WhatsApp Telegram Email
Previous ArticleBasic Electrical In Hindi – इलेक्ट्रिकल बेसिक
Next Article Digital Documentation Important Questions For IT (402) Class 10
jyoti gupta
  • Website

Related Posts

NEET UG 2023 परिणाम: कैसे चेक करें

June 14, 2023

NEET Result 2023 Declared, Check NTA NEET UG Results on neet,nta.nic.in link here

June 13, 2023

CBSE Class 10 Artificial Intelligence Questions and Answers

March 29, 2023

Leave A Reply Cancel Reply

© 2023 PreliminaryExam. Designed by PreliminaryExam & Team.
  • HOME
  • Contact Us
  • About Us
  • Terms and Conditions
  • Privacy Policy

Type above and press Enter to search. Press Esc to cancel.