Лекции по "Информатике"

Page 1

1,
2, 2009 .
1
:
,
,
,
,
,
,
,
MS Excel
1,
2, 2009 .
3
Excel
Excel
.
–
,
,
,
, . .
,
f(x)
->
1,
2, 2009 .
4
Excel
.
,
,
,
.
VBA (Visual Basic for
Application),
– IIF, SUM.
(
),
«;».
,
,
,
,
.
.
:
() (
)

---

Page 2

1,
2, 2009 .
5
Excel
•
()
(
)
•
(<
>) (
)
•
( <
>;<
_
_
>;
[<
_
_
>]) (
2
3
);
•
( 1:A10;C1:C10;G11;100) (
,
);
.
(
( 1:A10)
>20;
(G11<0;1;3)
;5)
-
1,
2, 2009 .
6
Excel
1,
2, 2009 .
7
.
–
,
.
–
( 1; 2;…)
( 1; 2;…)
( 1; 2;…)
,
,
,
,
,
Excel
1,
2, 2009 .
8
:
,
.
(
)
N
,
N
.
D4
8

---

Page 3

1,
2, 2009 .
9
D6:
1: 5 = 8;
3: 7 = 8;
4: 5 = 3;
19
1,
2, 2009 .
10
D5:
1:C5 4: 7 –
4: 5
4: 5 = 5;
5
1,
2, 2009 .
11
,
.
(<
1>; <
>; <
2>)
:
<
1> –
;
<
> –
.
,
,
;
<
2> –
,
,
<
1>,
.
Excel
1,
2, 2009 .
12
Excel

---

Page 4

1,
2, 2009 .
13
,
(
).
(<
1>;
<
2>)
,
(
)
(<
>)
,
(
)
(<
>)
,
,
,
.
Ctrl + Shift + Enter,
Excel
1,
2, 2009 .
14
,
,
Excel (
_1)
1,
2, 2009 .
15
Excel (
_2)
1,
2, 2009 .
16
Excel (
_3)
-1
b

---

Page 5

1,
2, 2009 .
17
( 1; 2;…)
( 1; 2;…)
( 1; 2;…)
,
,
,
,
,
Excel
1,
2, 2009 .
18
,
D5 = (2 + 2 + 3 + 5 + 8) / 5 = 4
D5 = (2 + 3 + 5 + 8) / 4 = 4,5
1,
2, 2009 .
19
( 1; 2;…)
,
,
,
,
,
Excel
1: 4
1,
2, 2009 .
20
(<
>; <
>)
,
Excel

---

Page 6

1,
2, 2009 .
21
()
()
.
<
_
>
,
,
(<
>)
Excel
1,
2, 2009 .
22
,
;
,
( 1; 2;...)
,
;
,
( 1; 2;...)
1; 2;…-
Excel
1,
2, 2009 .
23
;
,
2;
,
3
( 1; 2; 3)
:
1 -
_
;
2 -
_
_
;
3 -
_
_
Excel
1,
2, 2009 .
24
,
.
:
,
12: 16;
,
,
–
,
5: 9
–

---

Page 7

1,
2, 2009 .
25
(<
_
>; <
_
>;
<
_
_
>; <
_
>)
<
_
> – ,
;
<
_
> –
(
);
<
_
_
> –
,
;
<
_
> –
,
,
.
,
;
-
,
,
Excel
1,
2, 2009 .
26
Excel (
)
1.
12
=
( 12; $A$5:$B$9; 2;
)
2.
$A$5:$B$9
12.
,
($ $5:$B$9)
800
3.
12 A13:A16
1,
2, 2009 .
27
Excel (
)
«
»
1:F2
12: 16,
,
12: 16
1,
2, 2009 .
28
(<
_
>; <
_
>;
<
_
_
>; <
_
>)
<
_
> – ,
;
<
_
> –
,
;
<
_
_
> –
,
;
<
_
> –
.
,
,
(
)
(
)
Excel

---

Page 8

1,
2, 2009 .
29
Excel (
)
1,
2, 2009 .
30