← Back to the activity

Class 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 M1 = 9, M2 = 4, M3 = 15 and M4 = 4. Sort each formula by whether it shows 15.

    Groups: Shows 15 · Shows something else

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

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

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

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

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

  4. 4.A column of twelve cells holds nine numbers and three pieces of writing. What does a COUNT over the whole column show?

    • a) 12
    • b) 0
    • c) 3
    • d) 9

  5. 5.A sheet holds B2 = 6, B3 = 11, B4 = 4 and B5 = 9. What number does this formula show?

    =AVERAGE(B2:B5)

  6. 6.A sheet holds S1 = 30. This formula is typed into S2. What does S2 show?

    =IF(S1 > 30, "Over", "Not over")

  7. 7.A sheet holds Q1 = 3, Q2 = 12, Q3 = 6 and Q4 = 9. Put these formulas in order of the number each one shows, smallest first.

    • =AVERAGE(Q1:Q4)
    • =SUM(Q1:Q4)
    • =COUNT(Q1:Q4)
    • =MAX(Q1:Q4)
    • =MIN(Q1:Q4)

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

    =MIN(D1:D4)

Answer key — Class 8 Computer Science — Spreadsheet functions

  1. 1. =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
  2. 2. Full marks
  3. 3. Pass
  4. 4. d) 9
  5. 5. 7.5
  6. 6. Not over
  7. 7. 1. =MIN(Q1:Q4) 2. =COUNT(Q1:Q4) 3. =AVERAGE(Q1:Q4) 4. =MAX(Q1:Q4) 5. =SUM(Q1:Q4)
  8. 8. 7