Connect worksheets without losing the source
Build real cross-sheet formulas, edit the linked records and check a complete report.
Explain the source, then prove the actual formula
Apply or clear pending editor drafts first. This lesson predicts from original source values; the complete current and changed-input workbook check is required separately.
Enter and apply each Report formula, or apply the worked example before investigating it. A visible formula draft is separate from the actual worksheet. Saved checks record an attempt, not independent authorship.
Complete the applied source settings, two explanations and numeric prediction.
Select the source worksheet through a real cell
Change Report B2 to select one complete local source. Build an escaped text reference, keep literal Team criteria and distinguish a zero net from no matching records.
Use the source name stored in Report B2
The chooser writes a real worksheet cell. Opening a different tab changes only your view. An unknown name produces a reference error until B2 is repaired.
Team reference text: ''!B2:B7. The formula builds this text from B2; changing B2 supplies a new local reference.
Read the actual source-name control
Report B2 stores a worksheet name. Selecting a visible tab only changes the view; editing B2 changes the source used by these formulas.
Loading your interactive spreadsheet…
Enter Report formulas
The editor draft is applied only when you choose Apply. Checking always reads the formulas currently in the workbook, including edits made directly in the grid.
- Report!F2 · Selected net
- Blank
- Report!F3 · Matching rows
- Blank
- Report!F4 · Mean net
- Blank
Follow the written workbook references
Inspect the applied Report result selected above. This recalculates the current workbook and captures its values; it does not apply the editor draft or complete the practice.
Edit a literal cell with the form
Use this on a phone or to preserve a text ID such as 001. Source rows must retain their headers and declared area; added records and formulas in data cells withhold grading.
See the applied formula calculate
Select a formula from any worksheet. This copies the complete current workbook for two local calculations; it does not apply the editor draft or complete practice.
This cell has no applied formula. Enter one in the workbook or apply an example first.
Highlighting covers unqualified A1 ranges on the selected worksheet. Use the written-source inspector above to navigate qualified references.
Inspect the current formula
Read its written arguments or observe actual operation values in a separate local calculation. This action neither applies a draft nor grades an answer.
Calculate observations to inspect arithmetic, comparison, concatenation and reference operators. No operation values have been recorded yet.
These original workflows use fixed source ranges, literal inputs and separate scalar result cells. Price/amount inputs use whole cents within ±1,000,000 (prices nonnegative); quantities are whole numbers 0–10,000. Data and query cells do not accept formulas. The 3-D workflow adds bounded source-order moves and same-layout aggregates. Cross-workbook connections, endpoint moves/deletion, general multi-sheet tracing and native edit/save remain separate capabilities. The text-cleanup workflow instead uses six basic-Latin/NBSP records with bounded text rules. It preserves protected fields, checks each intermediate result and tests ten changed source/control scenarios; it does not infer a universal cleanup policy.