The function arguments window
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.
=AVERAGE(A1:A6) = 10
average: 3, 18, 6, 18, 11, 4
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.
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.
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.
| Argument field | Value |
|---|---|
| Number | 243 |
| Base | 3 |
| The window shows | = 5 |
| Argument field | Value |
|---|---|
| Number1 | 28 |
| Number2 | 42 |
| Number3 | 70 |
| The window shows | = 14 |
“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.