1. , , , - , - .
2. , 0 10 2 .
3. , (, ), .
4. , .
5. , - , , .
6. 1, 2, 3, 4, 5 6 , , 1, 2, 3, 4, 5 6.
7. , , .
8. , , 5000 , 10000 . , , .
9. , , .
10. , TextBox TextBox .
11. , , , . .
12. , , .
13. , , , .
14. , . , .
15. , , .
: 2,3,4,5,7,8,9,12,13,14,15,17,18
11 (1 )
: , ,
: ,
:
:
1. VBA
2. , , ,
|
|
3.
4.
5.
, , , , , (+, -, *, /, ^). .
VBA :
\ - ( );
MOD .
11.1
VBA | ||
Sin x | SIN (x) | |
Cos x | COS (x) | |
tg x | TAN (x) | |
arctg x | ATN (x) | |
ln x | LOG (x) | |
|x| | ABS (x) | |
√x | SQR (x) | |
ex | EXP (x) |
FIX (_) _.
INT (_) , _.
CINT(_) _ .
, , , , , :
= ();
< > ( );
> (, );
< (, );
>= ( );
<= ( ).
: TRUE () FALSE (). .
,
AND (, )
OR (, )
NOT ()
, NOT (a > b)
: TRUE () FALSE (). , , .
. () . + (), . , + Windows Windows.
, .. . , . , , , .. , , . , . , .. .
: "DOG" > "CAT", "M16 ">"M16"
VBA ( ) . :
_ =
:
1) , ;
2) , .
: !
|
|
, , . . , 5×(3+4), 35.
- :
1. .
2. ( ).
3. .
4. .
5. Mod.
6. .
Visual Basic . Visual Basic , . . 11.2.
11.2
CInt CLnq CSnq CDbl CCur CStr CVar CBool CByte CDate | Currency Variant Boolean Byte . |
, 0 10 2 :
Public Sub _()
Dim Send As String
Worksheets("2").Select
For i = 0 To 10
Send = Chr(65 + i) & (i + 1)
Range(Send).Value = i ^ 2
Next i
MsgBox ("OK")
End Sub
1. ?
2. ?
3. VB?
4. VB.
5. ?
6. ?
7. Single, Integer, String?
8. .
9. ?
1. , , z. , b;
2. . , , .
3. , , z. , b;
4. . , , .
5. , , z. , b;
6. . , , .
7. , , z. , b;
8. . , , .
9. , , z. , b;
10. . , , .
11. , , z. , b;
12. . , , .
13. , , z. , b;
14. x. , , , . .
15. . , , .
16. x y. , , , . .
|
|
17. . , , .
18. . , , .
19. x. , , , . .
20. . , , .
: 2,3,4,5,7,8,9,12,13,14,15,17,18