StudyBrixFree worksheets, study guides and courses

Computer science · University

Functions and conditions

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

Make a worksheet

Prerequisites

Basic arithmetic and computer literacy.

Study notes

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

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

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

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

    1. SUM
    2. AVERAGE
    3. IF
    4. COUNTIF

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

  3. Which statement about SUM is most accurate?

    1. A conditional function choosing between outputs based on a logical test.
    2. A function that computes the arithmetic mean of numerical values.
    3. A function counting cells that meet a stated criterion.
    4. A function that adds numerical values in a range or list.

  4. Explain one important difference between SUM and AVERAGE.

Answers and marking guidance

Answers and marking notes
  1. IF

    The scenario directly calls for IF.

  2. COUNTIF

    The intended concept is COUNTIF.

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

    The definition in the lesson notes gives the required condition.

  4. 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.

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.