Class 7 Computer Science — Reading spreadsheet formulas

Read a spreadsheet formula, work out which cells it refers to, and say what number it will show.

Name: ________________________

1.A sheet holds B1 = 7 and B2 = 3. What number does the formula "=B1*B2" show?
2.A sheet holds A1 = 4, A2 = 6 and A3 = 9. What number does the formula "=A1+A2" show?
3.A sheet holds C1 = 20 and C2 = 4. What number does the formula "=C1/C2" show?
4.A sheet holds A1 = 9 and A2 = 3, and a cell holding "=A1/A2" is showing 3. You then change A1 to 12. What does that cell show now?
- a) 3
- b) It keeps showing 3 until the formula is typed in again
- c) 4
- d) 12
5.A sheet holds A1 = 3, A2 = 8 and A3 = 2. Put these formulas in order of the number each one shows, smallest first.
- =SUM(A1:A3)
- =A1+A2
- =A1-A3
- =A3*A1
- =A2*A3
6.A cell sits in column C, in the fourth row down. Write its cell reference.
7.The same sheet holds A1 = 4, A2 = 6 and A3 = 9. What number does the formula "=A3-A1" show?
8.A sheet holds A1 = 2, A2 = 5, A3 = 8 and A4 = 1. What number does the formula "=SUM(A1:A4)" show?

Answer key — Class 7 Computer Science — Reading spreadsheet formulas