, Excel , , . , Excel, , , . , .
, Excel, , , . .
Excel:
, , . , Excel, , .
, «2 2» («2+2)5») . , , .
, | + |
, | - |
, | * |
, | / |
| ^ |
| % |
, , | >, <, >=, <=, <> |
. , Excel , , , . , ( ).
Excel ? , , . (, ) , . «=2+2».
, (, A1 A2), «=A1+A2». . – , .
, ( "", – SUM). : «=(A1;A2)», – «(A1:A10)» , , . , , , , .
,
, Excel . , , .
«=A1*A2», – «A1/A2». , , , Windows-.
«^». A1, , , , «=A1^2».
, , . Excel ?
«=A1*5%», .
- ( ). Ctrl.
, . . , , .
,
, , , .
, $A$1, (A1), – , ($A1 A$1). , , .
, , Excel (VLOOKUP). . , Excel «», , .
, , , .
« » () , «» (F4), , «», , . , , - .
, , Excel. , , . , , , . , . , Excel . «», , Excel.
For the rest, it should be clearly understood that, having studied primitive formulas or actions with data, then it will be possible to easily master more complex calculations, for example, with the creation of cross-references, using various kinds of scripts or VB scripts, etc. All this takes time, so if you want to study the program and all its features to the maximum, you have to sweat over the theoretical part.