StudyBrixFree worksheets, study guides and courses

Computer science · lesson 2 of 4

Functions and conditions

A function that adds numerical values in a range or list.

University8 practice questionsNotes + worked examples
Take the quizStudy guideRevision sheet

Learn the ideas

Prerequisites: Basic arithmetic and computer literacy.

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.

Worked examples

Example 1

Which term best matches this description: A function that adds numerical values in a range or list.

SUM is the matching concept in this lesson.

SUM

Example 2

Which term best matches this description: A function that computes the arithmetic mean of numerical values.

AVERAGE is the matching concept in this lesson.

AVERAGE

Check your understanding

8 questions

Decimals or fractions are accepted for numeric answers. Proofs and written responses use sample answers and require human marking. This is practice, not a protected examination.

1 Which term best matches this description: A function that adds numerical values in a range or list.

Show answer and explanation

SUM

SUM is the matching concept in this lesson.

2 Which term best matches this description: A function that computes the arithmetic mean of numerical values.

Show answer and explanation

AVERAGE

AVERAGE is the matching concept in this lesson.

3 Which concept would you apply first in a situation where a conditional function choosing between outputs based on a logical test.

Show answer and explanation

IF

The scenario directly calls for IF.

4 Name the concept described as: A function counting cells that meet a stated criterion.

Show answer and explanation

COUNTIF

The intended concept is COUNTIF.

5 Which statement about SUM is most accurate?

Show answer and explanation

A function that adds numerical values in a range or list.

The definition in the lesson notes gives the required condition.

6 Explain one important difference between SUM and AVERAGE.

Sample answer and marking guidance

SUM: A function that adds numerical values in a range or list. AVERAGE: A function that computes the arithmetic mean of numerical values.

Credit a clear distinction using both definitions and an appropriate example if supplied.

7 Give a short example showing how IF would be used in practice.

Sample answer and marking guidance

A valid example should demonstrate this idea: A conditional function choosing between outputs based on a logical test.

Credit a relevant scenario that applies the concept rather than merely naming it.

8 Summarize why COUNTIF matters in the lesson “Functions and conditions”.

Sample answer and marking guidance

COUNTIF matters because A function counting cells that meet a stated criterion.

Credit the core purpose, scope and any important limitation from the notes.

Further reading and review references

These are reference links, not copied exercises, institutional endorsement or proof of independent review.