51. Why can sorting only one column in an administrative spreadsheet create a serious error?
EasyDocuments & confidentiality
Technical
Show model answer
It can disconnect a value from the other fields belonging to the same record, such as a name from its amount or appointment. A column that looks sorted may leave the overall table factually wrong.
Use the approved full range and verify rows and totals afterward. Keep a recoverable version and coordinate shared-sheet ownership and edits before making changes.
What interviewers listen for
- Preserve whole-record relationships
- Verify rows and totals after sorting
- Use recoverable versions and shared-edit coordination