Find the broken link, then prove the repair
Watch typed cells across three worksheets, follow applied formula sources, repair references and selection rules, and test missing keys and zero units. The starting workbook deliberately contains mistakes.
A source line reads the report net, while the selected gross and net depend on that line. Follow the path across worksheets and repair the source calculation.
- Follow the closed path below. Arrows point from a formula to a cell it reads; click a cell to load its actual formula.
- Repair the source of the feedback. Preserve the five original records, the selection controls and the report meaning.
- Check the complete repair under nine changed inputs. Removing a loop by replacing a formula with a number is insufficient.
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.
Complete the applied source settings, two explanations and numeric prediction.
Loading your interactive spreadsheet…
Edit one applied cell
Suggested repair for this target
Watch cells while repairing the workbook
These are the applied workbook’s current browser values, not editor drafts. Capture a comparison baseline to see value, type or formula changes. A genuine error differs from identical text.
| Cell | Applied type/value | Applied formula | Baseline | Actions |
|---|
Follow the written workbook references
Inspect the applied cell selected above. This recalculates the current workbook and captures its values; it does not apply the editor draft or complete the practice.
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.
Current applied report
Signed quantities may cancel. This exercise defines net per unit as zero when selected units are zero. Unit prices are nonnegative; source quantities/prices allow three decimals and discounts four decimals. Watches read browser calculation snapshots, written links include unused branches, and calculation observations remain separate from native Excel debugging or edit/save certification. All worksheet data stays in this browser.