AdvertisementYour brand could be hereYour brand hereOn every Darslab page · students, parents and teachersinfo@darslab.comAsk for pricesPricesinfo@darslab.com
☰ Contents · Computing

Cross-sheet references and functions

Lessons 5–6 · 2 lessons · N. I. Taylaqov (general editor), A. B. Akhmedov, M. D. Pardayeva, A. A. Abdug‘aniyev, U. M. Mirsanov. Informatics and Information Technologies, Grade 10, 1st edition. “Extremum-Press”, Tashkent, 2017
6

The function library of MS Excel

Textbook: pp. 18–20
GoalKnows the groups of the function library on the Formulas tab and uses FACT, GCD, LCM, SIGN, SQRT, SUMPRODUCT and ROUND.
New words
function argument: a value, cell or range that the function works on · funksiya argumentiGCD: the greatest common divisor of two or more whole numbers · EKUB (GCD)LCM: the least common multiple of two or more whole numbers · EKUK (LCM)ROUND: rounds a number to a chosen number of decimal places · yaxlitlash (ROUND)
Explanation

A function is a ready-made formula; it is written as its name with arguments in brackets: =NAME(arg1, arg2). Functions sit by type in the Function Library group on the Formulas tab: Financial, Logical, Text, Date & Time, Lookup & Reference, Math & Trig and More Functions (statistical and others). Among the mathematical ones: FACT(n) – n!; EXP(x) – e to the power x; SIN, COS, TAN – for an angle in radians; GCD(a, b, …) – greatest common divisor; LCM(a, b, …) – least common multiple; SIGN(x) – –1 for a negative number, 0 for zero, 1 for a positive one; SQRT(x) – square root; SUMPRODUCT(array1, array2) – the sum of the products of matching elements; ROUND(number, digits) – rounding. The separator between arguments is a comma in English settings and a semicolon in Uzbek and Russian regional settings (which also use a decimal comma). In a Russian-language interface the names differ: for example GCD is NOD, ROUND is OKRUGL, SUMPRODUCT is SUMMPROIZV.

FunctionMeaning
FACT(n)n!
EXP(x)eˣ
GCD(a, b, …)greatest common divisor
LCM(a, b, …)least common multiple
SIGN(x)–1, 0, 1
SQRT(x)square root
SUMPRODUCT(array1, array2)sum of the products of matching elements
ROUND(number, digits)rounding
💡 Where will I use this?
In real life

From a neighbourhood stop one bus leaves every 10 minutes and another every 15. Both left together at 8:00. They leave together again at 8:30, because 30 is divisible by both 10 and 15 and is the smallest such number.

Who uses it

Engineers plan timetables, tilers work out equal tile counts and programmers find repeating cycles with numbers like these.

Try it today

In your notebook write the multiples of 4 in one line and the multiples of 6 in another, and find the first number that appears in both.

Worked examples
=GCD(18,24,42) gives 6; =LCM(8,12,18) gives 72, because 72 is the smallest number that 8, 12 and 18 all divide. =SQRT(144) = 12 and =SIGN(–8) = –1.
C1fx=SUMPRODUCT(A1:A3,B1:B3)
ABC
14371
272
395
A1:A3 hold 4, 7, 9 and B1:B3 hold 3, 2, 5. =SUMPRODUCT(A1:A3,B1:B3) = 4·3 + 7·2 + 9·5 = 12 + 14 + 45 = 71. =ROUND(7.846,2) gives 7.85.
Class activity

“The function wizard”: one student says the arguments, a second finds the function name (for example, “the greatest common divisor of 18, 24 and 42”), a third calculates the result in advance; then it is checked in Excel.

Practice
1
What is the result of GCD(24, 36)?
2
A1:A2 hold 2 and 3 and B1:B2 hold 4 and 5. What is =SUMPRODUCT(A1:A2,B1:B2)?
3
What does =FACT(5) give?
4
Why is the result of =ROUND(7.846,2) equal to 7.85 and not 7.84?
Story of the Week · The Khwarizmi Way“Sugar-free”: carbohydrate-free?Close the week: all of this week’s subjects in one storyRead →