Excel2
This document was uploaded by user and they confirmed that they have the permission to share it. If you are author or own the copyright of this book, please report to us by using this DMCA report form. Report DMCA
Overview
Download & View Excel2 as PDF for free.
More details
- Words: 2,106
- Pages: 12
1
* *
:
@ @áîy‹Ûa@弋Ûa@ a@á i
Microsoft Excel Excel .1 ! .2 " .3 &' : #$ .4 () *+ , -' ". / 0 -' IV A : 01 2$ 3 677 * " Ctrl 4 3 #5 ) 01 2$( . 2 01 2$( 8$ 65536 "9 :$ 1 "9 :$ :3$ : ) :$ 01 2$ 3 677 23 01 * " Ctrl 4 3 #5 ) :$ 01 2$( . 2 :$ 01 2$( 8$ / 2 #$ / :3$ /
. () 0 #$ : () : . Excel / + 2 #$ : ;) 2 3 ;) 2 ( < = 0( Tab 4 3 ! .1 8 3 + " ! .2 : () 0( () > = ; 5 #$ .4 "9 ? .3
? .2
"9 .1
* *
:
2
* *
:
: () :A 3 Delete 4 3 #5 :A () + : " ! : () - 9 3 :$ "9 : () - B : C; 2 .1
: D 1 3 D E ! < + &( / ' 0( #5 "F 2(, .1
* *
:
3
* *
:
;) / (=); 2 "F D + () 2 + : .2 "9
"F SUM C "F (=) ; 2 "F D + () 2 + : .3 #5 "F + () 2 C "F 9 "9 Shift ! 69 8 3
!(# "F + () )I C "F ( :) 2 ( < ) : Shift 4 3 Tab 4 3 #5 "F ( 0) "9 Shift ! 6
+ !$ ' 0( #5 "F D + () 2 + : .4 !+ "F SUM " ) !$ " / ,
. !+ 0( #5 SUM " / , : 1 3 E < MAX C "F (=) ; 2 "F + () 2 + : .1 "F + () 2 C "F 9 "9 Shift ! 6 8 3 "F + () )I C "F 2 (<) : Shift 4 3 #5
Tab 4 3 #5 "F ( 0) "9 Shift ! 6 !(# "F
" ) !$ ' ( #5 "F + () 2 + : .3 "F *+ > + : MAX " / , !+ "F MAX . !+ "F + "F 23 01 C #5
* *
:
4
* *
:
: #$ 1 3 C MAX 2 ) 63 #$ . MIN ) !$ )
: 1 3 , D 2
"F (= ) ; 2 "F + () 2 + :
. Tab 4 3 #5 "F C "F ( /) ; 2 "F ()
: 2 9 3 2 9 ! K;F < C 9 2(, 1 ) 9 9 ) "F ! & 8 3 .1 . Enter 4 3 #5 "F C; ; L F ". ; L F ". C 9 2(, 9 + #5 #5 .2 . Enter 4 3 #5 "F 3, ) $ ) &9 , ' #5 "F 9 + : .3 . Enter 4 3 #5 "F ". C 9 2(, 1 : MA ! ; +51 3 / , MA ) "F & 8 3 "F C 2 )I 23 :
, 0( #5 2 2 * * +5E 2 " A ". C "F Tab 4 3 #5 "9 2)1 * +5E MA . * +51 2 2 / +51 " 0 * *
:
5
* *
:
N : 1 3 . 2;) '( 1 # 01 #( # "F ( = ) ; 2 "F + () 2 + :
N: 3, 2
N: $ . 1 3 . C :; ) / C $ . C
"F (=) ; 2 "F O 1 2 + () 2 + :
2 C "F (×) ; 2 "F C () , 5 "9 Shift 4 3 #5 (%) ; 2 . O 1
. . / A * *
:
6
* *
: : . ( 1 3 + &( / ' 0( #5 "F ( 1 . 2(,
.
: . C 1 3 2
"F (=) ; 2 "F . C + () 2 + :
, 2 ( 2
"F ( +) ; 2 "F () , C Tab 4 3 #5 "F . ()
N : $ $) 1 3 C :; ) / . C $ $) . C
"F (=) ; 2 "F O 1 "$) () 2 + :
. O 1 "$) C "F (×) ; 2 "F () ,
. 63 $) / A N : $) ( 1 3 + &( / ' 0( #5 "F $) 2(,
.
N : C +$ 1 3 C
"F (=) ; 2 "F C +$ + () 2 + :
Tab 4 3 #5 "F . $) (
"F ( N) ; 2 "F .
* *
:
7
* *
: N : MA ! ; +51 3 " MA , MA ) & 8 3 "F C 2 )I 23 :
. * +5E 2
N :0 2 ! 3 * " Shift 4 3 #5 "F 2 2(, " 2 2(,
. *(S 2 2(, " 0
*
;) ! " / , ;) ) "F ! & 8 3 <A "F ( ($3 ) '
"F C ( ) "F C ) "F " ) "F ) *
"F 2 1 9 <A . ()
. !+ "F . "F C )
* *
:
8
* *
:
. * 2 2
N : '1 3 ;) " / , ;) ) ! & 8 3 "F + "9 2(,
2' " " ! "F "9 &3 &3 ) "9 * . ( 3$ ) (
! " #
%$ * *
:
9
* *
: N : F 2 ! 3 " / , 2 ( &( ! ) 2 & 8 3 "F 2 2(,
. !+ "F C C( ! D ) . 2 ( &( !
Chart : " ) 2F 2 9; 85 " . >$ 2F F . ) S ) 2(, 2(, ) 2 2(, C ) 2 . F 2(, "F Ctrl 4 3 #5 "F 2
) ) " / , ) ) M 1 & 8 3 "F . 0( #5 "F 2 "F ) D ) ) D 0 4 1
* *
:
10
* *
:
$ 0 4 2 ) ) " / , 4 3 ) ) " / , . 0( #5 ) ( " 2 ) ) C ) A + ) ) 0 C ? + ((, - C 6 + 2 . ( #5 "F 2(, F "
A + ) /9 0 4 4 ) ) " / , . ) < ) /9 ) 9 + , )
9 .1 . 2 9 63 + , )
+ & .2 9 + ) ; L F * *
:
11
* *
:
. 9 + ) ,
" !+ T 0
* *
:
* *
:
ﺇﻋﺪﺍﺩ ﺍﻷﺳﺘﺎﺫ :ﺑﺪﺭ ﺍﻟﺪﻳﻦ ﻣﻮﺳﻰ ﳏﻤﺪ ﻣﻌﺎﻫﺪ ﺍﳌﺪﺧﻞ ﺍﻟﻌﺎﳌﻴﺔ ﻟﻌﻠﻮﻡ ﺍﻟﻜﻤﺒﻴﻮﺗﺮ ﺑﺮﺝ ﺍﳉﺰﻳﺮﺓ ﺍﻟﻄﺎﺑﻖ ﺍﻷﺭﺿﻲ
* *
:
12
* *
:
@ @áîy‹Ûa@弋Ûa@ a@á i
Microsoft Excel Excel .1 ! .2 " .3 &' : #$ .4 () *+ , -' ". / 0 -' IV A : 01 2$ 3 677 * " Ctrl 4 3 #5 ) 01 2$( . 2 01 2$( 8$ 65536 "9 :$ 1 "9 :$ :3$ : ) :$ 01 2$ 3 677 23 01 * " Ctrl 4 3 #5 ) :$ 01 2$( . 2 :$ 01 2$( 8$ / 2 #$ / :3$ /
. () 0 #$ : () : . Excel / + 2 #$ : ;) 2 3 ;) 2 ( < = 0( Tab 4 3 ! .1 8 3 + " ! .2 : () 0( () > = ; 5 #$ .4 "9 ? .3
? .2
"9 .1
* *
:
2
* *
:
: () :A 3 Delete 4 3 #5 :A () + : " ! : () - 9 3 :$ "9 : () - B : C; 2 .1
: D 1 3 D E ! < + &( / ' 0( #5 "F 2(, .1
* *
:
3
* *
:
;) / (=); 2 "F D + () 2 + : .2 "9
"F SUM C "F (=) ; 2 "F D + () 2 + : .3 #5 "F + () 2 C "F 9 "9 Shift ! 69 8 3
!(# "F + () )I C "F ( :) 2 ( < ) : Shift 4 3 Tab 4 3 #5 "F ( 0) "9 Shift ! 6
+ !$ ' 0( #5 "F D + () 2 + : .4 !+ "F SUM " ) !$ " / ,
. !+ 0( #5 SUM " / , : 1 3 E < MAX C "F (=) ; 2 "F + () 2 + : .1 "F + () 2 C "F 9 "9 Shift ! 6 8 3 "F + () )I C "F 2 (<) : Shift 4 3 #5
Tab 4 3 #5 "F ( 0) "9 Shift ! 6 !(# "F
" ) !$ ' ( #5 "F + () 2 + : .3 "F *+ > + : MAX " / , !+ "F MAX . !+ "F + "F 23 01 C #5
* *
:
4
* *
:
: #$ 1 3 C MAX 2 ) 63 #$ . MIN ) !$ )
: 1 3 , D 2
"F (= ) ; 2 "F + () 2 + :
. Tab 4 3 #5 "F C "F ( /) ; 2 "F ()
: 2 9 3 2 9 ! K;F < C 9 2(, 1 ) 9 9 ) "F ! & 8 3 .1 . Enter 4 3 #5 "F C; ; L F ". ; L F ". C 9 2(, 9 + #5 #5 .2 . Enter 4 3 #5 "F 3, ) $ ) &9 , ' #5 "F 9 + : .3 . Enter 4 3 #5 "F ". C 9 2(, 1 : MA ! ; +51 3 / , MA ) "F & 8 3 "F C 2 )I 23 :
, 0( #5 2 2 * * +5E 2 " A ". C "F Tab 4 3 #5 "9 2)1 * +5E MA . * +51 2 2 / +51 " 0 * *
:
5
* *
:
N : 1 3 . 2;) '( 1 # 01 #( # "F ( = ) ; 2 "F + () 2 + :
N: 3, 2
N: $ . 1 3 . C :; ) / C $ . C
"F (=) ; 2 "F O 1 2 + () 2 + :
2 C "F (×) ; 2 "F C () , 5 "9 Shift 4 3 #5 (%) ; 2 . O 1
. . / A * *
:
6
* *
: : . ( 1 3 + &( / ' 0( #5 "F ( 1 . 2(,
.
: . C 1 3 2
"F (=) ; 2 "F . C + () 2 + :
, 2 ( 2
"F ( +) ; 2 "F () , C Tab 4 3 #5 "F . ()
N : $ $) 1 3 C :; ) / . C $ $) . C
"F (=) ; 2 "F O 1 "$) () 2 + :
. O 1 "$) C "F (×) ; 2 "F () ,
. 63 $) / A N : $) ( 1 3 + &( / ' 0( #5 "F $) 2(,
.
N : C +$ 1 3 C
"F (=) ; 2 "F C +$ + () 2 + :
Tab 4 3 #5 "F . $) (
"F ( N) ; 2 "F .
* *
:
7
* *
: N : MA ! ; +51 3 " MA , MA ) & 8 3 "F C 2 )I 23 :
. * +5E 2
N :0 2 ! 3 * " Shift 4 3 #5 "F 2 2(, " 2 2(,
. *(S 2 2(, " 0
*
;) ! " / , ;) ) "F ! & 8 3 <A "F ( ($3 ) '
"F C ( ) "F C ) "F " ) "F ) *
"F 2 1 9 <A . ()
. !+ "F . "F C )
* *
:
8
* *
:
. * 2 2
N : '1 3 ;) " / , ;) ) ! & 8 3 "F + "9 2(,
2' " " ! "F "9 &3 &3 ) "9 * . ( 3$ ) (
! " #
%$ * *
:
9
* *
: N : F 2 ! 3 " / , 2 ( &( ! ) 2 & 8 3 "F 2 2(,
. !+ "F C C( ! D ) . 2 ( &( !
Chart : " ) 2F 2 9; 85 " . >$ 2F F . ) S ) 2(, 2(, ) 2 2(, C ) 2 . F 2(, "F Ctrl 4 3 #5 "F 2
) ) " / , ) ) M 1 & 8 3 "F . 0( #5 "F 2 "F ) D ) ) D 0 4 1
* *
:
10
* *
:
$ 0 4 2 ) ) " / , 4 3 ) ) " / , . 0( #5 ) ( " 2 ) ) C ) A + ) ) 0 C ? + ((, - C 6 + 2 . ( #5 "F 2(, F "
A + ) /9 0 4 4 ) ) " / , . ) < ) /9 ) 9 + , )
9 .1 . 2 9 63 + , )
+ & .2 9 + ) ; L F * *
:
11
* *
:
. 9 + ) ,
" !+ T 0
* *
:
* *
:
ﺇﻋﺪﺍﺩ ﺍﻷﺳﺘﺎﺫ :ﺑﺪﺭ ﺍﻟﺪﻳﻦ ﻣﻮﺳﻰ ﳏﻤﺪ ﻣﻌﺎﻫﺪ ﺍﳌﺪﺧﻞ ﺍﻟﻌﺎﳌﻴﺔ ﻟﻌﻠﻮﻡ ﺍﻟﻜﻤﺒﻴﻮﺗﺮ ﺑﺮﺝ ﺍﳉﺰﻳﺮﺓ ﺍﻟﻄﺎﺑﻖ ﺍﻷﺭﺿﻲ
* *
:
12
Related Documents
Excel2
November 2019 11
Excel2
May 2020 5
Solver Excel2
November 2019 15
Taller De Excel2.xlsx
December 2019 20
Excel2 Paper2 2009 Math 2
May 2020 5