Office Professional Plus, Power Pivot Excel. Power Pivot Excel, Excel. Power Pivot . , , , (KPI). (DAX) .
"Inquire".
Office Professional Plus, "Inquire" Excel. , , , , , , . "Inquire" Microsoft Office , , . ϳ .
5. MICROSOFT EXCEL
, ' . . , , , , , .. Microsoft Excel.
5.1 Excel
.
˳ - 䳺 - ' . ij , 䳿, .
15 䳺, , 䳺, . , 䳺.
䳺, . , Microsoft Exel. , , : , , , . Microsoft Excel . , .
.
:
1 | - |
2 | , |
, , |
. IJ в.
|
|
- . . : - 4, - 9.
15 = (C3 * 4) + (D3 * 9) + (E3 * 4).
Microsoft Excel Microsoft Word ( Excel) , , "", Word, , , .
: 15 ():
ʳ | |||||||
250 | 11,75 | ||||||
8 | 1,01 | 0,92 | 0,056 | 12,5 | |||
5 | 0,03 | 4,1 | 0,045 | 37,2 | |||
30 | 3,18 | 0,39 | 21,96 | 104,07 | |||
10 | --- | --- | 10 | 10 | |||
ѳ | 1,5 | --- | --- | --- | --- | ||
5 | --- | --- | --- | ||||
100 | 2,8 | 3,2 | 4,7 | 59 | |||
20 | --- | --- | 20 | 20 | |||
() . ij , , 5 ( ).
( ) : = 50 +0,75 (-150) + -20/4, - , - .
: 100 .
:
20 . Excel , , , . , , , . Ok. , , ( : D2 <(C2-100)), ( : ), ( : )
:
Բ | ³ | г () | () | |
.. | 18 | 158 | 59 | |
.. | 23 | 173 | 54 | |
.. | 21 | 157 | 67 | |
.. | 35 | 165 | 50 | |
.. | 28 | 167 | 76 |
, 2000 , , 25% , 10% 18 45 , 3% - 18 45 , 7% - , 18- 5% - .
|
|
Microsoft Excel , .
(-ij). , . .
ó
Macrosoft Office . Microsoft Excel - , , . ³ , 90% . . , , , , . .
, Microsoft Excel . .
:
1. http://bibliofond.ru/view.aspx?id=65875
2. .. , .. , .. " - Exsel", , 1999 .
3. http://www.bestreferat.ru/referat-52932.html
4. http://office.microsoft.com/ru-ru/excel-help/
5. http://office.microsoft.com/ru-ru/excel-help/HA101829993.aspx
6. http://office.microsoft.com/uk-ua/excel-help/HA102809308.aspx
ʲ 2
:
Microsoft Office
-25()
볿
..
1. .. 2-4.
1.1 .
1.2 .
2. ⅅ 5-13.
2.1 .
2.2 .
2.3 .
2.4 .
2.5 .
3. 14-15.
3.1 .
3.2 .
1. .