Since the release of the very first Microsoft software products as a complete office suite in the modern world, one of the most interesting and necessary tools has been spreadsheets. The spreadsheet itself is designed to solve many problems, and not only to perform simple mathematical operations, as some users who work, for example, with Excel, consider. It serves many other purposes, for example, to create and organize databases. Agree, Access is also a spreadsheet application. But now, for ease of understanding, we will consider Excel tables, since they are the most common.
What is a spreadsheet designed for? general description
-, , , , .
. , :
, . , , , . , , , - , . , .
«» :
, Excel, . , .
, «» ? , , . : , ( Excel – ).
(, A1). , , , .
, . , , . .
, , , .
, , . , .
, , , , . , . , , .
, , .
. , , .
, . , 2 2. , . , , A1 B1 (A B – , 1 2 - ). , . , : =A1*B1, , . , ( ).
. (=A1+B1), . , .
, A1 A10 , A11, : =(A1:A10) , .
, , .
, . .
, , , - , , .
. (, , , , . .). . , , Excel . - «».
It remains to add that the spreadsheet is intended not only for all of the above. The possibilities of the programs that use them are much wider, but to describe all this, even in the shortest form, with all desire, will not work out purely physically. Therefore, if you want to learn how to work with tables and use the functionality to the fullest, it will be necessary, as they say, to study the technical documentation (since the background information in Excel is presented at the highest level).