Computer Science Study Guide: Digital Documentation Session 02 Link Data and Spreadsheets Using Multiple Workbooks and Linking Cells Notes Set 01
Access comprehensive study materials and useful resources for LibreOffice Calc Spreadsheet using the Digital Documentation Session 02 Link Data and Spreadsheets Using Multiple Workbooks and Linking Cells Notes Set 01. Designed to align with the 2026-27 academic guidelines, these advanced resources help Computer Science students reinforce core concepts beyond standard textbooks.
Download LibreOffice Calc Spreadsheet Study Material PDF
View or download the dedicated Digital Documentation Session 02 Link Data and Spreadsheets Using Multiple Workbooks and Linking Cells Notes Set 01 resource below. Engaging with these advanced study guides under focused conditions ensures continuous academic progress and mastery of the 2026-27 curriculum for LibreOffice Calc Spreadsheet.
This page explains how to link cells across worksheets and workbooks in Calc. It covers inserting and renaming sheets, linking an external sheet, the structure of a cell reference to another file, relative and absolute hyperlinks, and linking to external data.
Linking Data and Spreadsheets
A spreadsheet also allows you to link the cells from various worksheets and from various 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
Identifying Sheets
When you open a new spreadsheet it has, by default, a sheet named Sheet1 which is managed using tabs at the bottom of the spreadsheet.
Inserting New Sheets
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 the plus icon at the bottom of the screen.
Renaming Worksheets
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.
Insert Sheet from a Different Spreadsheet
In the Insert Sheet from File dialog, if you prefer, select the Link option to insert the external sheet as a link instead of as a copy. This is one of several ways to include “live” data from another spreadsheet. The links can be updated manually to show the current contents of the external file; or, depending on the options you have selected in Tools > Options > OpenOffice Calc > General > Updating, whenever the file is opened.
Create or Change a Cell Reference
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 a formula to calculate.
In one or several formulas, you can use a cell reference to refer to:
1. Data from one or more contiguous cells on the worksheet.
2. Data contained in different areas of a worksheet.
3. Data on other worksheets in the same workbook.
Creating a Reference to Other Sheets
There are two ways to reference cells in other sheets: by entering the formula directly using the keyboard or by using the mouse. Calc can link different files together. The process is the same, but we add one more parameter to indicate which file the sheet is in.
Creating the Reference with the Keyboard
Typing the reference is simple once you know the format the reference takes. The reference has three parts to it: Path and file name . Sheet name . Cell name.
The general format for the reference is:
='file:///Path/File Name'#$SheetName.CellName
Working with Hyperlinks
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.
To change the way that OOo saves the hyperlinks in your file, select Tools > Options > Load/Save > General and choose if you want URLs saved relatively when referencing the File System, or the Internet, or both. 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. To turn existing text into a link, highlight it before opening the Hyperlink dialog.
Linking to External Data
You can insert tables from HTML documents, and data located within named ranges from an OpenOffice 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.
Insert > Link to External Data.
Related setting: Tools > Options > OpenOffice Base > Databases.
Free study material for Computer Science
CBSE Computer Science Study Material: LibreOffice Calc Spreadsheet
Core Study Kit: Computer Science LibreOffice Calc Spreadsheet
Access comprehensive study material for LibreOffice Calc Spreadsheet, including revision notes, concept maps, and high-probability questions. These resources are designed in alignment with the latest 2026 CBSE syllabus for Computer Science to support effective exam preparation.
NCERT-Aligned Solutions for LibreOffice Calc Spreadsheet
Each resource draws directly from authorized textbooks to maintain academic accuracy. Evaluating solved examples allows students to master the formal presentation and answer-writing standards expected in upcoming school exams.
Next Steps in Your Exam Preparation
Wrap up your chapter revision by testing your knowledge against standard objective question formats. Explore our full library of free, up-to-date sample papers and online assessments to secure top grades in your CBSE examinations.
FAQs
The latest 2026-27 advanced study resources for Computer Science are available for free on StudiesToday.com which includes NCERT Exemplars, high-order thinking skills (HOTS) questions, and deep-dive concept summaries.
Our exhaustive Computer Science package includes chapter wise revision notes, solved practice sheets, important formulas and Concept Maps to help in better understanding of all topics.
Yes. For , our resources have been developed to help you get better marks in school exams and also build fundamental strength needed for entrance tests including Competency Based learning.
in , students should use Active Recall method, read the concept summary, then solve the Important Questions section without looking at the answers and then check your answers.
All Computer Science study materials are provided in mobile-friendly PDF. You can download and save them on your device.
Yes, our team has ensured that all Computer Science materials for are strictly aligned with the National Education Policy (NEP) 2020 and the latest 2026-27 syllabus.