Excel test tsootsoolol

  • View
    1.321

  • Download
    4

Embed Size (px)

Transcript

Slide 1

:

4

- 118- .18/1/200934

.34 6.1 Microsoft EXCEL 2007 ,

3 6.2. ,

4 6.2. ,

5 1. Page Layout . 2. Page Setup . 1. (Page Layout )

6 3. Page Setup Paper . 1. (Page Layout )

7 millimeters (mm) centimeters, inches mm- .

8

1. , , . Microsoft Excel dun-5a-angi . 2. .

9 2. Sheet1 1- . Sheet1 mouse II- Rename . Ctrl+A Arial, 10 . 3. A4:T47 . Home Font All Borders . 4. . : A 2.70, B 15.15, C:T 3 . Mouse II Column Width . 2. .

10 5. A2 . , 2 . A2:T2 Home > Alignment Merge & Center - , , Wrap Text 2 , Center , Middle Align - . 2. .

11 6. , . 2. .

12 7. . 1, 2 . 1 , . 8. . (Ctrl+S)

. . F2 .

13 AVERAGE, COUNTIF, COUNTA, SUM, IF . 1. , , . dun-5a-angi . 3.

14 2. N6-R6 a, b, c, d, f . :N6 a = COUNTIF(C6:M6,">=90") . N40 . O6 b =COUNTIF(C6:M6,">=80")-(COUNTIF(C6:M6,">=90")), P6 c =COUNTIF(C6:M6,">=70")-(COUNTIF(C6:M6,">=80")), Q6 d =COUNTIF(C6:M6,">=60")-(COUNTIF(C6:M6,">=70")), R6 f =COUNTIF(C6:M6,"=90") . M41 . C42 b =COUNTIF(C6:C40,">=80")-(COUNTIF(C6:C40,">=90")), C43 c =COUNTIF(C6:C40,">=70")-(COUNTIF(C6:C40,">=80")),C44 d =COUNTIF(C6:C40,">=60")-(COUNTIF(C6:C40,">=70")), C45 f =COUNTIF(C6:C40,"Shapes . 1 .

4.

22 2. . 6 2 .Sheet2 1, Sheet3 2, Sheet4 .

4.

27 3. moduli6 soril_math .

4.

31 1. . Insert>Links Hyperlink . 5. ,

36

1. Link to: Place in This Document . Or select a place in this document: 1- . 5. ,

37 . .1, 2 .

. IF . .=if(logical_test, true_value, false_value)=IF(' 1'!M9="",1,0)

5. ,

38 2. . . D7 . =IF( 1 . 1- . =IF(' 1'!M8 ="",1,0) . =IF(' 1'!M8="",1,0) . Enter D7 . 5. ,

39 D8 =IF(' 1'!M9="",1,0), D9 =IF(' 1'!M10="",1,0), D10 =IF(' 1'!M11="",1,0), D11 =IF(' 1'!M12="",1,0), D12 =IF(' 1'!M13="",1,0), D13 =IF(' 2'!M8="",1,0), D14 =IF(' 2'!M9=",1,0), D15 =IF(' 2'!M10=",1,0), D16 =IF(' 2'!M11="",1,0), D17 =IF(' 2'!M12=",1,0), D18 =IF(' 2'!M13=",1,0) . 5. ,

40 3. , , . D21 =sum(D6:D20) . =D21*100/15 .

=IF(D20