Question 1
What is a cross-sheet reference?
It is a formula that uses a cell from another worksheet, such as a summary formula that refers to a value on the Sales sheet.
What to learn
Organise multiple sheets, reference cells across worksheets or documents, and create relative or absolute hyperlinks. Links to external and registered data sources can connect a workbook with information stored elsewhere.
- A workbook can separate related data into multiple sheets.
- A cross-sheet reference points to a cell in another sheet.
- Relative links change when the source location changes; absolute links specify a fixed target.
- External data links should be refreshed and checked for accuracy.
Practical activity
Create a workbook with Sales and Summary sheets. Link the total from Sales into Summary, add a hyperlink back to the source sheet and test the workbook after saving it in a new folder.
Use your school’s prescribed software version and teacher instructions. Keep personal information out of public practice files.
Solved CBSE-style questions
These questions and answers are original practice written for this guide; they are not copied from past papers.
Question 2
Why check links after moving a workbook?
A relative link depends on the location of files. Moving the workbook or its source can break that path.
Question 3
When is a hyperlink useful in a workbook?
It provides a quick route to another sheet, document or resource, helping users navigate supporting information.
Revision checklist
- Can I explain the key terms without memorising a definition alone?
- Can I complete the listed practical task and describe each step?
- Can I apply the idea to a new example and explain why my answer works?
Aligned to the CBSE 2026–27 syllabus outline. Check the official subject curriculum and your school’s textbook/material for the prescribed scope.