Grade 12 results are out. Where to check yours

Grade 10 Information Technology unit 3

Excel functions: a name, then its arguments

4 min · 2 past exam questions worked through

Parts of the lesson

Tap a part to play the lesson from there.

A 4-minute Temari video lesson on Grade 10 Information Technology unit 3: Excel functions: a name, then its arguments. Free to watch, no account needed.

More on unit 3

The chapter's own page holds the rest of what Temari has on it, such as short notes and practice questions with their answers.

Open the unit 3 page

Everything the lesson says

The lesson's words, part by part. Tap a time to play the lesson from there.

0:00Introduction

Excel can add up a whole column of marks with one short function. But a function only works when you write it the right way. Learn its three parts, and the five functions you will use most.

0:12The parts of a function

A function is a formula that is already built into Excel. It does a calculation for you, using the values you give it. The right way to write a function is called its syntax.

The syntax has three parts. First, an equal sign. Then the function's name, like AVERAGE. Then one or more arguments, inside parentheses. Arguments hold the information you want to calculate. So, equals AVERAGE, B1 colon B9, finds the average of the cells from B1 to B9. The colon means every cell from the first to the last.

0:52Five common functions

Excel has many functions. Here are the five you will use most. SUM adds up all the values in its argument. AVERAGE adds them, then divides by the number of cells.

COUNT counts how many cells hold numbers. It does not add them up, it only counts them. MAX gives the highest value, and MIN gives the lowest. The AutoSum command, on the Home tab, can put any of these five into a cell for you.

1:20Practice question 1Past exam

Here is a practice question. A school in Hawassa needs to count the number of cells that contain numerical test scores in a range. Which Excel function should they use? Pause the video, and try it.

The school wants to know how many cells hold a score, not what the scores add up to. Counting cells with numbers is the job of COUNT. The answer is A. SUM would add the scores together. MAX would give only the highest score. And AVERAGE would give the mean score.

1:58More than one argument

A function can take more than one argument. Then you separate the arguments with commas. Look at this one: equals SUM, A1 colon A3, comma, C1 colon C2, comma, E2. It has three arguments. Two are ranges, and one is a single cell, E2. Excel adds every cell in all three.

So each mark has its own job. The colon joins the two ends of a range. The comma separates one argument from the next. And the parentheses hold all the arguments together.

2:37Practice question 2Past exam

Try this one. In Microsoft Excel, what punctuation mark must be used to separate multiple arguments in a function like the SUM function on the card? Pause, and try it.

Look at the function. Between A1 colon A3 and C1 colon C2 there is a comma, and another before E2. Commas separate the arguments. The answer is A. A semicolon is not used in your book's functions. The colon is inside each range, joining its two ends. And a forward slash does not separate anything here.

3:20Summary

So remember. A function is an equal sign, a name, then its arguments in parentheses. COUNT counts the cells with numbers, while SUM adds them. And commas separate the arguments, while a colon makes a range. Keep practising questions like these on Temari.et.

Practise this unit in the app

Temari turns this chapter into timed practice and marks it as you go, with an AI tutor to explain anything that did not land.

Start free

Temari.et is also an Android app, free on Google Play.

Sign inCreate your account