Q1
What does the AVERAGE function calculate?
AThe mean of a group of numbers
BThe largest number
CThe smallest number
DNothing useful
ICSEClass 6 (ICSE)Computer ApplicationsCh 2 · Topic 2
Topic 2: Using Basic Functions (AVERAGE, MAX, MIN)
Spreadsheet functions like AVERAGE, MAX, and MIN help us quickly calculate the average, highest, and lowest values in a set of data.
Core concept
The AVERAGE function calculates the mean of a group of numbers, like finding the average marks of students in a class.
How it works
The MAX function finds the largest number in a group, like finding the highest score in a test.
Why it matters
The MIN function finds the smallest number in a group, like finding the lowest temperature recorded in a week.
Key detail
Using these functions saves time and helps us quickly analyse data without manually calculating each value.
Exam highlight
Key diagram
- A picture showing a column of scores with three formula results below: average, max and min.
Keywords worth remembering
Trending
spreadsheet functionsICSE class 6 computers
Most searched
ICSE class 6 average max min functions
Study resources
Notes & downloads
Quick notes
• AVERAGE calculates the mean of numbers.
• It finds average marks or scores.
• MAX finds the largest number in a group.
• It finds the highest score, for example.
• MIN finds the smallest number in a group.
• It finds the lowest value, like temperature.
• These functions save time.
• They help analyse data quickly.