SAMPLE — Excel audit findings by cell — REF SAMPLE-excel (all figures fictional demo values)
E3 | circular self-reference: cost cell referred to itself and could not settle | fix: =D3*0.6 (sample) -> S$3,840 (sample); row margin 40% (sample)
C5 | broken external link: price pulled from a file that is not attached | fix: typed S$48 (sample); revenue =B5*C5 -> S$8,640 (sample); no outside links remain
D6 | stale #REF!: revenue formula pointed at a deleted cell | fix: =B6*C6 (sample) -> S$4,950 (sample); row margin 40% (sample)
D7 | off-by-one total: SUM(D2:D5) left out row 6 worth S$4,950 (sample) | fix: =SUM(D2:D6) (sample) -> S$28,990 (sample); re-added by hand, ties
Oxaide • UEN 201806463W • Research, not advice • REF SAMPLE-excel
