Workshop

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

The option is collected from the JSON-bank of tasks by accident. After each response, the review will open: its task is to explain the rule to be applied in the current table processor.
Practice
OGE No. 14
EEG No. 9
01
Accidental
question
Loading
Right.
0 / 0
02
After the test
Check the formula
Enter a similar example in Excel, LibreOffice Calc or Google Tables and change one reference number. The result should be recalculated.
Check the output
If you choose a diagram, sign the numbers and compare them to the original table: no line should disappear without being noticed.
03
Full mini laboratory
Imports.
Open the training XLSX and save a separate working copy.
Quality control.
Check the types, the empty values, the units and the repeat lines.
Truck.
Add an output column, an absolute reference to the parameter and the outcome through the conditional function.
Selection.
Apply the filter to two conditions and make sure that the formula works on the right range.
Visualization.
Draw a diagram only from the data that answer the question of the task; sign the axles and units.
Check.
Change one input and trace the dependent cells to the final response.
In the report, indicate the formula, range, selection condition and verification calculation. The screen shot without explanation does not prove the model correct.