SESSION 2 -LINK DATA AND SPREADSHEETS IMPORTANT NOTES
Hello friends, Here you will find the important notes of CBSE Class 10 Information Technology Code 402. In this post you will find UNIT 2 ELECTRONIC SPREADSHEET (ADVANCED) Notes. In it Session 2-LINK DATA AND SPREADSHEETS is defined for good understanding the concepts of linking Data and Spreadsheets. You can also find the SESSION 1 Notes here..
LINK DATA AND SPREADSHEETS
Spreadsheet also allows you to link the cells from various worksheets and from various other spreadsheets to summarize data from several sources. In this manner, you can create formulas that span different sources and make calculations using a combination of local and linked information. Multiple sheets help keep information organized
SETTING UP MULTIPLE SHEETS:
Inserting new sheets:
When you open a new spreadsheet, by default, it has a sheet named Sheet1. There are several ways to insert a new sheet. The first step, in all cases, is to select the sheet that will be next to the new sheet. Then do any of the following:
Select Insert > Sheet from the menu bar, or
Right-click on the tab and select Insert Sheet, or
Click in an empty space at the end of the line of sheet tabs.
Each method opens the Insert Sheet dialog. Here you can choose to put the new sheet before or after the selected sheet and how many sheets to insert.
There are three ways you can rename a worksheet:
1.Double-click on one of the existing worksheet names.
2.Right-click on an existing worksheet name, then choose Rename from the resulting Context menu.
3.Select the worksheet you want to rename (click on the worksheet tab) and then select the Sheet option from the Format menu. This displays a submenu from which you should select the Rename option.
A cell reference refers to a cell or a range of cells on a worksheet and can be used to find the values or data that you want formula to calculate.
Referencing Other Sheets:
There are two ways to reference cells in other sheets:
- by entering the formula directly using the keyboard:
Typing the reference is simple once you know the format the reference takes. The reference has three parts to it:
a) Path and File name.
b) Sheet name.
c) Cell name.
the general format for the reference is =’file:///Path &File Name’#$SheetName.CellName.
2. By using the Mouse.
Hyperlinks can be used in Calc to jump to a different location from within a spreadsheet and can lead to other parts of the current file, to different files or even to web sites.
Relative And Absolute Hyperlinks:
Hyperlinks can be stored within your file as either relative or absolute. An absolute link will stop working only if the target is moved. A relative link will stop working only if the start and target locations change relative to each other. For instance, if you have two spreadsheets in the same folder linked to each other and you move the entire folder to a new location, a relative hyperlink will not break.
You can insert and modify links using the Hyperlink dialog. To display the dialog, click the Hyperlink icon on the Standard toolbar or choose Insert > Hyperlink from the menu bar.
Linking To External Data:
You can insert tables from HTML documents, and data located within named ranges from an OpenOffice.org Calc or Microsoft Excel spreadsheet, into a Calc spreadsheet .
You can do this in two ways: using the External Data dialog or using the Navigator.
Using the External Data dialog:
1.Open the Calc worksheet where the external data is to be inserted. This is the target worksheet.
- Select the cell where the upper left-hand cell of the external data is to be inserted.
- Choose Insert -> Link to External Data.
- On the External Data dialog, type the URL of the source worksheet or click the […] button to open a file selection dialog. Press Enter to get Calc to load the list of available tables.
- In the Available tables/range list, select the named ranges or tables you want to insert. You can also specify that the ranges or tables are updated every (number of) seconds.
- Click OK to close this dialog and insert the linked data.
Linking To Registered Data Sources:
You can access a variety of databases and other data sources and link them into Calc worksheets. First you need to register the data source with OpenOffice.org. To register a data source that is in *.odb format:
- Choose Tools -> Options -> OpenOffice.org Base -> Databases.
2. Click the New button to open the Create Database Link dialog.
3. Enter the location of the database file, or click Browse to open a file browser and select the database file.
4. Type a name to use as the registered name for the database and click OK. The database is added to the list of registered databases. The OK button is enabled only when both fields are filled in.