የ10ኛ ክፍል የመረጃ ቴክኖሎጂ ምዕራፍ 3
Excel functions: a name, then its arguments
4 ደቂቃ · የተሠሩ 2 ያለፉ የፈተና ጥያቄዎች
የትምህርቱ ክፍሎች
ትምህርቱን ከዚያ ጀምሮ ለማጫወት አንድ ክፍል ይንኩ።
የ10ኛ ክፍል የመረጃ ቴክኖሎጂ ምዕራፍ 3 የ4 ደቂቃ የ Temari ቪዲዮ ትምህርት፦ Excel functions: a name, then its arguments። 2 ያለፉ የፈተና ጥያቄዎችን ደረጃ በደረጃ ይሠራል። በነጻ ይታያል፤ መለያ አያስፈልግም። ትምህርቱ በእንግሊዝኛ ነው።
ስለ ምዕራፍ 3 ተጨማሪ
የምዕራፉ ገጽ Temari በዚህ ምዕራፍ ላይ ያለውን ሌላውን ይዟል፤ ለምሳሌ አጭር ማስታወሻዎችና የመልመጃ ጥያቄዎች ከመልሶቻቸው ጋር።
የምዕራፍ 3 ገጽ ይክፈቱትምህርቱ የሚናገረው ሁሉ
የትምህርቱ ቃላት በየክፍሉ። ትምህርቱን ከዚያ ጀምሮ ለማጫወት ሰዓቱን ይንኩ።
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 1ያለፈ ፈተና
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 2ያለፈ ፈተና
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.
ይህን ምዕራፍ በመተግበሪያው ይለማመዱ
Temari ይህን ምዕራፍ ወደ ጊዜ የተቆረጠለት መልመጃ ይለውጠዋል፣ እየሠሩ ያርምዎታል፤ ያልገባዎትንም የሚያብራራ የ AI አስተማሪ አለ።
በነጻ ይጀምሩTemari.et ለ Android ስልኮች መተግበሪያ አለው፤ በ Google Play ላይ በነጻ ይገኛል።

