Microsoft Excel, , - . , , , , .
, , , . , , 9 Excel.
1.
. , , : =(Beth,A2:E6,5,0), Beth , A2:E6 , 5 , 0 , .
, . -, , , , . , .
2.
. , , - -, : =(3:11, 4).
3.
( - . , ) .
. .
, , Wells Fargo, =(3:11,(Wells Fargo,B3:B11,0).
, . .
4. 3D-
, , , . , , .
TOTAL () , . =(Week1:Week7!B2), B2 . , , , , 7 .
5. $
Excel, $. , , Excel .
$ , 1 . $A$1, . , .
6. &
, . , &.
7.
, , , , .
, . ( 1, 2). , . Ctrl+Shift+Enter, Excel . , , Enter Ctrl+Shift+Enter.
8.
Excel , . , , Excel.
, , , , 100 . . , Total revenue ( ) 100 . set cell ( ) , , to value () , by Changing cell ( ) , . ! . , .