Surely every user working with an office suite from Microsoft has come across programs that use spreadsheets as a saved document. This is a type of application programs (or rather, documents created with their help), the simplest example is MS Excel. Let's see why such documents are needed, how to work with them correctly.
Spreadsheets: what's this?
Based on the generally accepted concept of spreadsheets, it is believed that these are files created with a specific work area in which you can perform fairly complex calculations (up to solving tensor equations), explore functions, build graphs and charts, and finally, calculate currency units based on a given or constantly changing course and so on.
, , – . - , , .
: ?
, . , , , MS Office Excel.
– , , , MS Access.
«», SQL, , - , . , Excel , , Visual Basic Java.
– , ( ).
, . ? , . , , Excel, Open Office Lotus Pro.
. , , , .
, , Excel, , . «». .
, . , ( ), , . , , , SQL- , , .
, , , – , , , , , , , . .
, . , . . Excel, , , .
( ), , .
, , (, , . .). . . , , . , . . .
, . ? , . . , , fx. . .
, . , . , , , «=A1+B1» , «=A1*B1» , . , – , . , , «=(A1:A10)» «=SUM(A1:A10)». , .
, , .
. ? . , , .
«» . , , , «//» . . , , , - , - - , . . .
Excel
, . , , . , , .
, , , . , , .
Access
Access, , , , . , SQL.
– , , , . , «1C», - .
«1»
«1C» - , . -, .
, , : «1C:» «1C:», «1C:» . . . , - , . .
, .
Ctrl + F ( ). .
, , Visual Basic, . , .
SQL
SQL, , , .
: , , . , , , , : , .
– , , , .
, . . , , , , .
, , , , . ? . , , . . ( ).
Of course, this is far from all that can be said about spreadsheets. Here is just a small part of what such programs are really capable of, and even with support for built-in or external tools that simply incredibly increase the capabilities of any software package. But, probably, each user already fundamentally understood what it is and why all this is needed.