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

The function wizard and the formula bar

Lessons 7–8 · 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
7

The function arguments window

Textbook: pp. 20–22
GoalEnters a function through the Insert Function wizard and the Function Arguments window; uses LOG, LN, LOG10 and GCD.
New words
Insert Function: the wizard that finds a function and puts it in the cell · Insert Function (fx)Function Arguments window: the dialog with a field for each argument and a preview of the result · Function Arguments oynasilogarithm: the power to which the base must be raised to get the number · logarifmcollapse button: shrinks the dialog so that a range can be chosen with the mouse · diapazonni yig‘ish tugmasi
Explanation

If you cannot remember a function name, you find it through the wizard: press the fx button next to the formula bar, or Formulas – Insert Function (Shift+F3). In the first step you search for the function by description or choose a category; in the second step the Function Arguments window opens, with a separate field for each argument, a description of the function and a preview of the result. The button beside a field collapses the window so that a range can be chosen easily with the mouse. When you press OK, the finished formula goes into the cell. The logarithm function is written LOG(number, base): if no base is given, 10 is used; LN(x) is the natural logarithm (base e) and LOG10(x) the common logarithm. For example LOG(243, 3) = 5, because 3⁵ = 243.

A3A118A26A318A411A54A6=AVERAGE(A1:A6) → 10

=AVERAGE(A1:A6) = 10

average: 3, 18, 6, 18, 11, 4

💡 Where will I use this?
In real life

A pupil wants to write a logarithm in a table but cannot remember the function name. Instead of guessing, the pupil typed “logarithm” into the function search, chose the right function and read what each box in the window asks for. The formula was right at the first try.

Who uses it

Analysts, students and bookkeepers use help windows to write functions whose names they do not know well. Logarithmic scales are also used to measure sound level and earthquakes.

Try it today

In your notebook count how many times you can halve 128 before you reach 1. This is very close to what a logarithm to base 2 means.

Worked examples
=LOG(243,3)
Argument fieldValue
Number243
Base3
The window shows= 5
Finding log₃ 243: fx → Math & Trig → LOG; 243 goes into the Number field and 3 into the Base field, the window shows “= 5”, and OK puts =LOG(243,3) in the cell. In the same way =LOG(8,2) = 3 and =LOG10(1000) = 3.
Argument fieldValue
Number128
Number242
Number370
The window shows= 14
The greatest common divisor of 28, 42 and 70: fx → GCD; Number1 = 28, Number2 = 42, Number3 = 70. The window shows 14, because 28 = 2·14, 42 = 3·14, 70 = 5·14 and 2, 3, 5 have no common divisor except 1.
Class activity

“Call the wizard”: the teacher poses a task (“the logarithm of 64 to base 4”); students find the function through fx, fill in the argument fields and compare the preview in the window with the answer they calculated in their notebooks.

Practice
1
What is =LOG(81,3) and why?
2
What is the result of =LN(1)?
3
If no base is given, to which base is =LOG(100) calculated and what is the result?
4
Why is the Function Arguments window convenient for a complex function?
Story of the Week · The Khwarizmi WayIf Earth’s history were one dayClose the week: all of this week’s subjects in one storyRead →