Bu'aan kutaa 12ffaa ba'eera; bu'aa kee eessatti akka ilaaltu

Boqonnaa 3 Teeknooloojii Odeeffannoo kutaa 10

Excel functions: a name, then its arguments

daqiiqaa 4 · Gaaffii qormaata darbe 2 hojjetaman

Kutaalee barnootaa

Barnoota achii jalqabee taphachiisuuf kutaa tokko tuqi.

Barnoota viidiyoo Temari daqiiqaa 4 boqonnaa 3 Teeknooloojii Odeeffannoo kutaa 10: Excel functions: a name, then its arguments. Barnoonni kun Afaan Ingiliziitiin.

Dabalata boqonnaa 3

Fuulli boqonnaa kanaa wanta Temari boqonnaa kana irratti qabu kan hafe qaba, fakkeenyaaf yaadannoo gabaabaa fi gaaffii shaakalaa deebii isaanii waliin.

Fuula boqonnaa 3 bani

Wanta barnoonni jedhu hunda

Jechoota barnootaa kutaa kutaan. Barnoota achii jalqabee taphachiisuuf yeroo tuqi.

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 1Qormaata darbe

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 2Qormaata darbe

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.

Boqonnaa kana appii keessatti shaakali

Temari boqonnaa kana gara shaakala yeroon daangeffametti jijjiira; utuu hojjettuu ni sirreessa; wanti si hin galinis barsiisaa AI tiin ni ibsama.

Bilisaan jalqabi

Temari.et appii Android qaba; Google Play irratti bilisaan argama.

SeeniHerrega kee bani