Computer ApplicationsICSE Class 8 · Spreadsheet: Functions and Charts

Spreadsheet Functions and Charts: SUM, AVERAGE, MAX, MIN, COUNT (ICSE Class 8)

Updated 17 October 2026 · Fact-checked

A function is a ready-made formula: begin with =, type the name, put arguments in brackets and separate them with commas. SUM, AVERAGE, MAX, MIN and COUNT work on a range, and COUNT counts only numbers. A column or bar chart compares values, a line chart shows change over time and a pie chart shows parts of a whole.

One range, B2:B6, feeds five functions; the orange cell 90 is the MAX and the blue cell 62 is the MIN.

Illustration drawn for QuestionBuddy.

Understand SUM, AVERAGE, MAX, MIN, COUNT and Creating Charts

Rules to enter a function. Begin with =; type the name correctly; put the arguments in brackets straight after the name with no space, as in =SUM(B2:B6); separate arguments with commas; use a colon for a range; close every bracket; press Enter.

Five functions (B2:B6 = 78, 85, 62, 90, 70):

Function	Does	Result
SUM	adds	385
AVERAGE	mean	77
MAX	largest	90
MIN	smallest	62
COUNT	counts cells holding numbers	5

COUNT ignores blanks and text. If C2:C5 holds 40, 55, AB, 70, then =COUNT(C2:C5) is 3, =SUM(C2:C5) is 165 and =AVERAGE(C2:C5) is 165 / 3 = 55 (text is skipped). The AutoSum button inserts =SUM for a nearby range.

Chart steps. Enter data with headings; select the range including the headings; choose Insert then Chart and a type; add title, axis titles, legend and data labels; resize it. The chart updates when data change.

Which chart.

Chart	Best for
Column or bar	comparing values (marks in subjects)
Line	change over time (temperature each month)
Pie	parts of a whole, each part as a share of 360 degrees

Parts of a chart. Title, plot area, x-axis (categories), y-axis (values), legend, data labels, gridlines.

Pie angles. A part's angle = part / total x 360. For a pocket money of 1000 rupees (invented) with 250 on books, 150 on snacks, 400 saved and 200 on others, the angles are 90, 54, 144 and 72 degrees, which add to 360.

SUM, AVERAGE, MAX, MIN, COUNT and Creating Charts: key facts

Rules for a function: Begin with =
Correct name
Arguments in brackets
Commas between
Colon for a range; No space between the name and the bracket.
Five functions: SUM adds
AVERAGE mean
MAX largest
MIN smallest
COUNT numbers only; COUNT skips text and blanks.
Which chart: Column or bar compare
Line change over time
Pie parts of a whole; A pie adds to 360 degrees.

SUM	adds
AVERAGE	mean
MAX	largest
MIN	smallest
COUNT	numbers only

Column or bar	compare
Line	change over time
Pie	parts of a whole

How to answer SUM, AVERAGE, MAX, MIN, COUNT and Creating Charts questions

Use this for functions and chart questions.

1Identify the range and which cells hold numbers.
2Choose the function and write it with =, brackets and a colon.
3Ignore text and blanks in COUNT and AVERAGE and state this.
4For a chart, decide whether the task is comparison, trend or share.
5Select the data with headings and add title and axis titles.

SUM, AVERAGE, MAX, MIN, COUNT and Creating Charts in real life

The idea, met in an everyday situation. Answer the question in your own words, then compare with the model answer. The one-line hook is what to remember.

A hypothetical weekly steps log

Suppose a student records steps for five days in B2:B6: 4000, 5500, 6000, 4500 and 5000.

Give the total, average, maximum and the best chart to show change over the week.

Try it first, then show the solutionSolution

SUM = 25000.
AVERAGE = 25000 / 5 = 5000.
MAX = 6000.
Change over time needs a line chart.

Answer: Total 25000, average 5000, maximum 6000; use a line chart.

Memory hook: Trend means line.

Tricks to remember SUM, AVERAGE, MAX, MIN, COUNT and Creating Charts

Short memory aids. Say each one aloud once, then use it on a question the same day.

SAMMC
SUM, AVERAGE, MAX, MIN, COUNT.
Use it when: The five functions.
Column compares, line travels, pie shares
Pick the chart by the job.
Use it when: Choosing a chart.

SUM, AVERAGE, MAX, MIN, COUNT and Creating Charts: solved examples

Ordered from board level to HOTS. Try each one before you open the solution.

Example 1: Which function counts numbers? · 1 mark · MCQBoard level

Which function counts only the cells that hold numbers?
(a) SUM (b) COUNT (c) MAX (d) AVERAGE

Try it first, then show the solutionSolution

COUNT counts numbers and ignores text.

Answer: (b) COUNT.

Example 2: Evaluate five functions · 2 marks · Short answerBoard level

B2:B6 holds 78, 85, 62, 90 and 70. Find SUM, AVERAGE, MAX and MIN. (2 marks)

Try it first, then show the solutionSolution

SUM = 385, AVERAGE = 385 / 5 = 77 (1).
MAX = 90, MIN = 62 (1).

Answer: SUM 385, AVERAGE 77, MAX 90, MIN 62.

Example 3: Text in the range · 4 marks · Long answerHarder board level

C2:C5 holds 40, 55, AB and 70. Find COUNT, SUM and AVERAGE and explain. (4 marks)

Try it first, then show the solutionSolution

COUNT = 3 because AB is text (1).
SUM = 40 + 55 + 70 = 165 (1).
AVERAGE uses only the numbers (1).
165 / 3 = 55 (1).

Answer: COUNT is 3, SUM is 165 and AVERAGE is 55, because the text AB is ignored by all three.

Example 4: Pie angles · 4 marks · Long answerHarder board level

A student spends 1000 rupees as: books 250, snacks 150, savings 400, others 200. Find the angle of each part in a pie chart and check the total. (4 marks)

Try it first, then show the solutionSolution

Books 250 / 1000 x 360 = 90 (1).
Snacks 150 / 1000 x 360 = 54 (1).
Savings 144 and others 72 (1).
90 + 54 + 144 + 72 = 360 (1).

Answer: Books 90, snacks 54, savings 144, others 72 degrees; they add to 360.

Example 5: Spot the function errors · 4 marks · Long answerHOTS / competency

Find the errors in: (i) =SUM B2:B6 (ii) SUM(B2:B6) (iii) =AVRAGE(B2:B6). Give the correct form and the error shown for (iii). (4 marks)

Try it first, then show the solutionSolution

(i) Brackets missing: =SUM(B2:B6) (1).
(ii) No equals sign: =SUM(B2:B6) (1).
(iii) Misspelt name: =AVERAGE(B2:B6) (1).
The error shown is #NAME? (1).

Answer: (i) needs brackets, (ii) needs an equals sign, (iii) AVERAGE is misspelt and the error shown is #NAME?. The correct form of each is =SUM(B2:B6) or =AVERAGE(B2:B6).

Where students lose marks in SUM, AVERAGE, MAX, MIN, COUNT and Creating Charts

The slips examiners see most often, and what to write instead.

Mistake: Counting text in COUNT
COUNT counts numbers only.
Wrong working
COUNT of 40, 55, AB, 70 is 4.
Right working
COUNT is 3.
Do this: Skip text and blanks.
Usually costs: 1 mark
Mistake: Selecting data without headings
The chart then has no labels.
Wrong working
Selecting B2:B6 only.
Right working
Selecting A1:B6.
Do this: Include headings.
Usually costs: 1 mark
Mistake: Using a space after the function name
Brackets follow the name immediately.
Wrong working
=SUM (B2:B6)
Right working
=SUM(B2:B6)
Do this: No space.
Usually costs: 1 mark

Exam tips

Show the function and its numerical result.
Say that COUNT and AVERAGE skip text and blanks.
Name the chart type and the reason for choosing it.
Include the headings when selecting data for a chart.

Practice questions on SUM, AVERAGE, MAX, MIN, COUNT and Creating Charts

Write each answer on paper first. Open the hint only if you are stuck, and the answer only when you have finished.

Q1 · 1 mark · MCQBoard level
Which chart best shows how temperature changes each month?
(a) Pie (b) Line (c) None (d) Only a table
Hint
Change over time.
Answer
(b) Line.
Q2 · 3 marks · Short answerBoard level
Why must the arguments of a function be placed in brackets directly after its name, and what does a comma between two arguments do? (3 marks)
Hint
Think of =SUM(B2:B6,D2).
Answer
The brackets tell the spreadsheet which values the function must work on, and the name must be followed by them with no space. A comma separates two arguments, so =SUM(B2:B6,D2) adds the range B2:B6 and also the cell D2.
Q3 · 3 marks · Short answerHarder board level
D2:D6 holds 12, 20, blank, 8 and 40. Find COUNT and AVERAGE. (3 marks)
Hint
Blank is ignored.
Answer
COUNT = 4 (12, 20, 8, 40). Sum = 80, so AVERAGE = 80 / 4 = 20.
Q4 · 4 marks · Long answerHarder board level
Months are in A1:A7 (with a heading) and rainfall in B1:B7 (with a heading). Which cells would you select to draw a chart of the change in rainfall over the months, which chart type suits, and what would you add afterwards? (4 marks)
Hint
Include the headings; trend means line.
Answer
Select A1:B7, including the headings. A line chart suits, since the data show change over time. Then add a chart title and axis titles (and a legend or data labels if needed); the chart updates automatically when the data change.
Q5 · 4 marks · Long answerHOTS / competency
A student draws a pie chart of the monthly temperature of a city. Explain why a different chart is better, and which one. (4 marks)
Hint
Pie shows parts of a whole.
Answer
A pie chart shows parts of a whole, but temperature is not a share of a total. Because the data show change over time, a line chart is better as it shows the rise and fall month by month.

Test your recall

Answer in your head or on paper first, then open the card. Pulling an answer out of memory makes it stick far better than re-reading.

1.Which function finds the largest value?Show answer
MAX.
2.What does AutoSum insert?Show answer
=SUM for a nearby range.
3.What is AVERAGE of 78, 85, 62, 90, 70?Show answer
77.
4.Which chart shows parts of a whole?Show answer
Pie.
5.What is the legend?Show answer
It shows which colour is which series.
6.Do text cells count in COUNT?Show answer
No.

SUM, AVERAGE, MAX, MIN, COUNT and Creating Charts: frequently asked questions

Is a function case-sensitive?

No, the name is not case-sensitive.

Do charts update with data?

Yes, automatically.

Where is the Name Box?

To the left of the formula bar.