54. A spreadsheet total looks unusually low after someone filtered a shared tracker. How would you investigate?
MediumDocuments & confidentiality
Case
Show model answer
Check active filters, hidden rows, formula ranges, excluded statuses, and whether the total is meant to reflect all records or only the visible subset. Preserve the current view before changing settings other users may rely on.
Reconcile the figure against relevant source records and document the intended calculation. Do not remove filters blindly or replace a formula with a convenient manual total that conceals the underlying definition or data gap.
What interviewers listen for
- Check filters, hidden records, and formula scope
- Reconcile against source records and intended meaning
- Avoid unexplained manual overrides