Computer science · University
Functions and conditions · revision notes
A function that adds numerical values in a range or list.
Key ideas and conditions
SUM
A function that adds numerical values in a range or list.
AVERAGE
A function that computes the arithmetic mean of numerical values.
IF
A conditional function choosing between outputs based on a logical test.
COUNTIF
A function counting cells that meet a stated criterion.
Explain without looking
- Give a short example showing how IF would be used in practice.
- Summarize why COUNTIF matters in the lesson “Functions and conditions”.
Further reading and review references
These are reference links, not copied exercises, institutional endorsement or proof of independent review.
AI-assisted preview; independent educational review required. Level labels describe prerequisites, not accreditation or official curriculum alignment.