Skip to content
Get started
ICT 0417

20. Spreadsheets

Formulae, functions, absolute and relative references, and what-if modelling.

  1. 20.1

    Formulae, functions and cell references

    Building a working model and referencing cells correctly.

    Full lesson2 questions6 cardsSimulation
    • 20.1.1Create formulae and use functions including SUM, AVERAGE, IF, COUNTIF and VLOOKUP.
    • 20.1.2Explain the difference between absolute and relative cell references and use spreadsheets for modelling.