Spreadsheets: check a total before you share it

8 questions · about 10 minutes. Pass mark 70%.

1. Which formula adds the numbers in A1 to A20 and skips text in that range?
2. Two people have edited two copies of the same workbook. What is the sound first step?
3. A total looks too small. What do you check before you announce it?
4. Someone asks you to change last month's sales so the chart looks better. What do you do?
5. A total looks low and a filter is on. What do you check first?
6. A manager asks for this month's sheet. What do you send?
7. You copied a formula down and the new row is wrong. What do you check?
8. A colleague wants last week's figures replaced with this week's target. What do you do?