Spreadsheets, Properly · Course check

Course check

3 questions. Get them all right and the Working Shown seal is yours. Get one wrong and you can reread and try again — as many times as you like, and nothing is recorded against you.

1. What is the test of a good spreadsheet?

   That the totals are correctThat a second person can trace every number and disagree with a specific cellThat it uses advanced formulas efficiently

2. Why should you never type a number inside a formula?

   It slows the file downHidden numbers cannot be found or updated, so the sheet fails silentlyFormulas should only reference other formulas

3. What does it usually mean if a total does not move when it should?

   The assumption was correctThe sheet needs recalculatingA formula is pointing at the wrong cell