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.
Summarize selected records from a source sheet
Use Report criteria against Transactions. Sum signed net amounts, count the selected original rows and divide by that count. A measured zero and no selected records are different results.
Align ranges from one source
All amount and criteria ranges refer to Transactions rows 2:7. Report B2 and B3 supply the region and status. A matching row must satisfy both criteria.
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 · Selected rows
- Blank
- Report!F4 · Mean per selected row
- 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.