← Back to the activity

Grade 8 Computer Science — Spreadsheet functions

Work out what SUM, AVERAGE, MAX, MIN, COUNT and IF show for a sheet you are given.

Name: ________________________

  1. 1.A sheet holds C1 = 14, C2 = 3, C3 = 20 and C4 = 8. What number does this formula show?

    =MAX(C1:C4)

  2. 2.A sheet holds E1 = 5, E3 = 9 and E4 = 2, and E2 has been left empty. COUNT looks at a range and counts only the cells holding a number. What number does this formula show?

    =COUNT(E1:E4)

  3. 3.A sheet holds D1 = 12, D2 = 45, D3 = 7 and D4 = 31. What number does this formula show?

    =MIN(D1:D4)

  4. 4.A sheet holds G1 = 72. This formula is typed into G2. What does G2 show?

    =IF(G1 > 50, "Pass", "Try again")

  5. 5.A sheet holds M1 = 9, M2 = 4, M3 = 15 and M4 = 4. Sort each formula by whether it shows 15.

    Groups: Shows 15 · Shows something else

    • =M3
    • =MIN(M1:M4)
    • =SUM(M1:M2)+2
    • =SUM(M2:M4)
    • =COUNT(M1:M4)
    • =MAX(M1:M4)

  6. 6.A sheet holds R1 = 4 and R2 = 6, and R3 has been left empty. What number does this formula show?

    =AVERAGE(R1:R3)

  7. 7.A sheet holds H1 = 60. This formula is typed into H2. What does H2 show?

    =IF(H1 >= 60, "Full marks", "Not yet")

  8. 8.A sheet holds V1 = 10, V2 = 4, V3 = 16 and V4 = 6. What number does this formula show?

    =MAX(V1:V4) - MIN(V1:V4)

Answer key — Grade 8 Computer Science — Spreadsheet functions

  1. 1. 20
  2. 2. 3
  3. 3. 7
  4. 4. Pass
  5. 5. =MAX(M1:M4) → Shows 15; =SUM(M2:M4) → Shows something else; =MIN(M1:M4) → Shows something else; =M3 → Shows 15; =SUM(M1:M2)+2 → Shows 15; =COUNT(M1:M4) → Shows something else
  6. 6. 5
  7. 7. Full marks
  8. 8. 12