Scribd
Upload
522 views1 page

Electronic Spreadsheet Notes

The document discusses key topics in working with electronic spreadsheets, including using scenarios and goal seek to analyze data, linking data between multiple spreadsheet sheets and external documents, sharing and reviewing spreadsheets collaboratively with comments and tracked changes, and using macros to automate tasks. The topics are broken into sections on data analysis, linking data, sharing/reviewing spreadsheets, and using macros.

Uploaded by

Harshith Tata
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as DOCX, PDF, TXT or read online on Scribd
522 views1 page

Electronic Spreadsheet Notes

The document discusses key topics in working with electronic spreadsheets, including using scenarios and goal seek to analyze data, linking data between multiple spreadsheet sheets and external documents, sharing and reviewing spreadsheets collaboratively with comments and tracked changes, and using macros to automate tasks. The topics are broken into sections on data analysis, linking data, sharing/reviewing spreadsheets, and using macros.

Uploaded by

Harshith Tata
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as DOCX, PDF, TXT or read online on Scribd
You are on page 1/ 1

ELECTRONIC SPREADESHEET

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

You might also like