Ten hard questions to ask or be asked

1Have formulas, such as the sum of a column, been entered correctly?[*]

[*] Believe it or not, I know of one quantity surveyor’s office where all the totals were being found with a calculator and then keyed into the spreadsheet by hand.

2Has the correct order of complex calculations been preserved with brackets?
3Does the word ‘Circular’ appear in the status bar, indicating that a formula erroneously references itself?
4Is any part of a text entry erroneously truncated by the value in the next cell?
5Has any row or column been omitted or truncated during printing because it did not fit in the printable area of the paper?
6Have all relevant columns been correctly included when sorting a list? (For example, ...

Get The Definitive Guide to Business Finance: What smart managers do with the numbers, Second Edition now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.