# Functions and conditions

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

Course: [Spreadsheet skills](https://studybrix.com/en/courses/spreadsheets/index.md)
Level: university
Prerequisites: Basic arithmetic and computer literacy.

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

## Practice questions

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

A. SUM
B. IF
C. AVERAGE
D. COUNTIF

Answer: SUM

Explanation: 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.

A. IF
B. SUM
C. AVERAGE
D. COUNTIF

Answer: AVERAGE

Explanation: 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.

A. SUM
B. AVERAGE
C. IF
D. COUNTIF

Answer: IF

Explanation: The scenario directly calls for IF.

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

Answer: COUNTIF

Explanation: The intended concept is COUNTIF.

### 5. Which statement about SUM is most accurate?

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

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

Explanation: The definition in the lesson notes gives the required condition.

### 6. Explain one important difference between SUM and AVERAGE.

Sample answer / 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.

Explanation: 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 / marking guidance: A valid example should demonstrate this idea: A conditional function choosing between outputs based on a logical test.

Explanation: 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 / marking guidance: COUNTIF matters because A function counting cells that meet a stated criterion.

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

## Further reading

- https://support.microsoft.com/excel

Original AI-assisted educational draft; not independently teacher-reviewed. References support further study, not copied exercises, affiliation or curriculum accreditation.