Electronic tables

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

The table is not useful because it has many cells. It links data, formulas, and conclusion: the reference values can be checked, calculated, and the diagram is not accepted as proof. The trainers of this chapter model separate actions, but do not replace Excel, LibreOffice Calc or Google Tables.
GEF · 9-11
Data processing
OGE No. 14
EEG No. 9
01
How the Table Thinks
The column usually holds one sign, the line is one object, and the formula describes the calculation rule.
Data
Enter the number as the number, date as the date, text as the signature. Do not mix the unit of measure in one column.
Formula
Starts with the sign.
=
takes the values from the cells and is recalculated when the input data changes.
Conclusion
Sorting, filter, and diagram answer the question to the data, not adorn the sheet.
02
Alt addiction chart
Mobile Visualizer
Change the entrance - count the total
Cells A1, B1 and D1 are manually inserted. The arrows show which formulas receive the new value.
A1 · price,
B1 · number
D1 · discount, %
A1
price
B1
Number
C1
Amount
D1
discount
E1
Total
C1
=A1*B1
E1
=C1*(1-D1/100)
Outcome not entered manually
03
Headway
48.1
Cells and formulae
Cell address, order of action, formulas, and computation check.
48.2
References and functions
Relative and absolute references, ranges, IMSS and ESA.
48.3
Sorting and Charts
Order of lines, filter, and choice of honest way to show data.
48.4
Workshop
Random questions on OGE No. 14 and EEG No. 9 with reviews.
48.5
Skills testing
Eight-minute diagnostics and work item in this table.
48.6
OEG 14 Laboratory
Qualitative calculations, range verification and diagram.
04
Minimum verification
Before concluding:
If you can delete or add the string, do not manually enter the result: let the formula calculate it.
Important
The result on the screen does not make the raw data correct. The table program re-reads the formula, but does not know whether the value was measured correctly and whether the right range was chosen.