52. Why should an empty amount in an expense or attendance tracker not automatically become zero?
EasyDocuments & confidentiality
Technical
Show model answer
An empty field may mean unknown, not submitted, not applicable, or genuinely zero. Replacing every blank with zero can distort totals and hide a missing response or unresolved review.
Use clear status and missing-value conventions, check ambiguous entries with the responsible owner, and explain exclusions in summaries. A formula producing a number does not establish that the underlying information is complete.
What interviewers listen for
- Distinguish missing, inapplicable, and zero
- Resolve ambiguous entries with the owner
- Explain completeness limits in summaries