Microsoft Office –
–
Microsoft Office Excel 2007 –
–
–
– –
–
– –
– – Ctrl + S –
*.xlsx
(
)
*.xls
(
)
– /
)
–
–
–
– –
– – –
– fx
–
)
A
– XFD
A –
– 7
D
D7 –
– – Tab
–
Shift + Tab
–
Enter
–
Shift + Enter
–
Ctrl
–
–
)
Ctrl + A
A
Shift
Shift
–
Ctrl
–
– – –
– – – )
– –
– – –
)
B1:B10 A1+10
)
C1:C10
B1:B10
C1:C10 B1:B10 C1:C10
)
C1
)
)
)
)
)
)
CTRL+F
)
)
CD
)
)
SMARTART
)
)
)
WORDART
)
)
XP
–
)
–
–
A1:F5 _
)
A1 : F1 A1 : A5 –
–
–
–
)
)
)
–
)
)
)
– – – – –
)
)
)
)
A
)
)
)
$A$1:$A$8
B
B
$ B
)
)
=COUNTIF($A:$A;A1)=1 COUNTIF F4
$
$A:$A
; A1 A
AND(LEN(A:A)=6;ISNUMBER(A:A)) AND :LEN A:A 6 ISNUMBER )
)
)
)
)
/
/
SMARTART
)
)
)
)
)
)
)
)
)
WORDART
WORDART
)
)
)
SMARTART SMARTART SMARTART
)
/
WORDART
SMARTART
SMARTART
)
)
)
–
)
/ : : : : :
)
–
–
)
– –
####
: Shift+F11.
Insert
)
) (٢اﻟﻌﻤﻠﯿﺎت اﻟﻤﻨﻄﻘﯿﺔ
) (١اﻟﻌﻤﻠﯿﺎت اﻟﺤﺴﺎﺑﯿﺔ
ﻣﺎ ﺗﺪل ﻋﻠﯿﮫ
اﻟﻌﻤﻠﯿﺔ اﻟﺠﻤﻊ اﻟﻄﺮح اﻟﻀﺮب
–
اﻟﻘﺴﻤﺔ اﻷس
^
>
أﻛﺒﺮ ﻣﻦ
< =>
أﺻﻐﺮ ﻣﻦ أﻛﺒﺮ أو ﯾﺴﺎوي
=<
أﺻﻐﺮ أو ﯾﺴﺎوي
><
ﻻ ﯾﺴﺎوي
)
=A1 + B1 + C1 + D1
D1, C1, B1, A1
=A2 – B2 – C2 – D2
D2, C2, B2, A2
= (A3+B3) – (C3+D3)
D3 , C3 A4 B4
= (A4*B4) / (C4*D4)
B3 , A3 C4 D4
)
H
G
F
E
D
C
B
A
= A1+2
A2
A A1=2
= B1+2
A1
B2
B B1=1
B1
C2 , C1
C
D2 , D1
D
= E1+1
E E2 , E1
F2 , F1
=F1+4
F
)
N
M
L
Jan
Sat
Feb
Sun
Mar
Mon
Apr
Tue
May
Wed
K
J
I
:
.
)
)
Ctrl + 1
$
$
)
)
)
)
)
)
A
)
)
– ( =)
)
H
Shift + 9 Shift + 0 EN ﺣرف )ك( ﻓﻲ وﺿﻊ EN ﺣرف )و( ﻓﻲ وﺿﻊ Shift + ك Shift + ط
ﻓﺗﺢ اﻟﻘوس إﻏﻼق اﻟﻘوس و و إﻟﻰ ﻧص
( ) ; , : "
Shift + 7
دﻣﺞ
&
G
F
E
D
C
B
A
= A2 + B2 + C2 + D2
ENTER
D2
A2
ENTER
= SUM (A2:D2 )
)
=SUMIF(A1:D1;">20";A2:D2) A1:D1
A2:D2
B1,D1
B2+D2
= (A2+B2+C2+D2)/4
F2= Average (A2:D2)
SUMPRODUCT
A*B C )
ABS
SQRT
INT
MAX D2 A2 = Max (A2:D2) = Max (A2:A3) D3
A2
= Max (A2:D3)
MIN D2 A2 = Min (A2:D2) = Min (A2:A3) = Min (A2:D3) D3
A2
)
= Upper (A2) = Lower (B2) = Len (A2) = EXACT (A2;F2)
False
True
RIGHT RIGHT(A2,3) A2 3
,
;
LEFT LEFT (A2,3) A2 3
)
A1&" "&B1&" "C1
LEN
=LEN(A2)
)
COUNT =Count(Al: D5)
COUNTA =Counta (Al: D5)
COUNTBLANK =Countblank (Al: D5)
)
CONUTIF =CountIF (Al: D5; "
")
A8 A2
= Date( A2 , B2 , C2 ) C2
B2
A2)
)
Rept =REPT(A1;3)
A1 MID
MID
A1
A1 3 9
)
REPLACE
A1
1 5
CONCATENATE
)
TRIM
)
IF-AND-OR-NOT IF
IF ,
IF(A1=
;
)
=IF( C2 > 10000 ; C2-C2*10% ; C2-C2*8% ) C2 C2 10
= IF (C2 >= 50 ; "
" ; "
C2 10
C2
" )
)
= IF ( C2 >= 50 ; "
" ; "
" )
= IF ( C2 > = 80 ; " *** " ; " " )
@ = IF ( C2 = "
= IF ( D2 = "
" ; " @ " ; " " )
" ; C2+C2*5% ; C2 )
AND,OR,NOT IF
TRUE,FALSE
)
= IF ( AND ( C2 >= 70 ; C2 <= 100 ) ; "
" ; "
= IF ( AND ( C2 >= 70 ; C2 <= 100 ) ; "
" ; "
" )
" )
= IF ( OR ( C2 < 50 ; C2 > 100 ) ; " ! " ; " " )
)
IF
=IF( B2>=50000;B2*10%;IF(B2>=25000;B2*8%;B2*5%))
)
= IF ( AND ( C2 >= 90 ; C2 <= 100 ) ; " 89 ) ; "
" ; IF ( AND ( C2 >= 80 ; C2 <= " ; IF ( AND ( C2 >= 80 ; C2 <=
" ; IF ( AND ( C2 > " ; IF ( AND ( C2 >= 70 ; C2 <= 79 ) ; "
>= 50 ; C2 <= 69 ) ; "
" ; "
" ; IF ( AND ( C2
" ))))
)
)
)
)
)
E
D
C
B
A
E5 A1
)
)
D
= IF C2 >= 50 ;
C
B
A
;
C2:C5
)
C2:C5
C2:C5
)
D2:D5
G
F
E
D
C
B
A
)
)
B
A
B7
A1
)
)
)
ď&#x201A;¤ F
E
D
C
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
B
A
Ctrl
)
)
)
)