References and functions

Содержание и основные понятия

The relative reference changes when the formula is copied. The absolute reference does not change:
$E$1
A single VAT rate, rate or coefficient is readily stored. Only a column or only a row is attached to the composite links.
9-11 grade
Modelling
OGE No. 14
EEG No. 9
01
Four types of address
Recording
For copying down
When needed
B2
Line is moved; column will change only if copied sideways
Data line
$B$2
Nothing is moving.
single factor
$B2
Line Moves
fixed column
B$2
The address does not change when copying downwards; the column is moved side by side
fixed line
02
Preview Copying
$
Relative or absolute?
The simulator shows how the formula's address will change when it's moved. In the real program, check the result in the formula line.
The formula was in the box.
Copy to Cell
Reference formula
03
The function is selected on the question
fx
Signal by function
The name and division of arguments are different in the language and settings of the program. This is a clue to the meaning of the function, not a substitute for Excel or LibreOffice Calc.
What do you need?
Range or cell
04
Conditional aggregates and model
SHOULD AND BUILD
=СЧЁТЕСЛИ(E2:E200;"готово")
Counts the lines on condition.
=СУММЕСЛИ(E2:E200;"готово";D2:D200)
The range of conditions and results shall be the same.
A numerical model
Select the input parameters, the result formula and the test example. Then change one parameter, watch the count and explain why the graph confirms or refutes the assumption.
OGE No. 14
Not only are the formulas needed, but they also need to work with a large set: conditional selection, range verification, sorting and charting of the selected columns.