Σημειωσεις Excel

download Σημειωσεις Excel

of 79

  • date post

    09-Nov-2015
  • Category

    Documents

  • view

    7
  • download

    2

Embed Size (px)

description

Σημειωσεις Excel

Transcript of Σημειωσεις Excel

  • 2 MS EXCEL

    MS EXCEL

  • 2 MS EXCEL

    1 ............................................................................................................... 3

    Microsoft Excel ...................................................... 3

    1.1 xcel ......................................................................................... 3

    1.2 Excel ........................................................................................ 3

    1.3 xcel .......................................................................................... 4

    1.4 ................................................. 13 2 ............................................................................................................. 15

    Microsoft Excel ............................................................... 15

    2.1 ............................................................. 15

    2.2 ............................................ 15

    2.3 , & ........................................... 15

    2.4 Excel ............................................................. 16

    2.5 ................................................................... 16

    2.6 ................................................... 16

    2.7 ............................................................. 17

    2.8 Excel .................................................................. 18 2.9 .................................................................... 18

    2.10 Excel .......................................................... 18 3 ............................................................................................................. 20

    --- ............................... 20

    3.1 ............................................ 20

    3.2 ................................................................................ 21

    3.3 ........................................................... 21

    3.4 ............................................................................ 22

    3.5 ....................................................................... 22

    3.6 ........................................... 29

    3.7 ........................................................................... 29

    3.8 ........................................................................ 30

    3.9 ........................................................................... 30

    3.10 ............................................................... 31

    3.11 ............................................................ 32

    3.12 ............................................................. 32

    3.13 ................................................ 32

    3.14 ........................................ 33

    3.15 ...................................................... 33

    3.16 ...................................... 33

    3.17 ............................................. 34

    3.18 ..................................................... 34 4 ............................................................................................................. 35

    ............................................................................................ 35

    4.1 ................................................. 35

    4.2 ........................................................................ 35

    4.3 .............................................................................. 36

  • 2 MS Excel

    2

    4.4 ..................................... 37

    4.5 ......................................................................... 37

    4.6 .................................................................................. 37

    4.7 .......................................................... 38

    4.8 .................................................................................. 39

    4.9 ................................................................................... 39

    4.10 .......................................................................... 40

    4.11 ............................................................... 43

    4.12 ................................................................................ 44

    4.13 .............................................................. 44

    4.14 ........................................ 45

    4.15 .................................................................................. 46

    4.16 ..................................................................................... 47

    4.17 ............................................................................. 47 5 ............................................................................................................. 51

    Excel ........................................................................................ 51

    5.1 .............................................................................................. 51

    5.2 .............................................................................. 53

    5.3 ....................................................................... 57

    5.4 .......................................................................... 59

    5.5 ...................................... 62

    5.6 ........................................................................ 62 6 ............................................................................................................. 63

    ................................................................................ 63 .................................................................................. 63 ................................................................................ 63

    6.1 ........................................................................ 63

    6.2 ........................................................... 66

    6.3 ..................................................................... 68

    6.4 Freeze Panes- .................................................................... 69

    6.5 ............................................................ 70

    6.6 Excel ............................................................................... 71

    6.7 ........................................................................................ 72

    6.8 ....................................................................................... 72

    6.9 o ....................................... 73

    6.10 ............................................................... 76

    6.11 Excel .................................................................................... 77 ............................................................................................................. 78

  • 2 MS Excel

    3

    1

    Microsoft Excel

    1.1 xcel

    . . , , / .

    (SpreadSheets), , . , / , . (cells), , , , .. , , . , , ( ).

    1.2 Excel

    Excel Windows, Office. Excel

    . xcel

    (desktop) . Excel - Word. Excel ,

  • 2 MS Excel

    4

    Word. 1 Excel.

    E 1: Excel

    1.3 xcel

    ( 2) Excel :

    1. , () , , , , , , .

    2. . , . .

    3. , .

  • 2 MS Excel

    5

    E 2: Excel

    :

    . , , .

    :

    , , , , Ms-Excel.

    :

    - ( - , - ), .

  • 2 MS Excel

    6

    :

    ( 3) , . .

    3:

    :

    ( 4) Ms-xcel. Y , . 1. , , (ToolTip) . Excel (13) , . . , ( ) , , , .

    1 2 3 4 5 6 7 8 9 10 11 12 13 141516 17 18 19 20 21 22

    4:

  • 2 MS Excel

    7

    1

    1

    .

    2

    .

    3

    ,

    .

    4

    ..

    .

    5

    .

    .

    6

    .

    7

    .

    8

    Windows.

    9

    Windows.

    10

  • 2 MS Excel

    8

    .

    11

    .

    12

    .

    13

    .

    14

    -

    -

    -

    15

    SUM.

    16

    .

    17

    .

    18

    .

    19

    .

    20

    (Drawing).

  • 2 MS Excel

    9

    21

    22

    Microsoft

    Excel

    O Office

    -,

    .

    :

    ( 5) , . 2 .

    1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19

    5:

  • 2 MS Excel

    10

    2