Any, even the basic Microsoft Office suite contains a powerful Excel spreadsheet editor (Excel). The list of functions available in it is truly impressive: starting from the ability to sort and filter data and ending with the ability to build summary diagrams on their basis. And it’s almost impossible to imagine any data set stored in the editor without rows and columns calculated by means of formulas.
Formulas in Excel
– , , . , «» , , . , Excel . .
, Excel, . () , .
. , : «» «»:
|
|
|
1 |
|
|
2 | . . | 4100 |
3 | . . | 3750 |
4 | . . | 8410 |
5 | . . | 3750 |
6 | . . | 4100 |
7 | . . | 9200 |
"" 1 - . , , – , . , « . .» - 4. , .
, . 2 ( , 40 % ): =B2*100/40. 2 – . Enter 2, , . , , 7 ( ). :
|
|
|
. . | 4100 | 10250 |
. . | 3750 | 9375 |
. . | 8410 | 21025 |
. . | 3750 | 9375 |
. . | 4100 | 10250 |
. . | 9200 | 23000 |
:
|
=B2*100/40 |
=B3*100/40 |
=B4*100/40 |
=B5*100/40 |
=B6*100/40 |
=B7*100/40 |
, , (), . , , . «» - .
, , Excel, .
.
Excel – . , .
, , . , – , .
– , :
, 2, :
Enter, , . , , G4..G8, . , , Excel. , , ($).
:
, :
|
|
| |
. . | 4100 | 11175 | =(B2+$G$3)*100/40 |
. . | 3750 | 10300 | =(B3+$G$3)*100/40 |
. . | 8410 | 21950 | =(B4+$G$3)*100/40 |
. . | 3750 | 10300 | =(B5+$G$3)*100/40 |
. . | 4100 | 11175 | =(B6+$G$3)*100/40 |
. . | 9200 | 23925 | =(B7+$G$3)*100/40 |
" " Excel .
. – , . ($1) ($1) – , .
, . , =(B2+$G$3)*100/40 =(B2+G$3)*100/40 , , . , , .
, Excel / . "" F4 – , – , – , . Excel , .