Transcript
  • 7/25/2019 Excel 2013, Uso bsico.pdf

    1/23

    P. E M. P E

    P. E E. G CC S T U I

    2013

    C A

  • 7/25/2019 Excel 2013, Uso bsico.pdf

    2/23

    O................................................................................................................................................. 1

    I ........................................................................................................................................... 1

    I E 2013 .................................................................................................................................... 1

    C E .................................................................................................... 3

    E ...................................................................................................... 4

    M ................................................................................................................... 7

    G ................................................................................................................ 13

    I ............................................................................................................... 13

    C .................................................................................................................... 14C .......................................................................................................... 14

    A ...................................................................................................... 15

    S E ......................................................................................................................................... 15

    C ...................................................................................................................................... 16

    C .................................................................................................................................... 17

    C ............................................................................................................................. 18

    P ............................................................................................................................. 20

    R ........................................................................................................................................... 22

    H ..................................................................................................................................... 23

  • 7/25/2019 Excel 2013, Uso bsico.pdf

    3/23

    A , :

    I E

    D E

    I

    C E G A

    I

    C

    D

    C

    T

    E , M O 2013: E 2013. E , , , , W. L E 2013 : , , , , W HTML I. E /

    M E 2013.

    2013

    1.

    H W .

    2.

    H A .S .

    3.

    H 2013 , E 2013 .

  • 7/25/2019 Excel 2013, Uso bsico.pdf

    4/23

    I 1

    O () E (). C .

    )

    R 1 2.

    )

    H 2013 , E 2013.

    )

    D , D ().

    I 2

  • 7/25/2019 Excel 2013, Uso bsico.pdf

    5/23

    W , 3, E 2013. A .

    I 3

    U E, B1 .

    I 4

  • 7/25/2019 Excel 2013, Uso bsico.pdf

    6/23

    L C . P , MS E 2013, , : ( ), , , . L H

    (I) .

    I 5

    E , . S , . O .

    I 6

    U E 16,384 1,048,576 . L .

  • 7/25/2019 Excel 2013, Uso bsico.pdf

    7/23

    C

    C

    C C

    P [A P[P U

    P [R P

    [P D

    C A1[C + [I[C+H

    S , , H E, F & G .

    I 7

    E , (: 145). D .

  • 7/25/2019 Excel 2013, Uso bsico.pdf

    8/23

    I 8

    E E, , . C , E , .

    I 9

  • 7/25/2019 Excel 2013, Uso bsico.pdf

    9/23

    E E, :0 1 2 3 4 5 6 7 8 9 + ( ) . $ % E .

    S , , E

    . C , . O .

    I 10

    A , .

    P , .

    P , ,

    .

    P , , C .

    P .

    P .

  • 7/25/2019 Excel 2013, Uso bsico.pdf

    10/23

    I 11

    P , A 1 , .

    I 12

    1.

    I (: ).

    2.

    U (: ).3.

    H , .

  • 7/25/2019 Excel 2013, Uso bsico.pdf

    11/23

    I 13

    T ,

    .

    1. I (: 3).2.

    U (: 3 4).

    3.

    H , .

    I 14

    T , .

  • 7/25/2019 Excel 2013, Uso bsico.pdf

    12/23

    P .

    1.

    S .2.

    H H.

    3.

    D C, F F C.A ()().

    I 15

    : .L :

    G: . :

    . C:

    ($). T (,) .

    : , 100 %.

    A: ( ) ( ) .

    F: , , .

    B: . S , . T /

  • 7/25/2019 Excel 2013, Uso bsico.pdf

    13/23

    , / . A, .

    : .

    :

    . P , L K. L H. D C, F . P .

    T C H .

    A 2007, E . E , .

    1. S .2.

    H H , F .

    I 16

    3.

    U , K.

    E .

    1.

    H .

  • 7/25/2019 Excel 2013, Uso bsico.pdf

    14/23

    2.

    H H C, I, I I C , . L .

    I 17

    P :1.

    S .2.

    E H, D C.

    S C .

    I

    +. P , E. P . T .P :

    1.

    H (: 1).2.

    E EE .

    I 18

  • 7/25/2019 Excel 2013, Uso bsico.pdf

    15/23

    P :1.

    H . S C .

    2. H .

    I 19

    P

    F A .

    1. A .2. P

    . E . S , E .

    3.

    H F

    .4.

    M , , .

    5. F, .

  • 7/25/2019 Excel 2013, Uso bsico.pdf

    16/23

    I 20

    U , .

    1.

    H F C.

    S :1.

    H F .2.

    L 3 . L . L . S , B C.

    I 21

  • 7/25/2019 Excel 2013, Uso bsico.pdf

    17/23

    P :1. H F .2. L . B

    .

    I 22

    P E, C E F.

    I 23

  • 7/25/2019 Excel 2013, Uso bsico.pdf

    18/23

    S E . U , , / .

    1.

    S . E (: 3).

    2. E ( =) . E C ( C3) C( D3) C .

    3.

    S ( % * / + ) .E , C3, (*) D3.

    4.

    O EE . P C3 D3 , E3. L :=C3*D3.

    I 24

    U . L . L F, F L.

    P :1.

    S . E .

  • 7/25/2019 Excel 2013, Uso bsico.pdf

    19/23

    E , C, D9.

    2.

    E F, A FL A.

    3. P , E

    , .

    4.

    S , EE, , EE .

    5. S D9, =(D3:D8). E D3 D8.

    I 25

    E . L . S F H(A) .

    E , C E3 E8. P:

    1.

    H (: 3).2. H F H E8.

    O E , .

  • 7/25/2019 Excel 2013, Uso bsico.pdf

    20/23

    I 26

    A , . E , 3D .P :

    1. S . R, , C .

    2. H I, C, 1.

    I 27

  • 7/25/2019 Excel 2013, Uso bsico.pdf

    21/23

    O . U , , , , .

    S , D, C( ) L,

    C. L :1.

    : L . L .

    2.

    :L . L .

    A , , C . .

    D: P , , .

    L: P , .

    F: P . C , ( ).

    I 28

  • 7/25/2019 Excel 2013, Uso bsico.pdf

    22/23

    D M E 2013.

    ( : 15 )

    1.

    U .

    G ( )

    C 1 2 T

    H 1200 1550M 1700 1777O 829 966T

    2. C A.3. C

    . P , .

    4.

    F, D (: 844051234).

    S 29.

  • 7/25/2019 Excel 2013, Uso bsico.pdf

    23/23

    I 29


Top Related