Lesson ProgressPhase 3 of 6
Phase 3Guided Practice
Guided Practice: Link the Three Statements: Cross‑Sheet References and Integrity Checks
Practice linking logic in a simulator before touching the live workbook
Phase 3: Safe Rehearsal
Practice Cross-Sheet Links Before the Real Build
Before you open the workbook, practice identifying the correct cross-sheet reference for each critical link. This simulator mirrors the exact linking logic you will build next.
How This Works
Each challenge shows you a source cell on one sheet and a target cell on another. Your job is to pick the correct cross-sheet formula that links them.
- Read the source and target carefully
- Choose the formula that creates a live link (not a hard-coded value)
- Submit to see whether you are correct and why
- Complete all 5 challenges before moving to the workbook sprint
Link Logic Trainer
Select the correct cross-sheet formula for each scenario.
Cross-Sheet Linking
Connect data between sheets with live formulas
Source Sheet
Income Statement
Target Sheet
Balance Sheet
Score
0/0
Progress
0/5
Challenge 1 of 5Score: 0/0
Link Net Income from the Income Statement into Retained Earnings on the Balance Sheet.
Source: Income Statement!B12 → Target: Balance Sheet!B18 (Net Income (added to RE))
SOURCE
Income Statement!B12
$10,800
Link to
Balance Sheet!B18
Bridge to Phase 4: The Workbook Sprint
In the next phase, you will open the actual TechStart workbook and build these links yourself. Here is what you need to know before you start:
- Starting file: /resources/unit03-lesson05-student.xlsx
- What is already built: Three separate tabs (Income Statement, Balance Sheet, Cash Flow) with correct numbers but no links between them
- Your job: Add cross-sheet references and integrity checks so the three statements work as one model
- Definition of Done: All three links work, all integrity checks show “OK”, and changing one number updates all statements