← Back to the activity

Grade 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. 1.The same sheet holds A1 = 4, A2 = 6 and A3 = 9. What number does the formula "=A3-A1" show?

  2. 2.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

  3. 3.A sheet holds A1 = 2, A2 = 5, A3 = 8 and A4 = 1. What number does the formula "=SUM(A1:A4)" show?

  4. 4.A sheet holds D1 = 12, D2 = 15 and D3 = 9. What number does the formula "=SUM(D1:D3)" show?

  5. 5.A sheet holds C1 = 20 and C2 = 4. What number does the formula "=C1/C2" show?

  6. 6.A sheet holds A1 = 10 and A2 = 4. Match each formula to the number it shows.

    • =A1+A2
    • =A1-A2
    • =A1*A2
    • =A1/A2
    • =A2*A2
    • 40
    • 16
    • 6
    • 14
    • 2.5

  7. 7.Sort each formula by whether it adds its cells together or multiplies them.

    Groups: Adds · Multiplies

    • =D1*D2
    • =A1+A2
    • =B2*B3
    • =SUM(C1:C5)
    • =E1*E2
    • =A4+B4

  8. 8.A sheet holds B1 = 7 and B2 = 3. What number does the formula "=B1*B2" show?

Answer key — Grade 7 Computer Science — Reading spreadsheet formulas

  1. 1. 5
  2. 2. c) 4
  3. 3. 16
  4. 4. 36
  5. 5. 5
  6. 6. =A1+A2 → 14; =A1-A2 → 6; =A1*A2 → 40; =A1/A2 → 2.5; =A2*A2 → 16
  7. 7. =A1+A2 → Adds; =B2*B3 → Multiplies; =SUM(C1:C5) → Adds; =D1*D2 → Multiplies; =A4+B4 → Adds; =E1*E2 → Multiplies
  8. 8. 21