٤٨
COLUMN
)
ﺩﻮﻤﻋ
(
)
ﻊﺟﺮﻣ
(
ﻲﻄﻌﻳ
ﻢﻗﺭ
ﺩﻮﻤﻌﻟﺍ
ﺹﺎﺨﻟﺍ
ﻊﺟﺮﻤﻟﺎﺑ
.
COLUMNS
)
ﺓﺪﻤﻋﺃ
(
)
ﺔﻓﻮﻔﺼﻣ
(
ﻲﻄﻌﻳ
ﻢﻗﺭ
ﺓﺪﻤﻋﻷﺍ
ﻲﻓ
ﺪﺣﺃ
ﻊﺟﺍﺮﻤﻟﺍ
.
COMIBIN
)
ﺔﻤﻴﻗ
1
،
ﺔﻤﻴﻗ
2
،
(...
ﻲﻄﻌﻳ
ﺩﺪﻋ
ﺕﺎﻋﻮﻤﺠﻤﻟﺍ
ﺔﺻﺎﺨﻟﺍ
ﺩﺪﻌﺑ
ﺩﺪﺤﻣ
ﻦﻣ
ﺮﺻﺎﻨﻌﻟﺍ
.
COS
)
ﻢﻗﺭ
(
ﻲﻄﻌﻳ
ﺐﻴﺟ
ﻡﺎﻤﺘﻟﺍ
ﺪﺣﻷ
ﻡﺎﻗﺭﻷﺍ
.
COUNT
)
ﺪﻋ
(
)
ﺔﻤﻴﻗ
1
،
ﺔﻤﻴﻗ
2
،
(...
ﻡﻮﻘﻳ
ﺏﺎﺴﺤﺑ
ﺩﺪﻋ
ﻡﺎﻗﺭﻷﺍ
ﺓﺩﻮﺟﻮﻤﻟﺍ
ﺔﻤﺋﺎﻘﺑ
ﻝﻭﺍﺪﻟﺍ
.
COUNTA
)
ﺔﻤﻴﻗ
1
،
ﺔﻤﻴﻗ
2
،
(...
ﻡﻮﻘﻳ
ﺏﺎﺴﺤﺑ
ﺩﺪﻋ
ﻢﻴﻘﻟﺍ
ﺓﺩﻮﺟﻮﻤﻟﺍ
ﺔﻤﺋﺎﻘﺑ
ﻝﻭﺍﺪﻟﺍ
.
COUNTBLANK
)
ﻕﺎﻄﻧ
(
ﻡﻮﻘﻳ
ﺏﺎﺴﺤﺑ
ﺩﺪﻋ
ﺎﻳﻼﺨﻟﺍ
ﺔﻏﺭﺎﻔﻟﺍ
ﻲﻓ
ﻕﺎﻄﻧ
ﻦﻴﻌﻣ
.
DATE
)
ﺦﻳﺭﺎﺗ
(
)
،ﺔﻨﺳ
،ﺮﻬﺷ
ﻡﻮﻳ
(
ﻲﻄﻌﻳ
ﻢﻗﺮﻟﺍ
ﻲﻠﺴﻠﺴﺘﻟﺍ
ﺦﻳﺭﺎﺘﻟ
ﺩﺪﺤﻣ
.
DATEVALUE
)
ﺦﻳﺭﺎﺗ
_
ﺔﻐﻴﺼﺑ
ﺔﻴﺼﻧ
(
ﻡﻮﻘﻳ
ﻞﻳﻮﺤﺘﺑ
ﺦﻳﺭﺎﺘﻟﺍ
ﻱﺬﻟﺍ
ﺔﻐﻴﺼﺑ
ﺔﻴﺼﻧ
ﻰﻟﺇ
ﻢﻗﺭ
ﻲﻠﺴﻠﺴﺗ
.
DAY
)
ﻡﻮﻳ
(
)
ﻢﻗﺭ
_
ﻲﻠﺴﻠﺴﺗ
(
ﻡﻮﻘﻳ
ﻞﻳﻮﺤﺘﺑ
ﻢﻗﺭ
ﻲﻠﺴﻠﺴﺗ
ﻰﻟﺇ
ﺪﺣﺃ
ﻡﺎﻳﺃ
ﺮﻬﺸﻟﺍ
.
DDB
)
،ﺔﻔﻠﻜﺗ
،ﺾﻳﻮﻌﺗ
،ﺓﺎﻴﺣ
،ﺓﺮﺘﻓ
ﻞﻣﺎﻋ
(
ﻲﻄﻌﻳ
ﺽﺎﻔﺨﻧﺍ
ﺔﻤﻴﻗ
ﺪﺣﺃ
ﻝﻮﺻﻷﺍ
ﺓﺮﺘﻔﻟ
ﺓﺩﺪﺤﻣ
ﻡﺍﺪﺨﺘﺳﺎﺑ
ﺔﻘﻳﺮﻃ
ﺔﻧﺯﺍﻮﻣ
ﻁﻮﺒﻬﻟﺍ
ﻲﺋﺎﻨﺜﻟﺍ
ﻭﺃ
ﻱﺃ
ﺔﻘﻳﺮﻃ
ﻯﺮﺧﺃ
ﻡﻮﻘﺗ
ﺎﻫﺪﻳﺪﺤﺘﺑ
.
DEGREES
)
ﺔﻳﻭﺍﺯ
(
ﻡﻮﻘﻳ
ﻞﻳﻮﺤﺘﺑ
ﺎﻳﺍﻭﺰﻟﺍ
ﻒﺼﻧ
ﺔﻳﺮﻄﻘﻟﺍ
ﻰﻟﺇ
ﺕﺎﺟﺭﺩ
.
ERROR
)
ﺄﻄﺧ
_
ﺔﻤﻴﻗ
(
ﻲﻄﻌﻳ
ﻢﻗﺭ
ﺮﻇﺎﻨﻣ
ﻉﻮﻨﻟ
ﺄﻄﺨﻟﺍ
.
EXACT
)
ﺺﻧ
1
،
ﺺﻧ
2
(
ﻡﻮﻘﻳ
ﻖﻘﺤﺘﻟﺎﺑ
ﻦﻣ
ﻯﺪﻣ
ﻖﺑﺎﻄﺗ
ﻦﻴﺘﻤﻴﻗ
ﻦﻴﺘﻴﺼﻧ
.
EXP
)
ﻢﻗﺭ
(
ﺪﻴﻌﻳ
ﺔﻤﻴﻗ
e
ﺔﻋﻮﻓﺮﻤﻟﺍ
ﻰﻟﺇ
ﻯﻮﺘﺴﻣ
ﺓﻮﻗ
ﻢﻗﺭ
ﺩﺪﺤﻣ
.
FACT
)
ﻢﻗﺭ
(
ﻲﻄﻌﻳ
ﻞﻣﺎﻌﻟﺍ
ﺹﺎﺨﻟﺍ
ﺪﺣﺄﺑ
ﻡﺎﻗﺭﻷﺍ
.
False
)
(
ﻲﻄﻌﻳ
ﺔﻤﻴﻘﻟﺍ
ﺔﻴﻘﻄﻨﻤﻟﺍ
FALSE
.
FIND
)
ﺩﺎﺠﻳﺇ
_
،ﺺﻧ
ﻞﺧﺍﺩ
_
،ﺺﻧ
ﻢﻗﺭ
_
ءﺪﺒﻟﺍ
(
ﻡﻮﻘﻳ
ﺩﺎﺠﻳﺈﺑ
ﺔﻤﻴﻗ
ﺔﻴﺼﻧ
ﺓﺪﺣﺍﻭ
ﻞﺧﺍﺩ
ﻯﺮﺧﺃ
ﺔﺳﺎﺴﺣ
ﺔﻟﺎﺤﻟ
ﻑﺮﺣﻷﺍ
.
FV
)
ﻝﺪﻌﻣ
,
n
ﻞﻜﻟ
,
pmt,pv
,
ﻉﻮﻧ
(
ﻲﻄﻌﻳ
ﺔﻤﻴﻘﻟﺍ
ﺔﻴﻠﺒﻘﺘﺴﻤﻟﺍ
ﺪﺣﻷ
ﺕﺍﺭﺎﻤﺜﺘﺳﻻﺍ
.
HLOOKUP
)
ﺚﺤﺒﻟﺍ
ﻦﻋ
_
ﺔﻤﻴﻗ
,
ﻝﻭﺪﺟ
_
ﺔﻓﻮﻔﺼﻣ
,
ﻒﺻ
_
ﺱﺮﻬﻓ
_
ﻢﻗﺭ
(...,
ﺚﺤﺒﻳ
ﻲﻓ
ﻒﺼﻟﺍ
ﻰﻠﻋﻷﺍ
ﻯﺪﺣﺈﺑ
ﺕﺎﻓﻮﻔﺼﻤﻟﺍ
ﻢﺛ
ﻡﻮﻘﻳ
ﺓﺩﺎﻋﺈﺑ
ﺔﻤﻴﻘﻟﺍ
ﺔﻴﻠﺨﻠﻟ
ﺔﺤﺿﻮﻤﻟﺍ
.
HOUR
)
ﻢﻗﺭ
_
ﻲﻠﺴﻠﺴﺗ
(
ﻡﻮﻘﻳ
ﻞﻳﻮﺤﺘﺑ
ﻢﻗﺭ
ﻲﻠﺴﻠﺴﺗ
ﻰﻟﺇ
ﺔﻋﺎﺳ
ﺓﺩﺪﺤﻣ
.
IF
)
ﺭﺎﺒﺘﺧﺍ
_
ﻲﻘﻄﻨﻣ
,
ﺔﻤﻴﻘﻟﺍ
_
ﺍﺫﺇ
ﺖﻧﺎﻛ
_
ﺔﺤﻴﺤﺻ
,
ﺔﻤﻴﻘﻟﺍ
_
ﺍﺫﺇ
ﺖﻧﺎﻛ
_
ﺔﺌﻃﺎﺧ
(
ﺩﺪﺤﻳ
ﺭﺎﺒﺘﺧﺍ
ﻲﻘﻄﻨﻣ
ﻢﺘﻴﻟ
ﻪﺘﻳﺩﺄﺗ
.
INDEX
)
،ﻊﺟﺮﻣ
ﻒﺻ
_
،ﻢﻗﺭ
ﺩﻮﻤﻋ
_
ﻢﻗﺭ
(
ﻡﺪﺨﺘﺴﻳ
ﺱﺮﻬﻓ
ﺭﺎﻴﺘﺧﻻ
ﺔﻤﻴﻗ
ﻦﻣ
ﻊﺟﺮﻣ
ﺩﺪﺤﻣ
.
INDIRECT
)
ﻊﺟﺮﻣ
,
A1
(
ﻲﻄﻌﻳ
ﻊﺟﺮﻤﻟﺍ
ﺹﺎﺨﻟﺍ
ﺪﺣﺄﺑ
ﺹﻮﺼﻨﻟﺍ
.
INT
)
ﻢﻗﺭ
(
ﻡﻮﻘﻳ
ﺐﻳﺮﻘﺘﺑ
ﺪﺣﺃ
ﻡﺎﻗﺭﻷﺍ
ﻰﻟﺇ
ﺏﺮﻗﺃ
ﺩﺪﻋ
ﺢﻴﺤﺻ
.
IRR
)
ﺔﻤﻴﻗ
,
ﻦﻴﻤﺨﺗ
(
ﻲﻄﻌﻳ
ﻝﺪﻌﻤﻟﺍ
ﻲﻠﺧﺍﺪﻟﺍ
ﺪﺋﺎﻌﻠﻟ
ﺔﻠﺴﻠﺴﻟ
ﻦﻣ
ﺕﺎﻘﻓﺪﺘﻟﺍ
ﺔﻳﺪﻘﻨﻟﺍ
.
ISBLANK
)
ﺔﻤﻴﻗ
(
ﻲﻄﻌﻳ
TRUE
ﻲﻓ
ﺔﻟﺎﺣ
ﻥﻮﻛ
ﺔﻤﻴﻘﻟﺍ
ﺔﻏﺭﺎﻓ
.
ISERR
)
ﺔﻤﻴﻗ
(
ﻲﻄﻌﻳ
TRUE
ﻲﻓ
ﺔﻟﺎﺣ
ﻥﻮﻛ
ﺔﻤﻴﻘﻟﺍ
ﻞﺜﻤﺗ
ﻱﺃ
ﺄﻄﺧ
ﺍﺪﻋ
#
N/A
.
ISERROR
)
ﺔﻤﻴﻗ
(
ﻲﻄﻌﻳ
TRUE
ﻲﻓ
ﺔﻟﺎﺣ
ﻥﻮﻛ
ﺔﻤﻴﻘﻟﺍ
ﻞﺜﻤﺗ
ﺔﻳﺃ
ﺔﻤﻴﻗ
ﺮﻴﻏ
ﺔﺤﻴﺤﺻ
.
ISLOGICAL
)
ﺔﻤﻴﻗ
(
ﻲﻄﻌﻳ
TRUE
ﻲﻓ
ﺔﻟﺎﺣ
ﻥﻮﻛ
ﺔﻤﻴﻘﻟﺍ
ﻞﺜﻤﺗ
ﺔﻤﻴﻗ
ﺔﻴﻘﻄﻨﻣ
.
ISNA
)
ﺔﻤﻴﻗ
(
ﻲﻄﻌﻳ
TRUE
ﻲﻓ
ﺔﻟﺎﺣ
ﻥﻮﻛ
ﺔﻤﻴﻘﻟﺍ
ﺮﻴﻏ
ﺔﺤﻴﺤﺻ
#
N/A
.
ISNONTEXT
)
ﺔﻤﻴﻗ
(
ﻲﻄﻌﻳ
TRUE
ﻲﻓ
ﺔﻟﺎﺣ
ﻥﻮﻛ
ﺔﻤﻴﻘﻟﺍ
ﺮﻴﻏ
ﺔﻴﺼﻧ
.
ISNUMBER
)
ﺔﻤﻴﻗ
(
ﻲﻄﻌﻳ
TRUE
ﻲﻓ
ﺔﻟﺎﺣ
ﻥﻮﻛ
ﺔﻤﻴﻘﻟﺍ
ﻞﺜﻤﺗ
ﻢﻗﺭ
ﺎﻣ
.
ISTEXT
)
ﺔﻤﻴﻗ
(
ﻲﻄﻌﻳ
TRUE
ﻲﻓ
ﺔﻟﺎﺣ
ﻥﻮﻛ
ﺔﻤﻴﻘﻟﺍ
ﻞﺜﻤﺗ
ﺪﺣﺃ
ﺹﻮﺼﻨﻟﺍ
.
LEFT
)
ﺺﻧ
,
ﻢﻗﺭ
_
ﻑﻭﺮﺤﻟﺍ
(
ﻲﻄﻌﻳ
ﻰﺼﻗﺃ
ﻑﻭﺮﺣ
ﻯﺪﺣﺈﺑ
ﻢﻴﻘﻟﺍ
ﺔﻴﺼﻨﻟﺍ
.
LEN
)
ﺺﻧ
(
ﻲﻄﻌﻳ
ﺩﺪﻋ
ﻑﻭﺮﺤﻟﺍ
ﻲﻓ
ﻯﺪﺣﺃ
ﻞﺳﻼﺴﻟﺍ
ﺔﻴﺼﻨﻟﺍ
.
LN
)
ﻢﻗﺭ
(
ﻲﻄﻌﻳ
ﻢﺘﻳﺭﺎﻏﻮﻠﻟﺍ
ﻲﻌﻴﺒﻄﻟﺍ
ﺪﺣﻷ
ﻡﺎﻗﺭﻷﺍ
.
LOG10
)
ﻢﻗﺭ
(
ﻲﻄﻌﻳ
ﻢﺘﻳﺭﺎﻏﻮﻟ
ﺓﺪﻋﺎﻘﻟﺍ
10
ﺹﺎﺨﻟﺍ
ﺪﺣﺄﺑ
ﻡﺎﻗﺭﻷﺍ
.
ﺔﻗﺭﻭ
ﻞﻤﻋ
Copyright © 2004 Nokia. All Rights Reserved
.
٤٩
LOOKUP
)
(
ﻲﻄﻌﻳ
ﺔﻤﻴﻗ
ﺎﻣﺇ
ﻲﻓ
ﻕﺎﻄﻧ
ﻒﺻ
ﺪﺣﺍﻭ
ﻭﺃ
ﺩﻮﻤﻋ
،ﺪﺣﺍﻭ
ﻭﺃ
ﺔﻓﻮﻔﺼﻣ
.
LOWER
)
ﺺﻧ
(
ﻡﻮﻘﻳ
ﻞﻳﻮﺤﺘﺑ
ﺺﻨﻟﺍ
ﻰﻟﺇ
ﻑﺮﺣﺃ
ﺓﺮﻴﻐﺻ
.
MAX
)
ﻢﻗﺭ
1
,
ﻢﻗﺭ
2
(...,
ﻲﻄﻌﻳ
ﺔﻤﻴﻘﻟﺍ
ﻯﻮﺼﻘﻟﺍ
ﻲﻓ
ﺔﻤﺋﺎﻗ
ﻝﻭﺍﺪﻟﺍ
.
MID
)
ﺺﻧ
,
ﻢﻗﺭ
_
ءﺪﺒﻟﺍ
,
ﺩﺪﻋ
_
ﻑﻭﺮﺤﻟﺍ
(
ﻲﻄﻌﻳ
ﺩﺪﻋ
ﺩﺪﺤﻣ
ﻦﻣ
ﻑﻭﺮﺤﻟﺍ
ﻲﻓ
ﻯﺪﺣﺇ
ﻞﺳﻼﺴﻟﺍ
ﺔﻴﺼﻨﻟﺍ
.
MIN
)
ﻢﻗﺭ
1
,
ﻢﻗﺭ
2
(...,
ﻲﻄﻌﻳ
ﺔﻤﻴﻘﻟﺍ
ﺎﻴﻧﺪﻟﺍ
ﻲﻓ
ﻯﺪﺣﺇ
ﻢﺋﺍﻮﻗ
ﻝﻭﺍﺪﻟﺍ
.
MINUTE
)
ﻢﻗﺭ
_
ﻲﻠﺴﻠﺴﺗ
(
ﻡﻮﻘﻳ
ﻞﻳﻮﺤﺘﺑ
ﻢﻗﺭ
ﻲﻠﺴﻠﺴﺗ
ﻰﻟﺇ
ﺔﻘﻴﻗﺩ
ﺓﺩﺪﺤﻣ
.
MOD
)
ﻢﻗﺭ
,
ﻢﺳﺎﻘﻟﺍ
(
ﻲﻄﻌﻳ
ءﺰﺠﻟﺍ
ﻲﻘﺒﺘﻤﻟﺍ
ﻦﻣ
ﺔﻴﻠﻤﻋ
ﺔﻤﺴﻗ
.
MONTH
)
ﻢﻗﺭ
_
ﻲﻠﺴﻠﺴﺗ
(
ﻡﻮﻘﻳ
ﻞﻳﻮﺤﺘﺑ
ﻢﻗﺭ
ﻲﻠﺴﻠﺴﺗ
ﻰﻟﺇ
ﺪﺣﺃ
ﺭﻮﻬﺸﻟﺍ
.
N
)
ﺔﻤﻴﻗ
(
ﻲﻄﻌﻳ
ﺔﻤﻴﻗ
ﻢﺗ
ﺎﻬﻠﻳﻮﺤﺗ
ﻰﻟﺇ
ﺪﺣﺃ
ﻡﺎﻗﺭﻷﺍ
.
NOW
)
(
ﻲﻄﻌﻳ
ﻢﻗﺮﻟﺍ
ﻲﻠﺴﻠﺴﺘﻟﺍ
ﺦﻳﺭﺎﺘﻠﻟ
ﺖﻗﻮﻟﺍﻭ
ﻲﻟﺎﺤﻟﺍ
.
NPV
)
ﻝﺪﻌﻣ
,
ﺔﻤﻴﻗ
1
,
ﺔﻤﻴﻗ
2
(...,
ﻲﻄﻌﻳ
ﺔﻤﻴﻘﻟﺍ
ﺔﻴﻟﺎﺤﻟﺍ
ﺔﻴﻓﺎﺼﻟﺍ
ﺪﺣﻷ
ﺕﺍﺭﺎﻤﺜﺘﺳﻻﺍ
ﺓﺪﻤﺘﻌﻤﻟﺍ
ﻰﻠﻋ
ﺔﻠﺴﻠﺳ
ﻦﻣ
ﺕﺎﻘﻓﺪﺘﻟﺍ
ﺔﻳﺪﻘﻨﻟﺍ
ﺔﻳﺭﻭﺪﻟﺍ
ﻝﺪﻌﻣﻭ
ﻢﺼﺨﻟﺍ
.
OFFSET
)
ﺔﺣﺍﺯﺇ
(
)
،ﻊﺟﺮﻣ
،ﻑﻮﻔﺻ
،ﺓﺪﻤﻋﺃ
،ﻉﺎﻔﺗﺭﺍ
ﺽﺮﻋ
(
ﻲﻄﻌﻳ
ﺪﺣﺃ
ﻊﺟﺍﺮﻤﻟﺍ
ﻰﻟﺇ
ﻕﺎﻄﻧ
ﻞﺜﻤﺘﻳ
ﻲﻓ
ﺩﺪﻋ
ﺩﺪﺤﻣ
ﻦﻣ
ﻑﻮﻔﺼﻟﺍ
ﺓﺪﻤﻋﻷﺍﻭ
ﻦﻣ
ﻝﻼﺧ
ﺔﻴﻠﺧ
ﻭﺃ
ﺔﻋﻮﻤﺠﻣ
ﻦﻣ
ﺎﻳﻼﺨﻟﺍ
.
PERMUT
)
ﻢﻗﺭ
,
ﻢﻗﺮﻟﺍ
_
ﺭﺎﺘﺨﻤﻟﺍ
(
ﻲﻄﻌﻳ
ﺩﺪﻋ
ﺕﻼﻳﺪﺒﺘﻟﺍ
ﺔﺻﺎﺨﻟﺍ
ﺐﻴﺗﺮﺘﺑ
ﺩﺪﻋ
ﺩﺪﺤﻣ
ﻦﻣ
ﺮﺻﺎﻨﻌﻟﺍ
.
PI
)
(
ﻲﻄﻌﻳ
ﺔﻤﻴﻗ
pi
.
PMT
)
ﻝﺪﻌﻣ
,
nper,pv,fv
,
ﻉﻮﻧ
(
ﻲﻄﻌﻳ
ﺔﻴﻠﻤﻋ
ﻊﻓﺪﻟﺍ
ﺔﻳﺭﻭﺪﻟﺍ
ﺔﻳﻮﻨﺴﻟﺍ
.
POWER
)
ﻢﻗﺭ
,
ﺓﻮﻘﻟﺍ
(
ﻲﻄﻌﻳ
ﺔﺠﻴﺘﻧ
ﻊﻓﺭ
ﺪﺣﺃ
ﻡﺎﻗﺭﻷﺍ
ﻰﻟﺇ
ﻯﻮﺘﺴﻣ
ﺓﻮﻗ
ﺓﺩﺪﺤﻣ
.
PRODUCT
)
ﻢﻗﺭ
1
,
ﻢﻗﺭ
2
(..,
ﻒﻋﺎﻀﻳ
ﻝﻭﺍﺪﻟﺍ
ﺔﺻﺎﺨﻟﺍ
ﻡﺎﻗﺭﻷﺎﺑ
.
PROPER
)
ﺺﻧ
(
ﻡﻮﻘﻳ
ﺮﻴﺒﻜﺘﺑ
ﻑﺮﺤﻟﺍ
ﻝﻭﻷﺍ
ﻲﻓ
ﻞﻛ
ﺔﻤﻠﻛ
ﺔﺻﺎﺧ
ﻯﺪﺣﺈﺑ
ﻢﻴﻘﻟﺍ
ﺔﻴﺼﻨﻟﺍ
.
PV
)
ﻝﺪﻌﻣ
,
nper,pmt,fv
,
ﻉﻮﻧ
(
ﻲﻄﻌﻳ
ﺔﻤﻴﻘﻟﺍ
ﺔﻴﻟﺎﺤﻟﺍ
ﺭﺎﻤﺜﺘﺳﻻ
ﻦﻴﻌﻣ
.
RADIANS
)
ﺔﻳﻭﺍﺯ
(
ﻱﺩﺆﻳ
ﻰﻟﺇ
ﻞﻳﻮﺤﺗ
ﺕﺎﺟﺭﺪﻟﺍ
ﻰﻟﺇ
ﺎﻳﻭﺍﺯ
ﻒﺼﻧ
ﺔﻳﺮﻄﻗ
.
RAND
)
(
ﻲﻄﻌﻳ
ﻢﻗﺭ
ﻲﺋﺍﻮﺸﻋ
ﻦﻴﺑ
ﺮﻔﺼﻟﺍ
ﺪﺣﺍﻮﻟﺍﻭ
.
RATE(nper,pmt,pv,fv
,
ﻉﻮﻧ
,
ﻦﻴﻤﺨﺗ
(
ﻲﻄﻌﻳ
ﺓﺮﺘﻓ
ﻝﺪﻌﻣ
ﺓﺪﺋﺎﻔﻟﺍ
ﺔﻳﻮﻨﺴﻟﺍ
.
REPLACE
)
ﺺﻧ
_
ﻢﻳﺪﻗ
,
ﻢﻗﺭ
_
ءﺪﺒﻟﺍ
,
ﺩﺪﻋ
_
ﻑﻭﺮﺤﻟﺍ
,
ﺺﻧ
_
ﺪﻳﺪﺟ
(
ﻝﺪﺒﺘﺴﻳ
ﻑﻭﺮﺤﻟﺍ
ﻞﺧﺍﺩ
ﺺﻨﻟﺍ
.
REPT
)
ﺺﻧ
,
ﺩﺪﻋ
_
ﺕﺍﺮﻤﻟﺍ
(
ﻡﻮﻘﻳ
ﺮﻳﺮﻜﺘﺑ
ﺺﻧ
ﺩﺪﻌﻟ
ﻦﻴﻌﻣ
ﻦﻣ
ﺕﺍﺮﻤﻟﺍ
.
RIGHT
)
ﺺﻧ
,
ﺩﺪﻋ
_
ﻑﻭﺮﺤﻟﺍ
(
ﻲﻄﻌﻳ
ﻑﺮﺤﻟﺍ
ﻭﺃ
ﻑﻭﺮﺤﻟﺍ
ﺓﺮﻴﺧﻷﺍ
ﻦﻣ
ﻯﺪﺣﺇ
ﻢﻴﻘﻟﺍ
ﺔﻴﺼﻨﻟﺍ
.
ROUND
)
ﻢﻗﺭ
,
ﺩﺪﻋ
_
ﻡﺎﻗﺭﻷﺍ
(
ﻡﻮﻘﻳ
ﺐﻳﺮﻘﺘﺑ
ﻢﻗﺭ
ﻰﻟﺇ
ﺩﺪﻋ
ﺩﺪﺤﻣ
ﻦﻣ
ﻡﺎﻗﺭﻷﺍ
.
ROW
)
ﻒﺻ
(
ﻲﻄﻌﻳ
ﻢﻗﺮﻟﺍ
ﺹﺎﺨﻟﺍ
ﺪﺣﺄﺑ
ﻑﻮﻔﺼﻟﺍ
ﺓﺩﺪﺤﻤﻟﺍ
.
ROWS
)
ﺔﻓﻮﻔﺼﻣ
(
ﻲﻄﻌﻳ
ﺩﺪﻋ
ﻑﻮﻔﺼﻟﺍ
ﻲﻓ
ﺪﺣﺃ
ﻊﺟﺍﺮﻤﻟﺍ
.
SECOND
)
ﻢﻗﺭ
_
ﻲﻠﺴﻠﺴﺗ
(
ﻡﻮﻘﻳ
ﻞﻳﻮﺤﺘﺑ
ﻢﻗﺭ
ﻲﻠﺴﻠﺴﺗ
ﻰﻟﺇ
ﺔﻴﻧﺎﺛ
.
SIGN
)
ﻢﻗﺭ
(
ﻲﻄﻌﻳ
ﻑﺮﺤﻟﺍ
ﻞﺑﺎﻘﻤﻟﺍ
ﻢﻗﺮﻠﻟ
.
SIN
)
ﻢﻗﺭ
(
ﻲﻄﻌﻳ
ﺐﻴﺟ
ﺔﻳﻭﺍﺰﻟﺍ
ﺓﺎﻄﻌﻤﻟﺍ
.
DDB
)
،ﺔﻔﻠﻜﺗ
،ﺾﻳﻮﻌﺗ
ﺓﺎﻴﺣ
(
ﻲﻄﻌﻳ
ﺽﺎﻔﺨﻧﻻﺍ
ﺮﺷﺎﺒﻤﻟﺍ
ﺪﺣﻷ
ﻝﻮﺻﻷﺍ
ﺓﺮﺘﻔﻟ
ﺓﺪﺣﺍﻭ
.
SQRT
)
ﻢﻗﺭ
(
ﻲﻄﻌﻳ
ﺓﺪﻋﺎﻗ
ﻊﺑﺮﻣ
ﺔﺒﺟﻮﻣ
.
STDEV
)
ﻢﻗﺭ
1
,
ﻢﻗﺭ
2
(...,
ﺭﺪﻘﻳ
ﻑﺍﺮﺤﻧﺍ
ﺭﺎﻴﻌﻤﻟﺍ
ﺪﻤﺘﻌﻤﻟﺍ
ﻰﻠﻋ
ﺪﺣﺃ
ﺝﺫﺎﻤﻨﻟﺍ
.
STDEVP
)
ﻢﻗﺭ
1
,
ﻢﻗﺭ
2
(...,
ﻡﻮﻘﻳ
ﺏﺎﺴﺤﺑ
ﻑﺍﺮﺤﻧﺍ
ﺭﺎﻴﻌﻤﻟﺍ
ﺪﻤﺘﻌﻤﻟﺍ
ﻰﻠﻋ
ﻲﻟﺎﻤﺟﺇ
ﺩﺍﺪﻌﺘﻟﺍ
.
STRING
)
(
ﻡﻮﻘﻳ
ﻞﻳﻮﺤﺘﺑ
ﺪﺣﺃ
ﻡﺎﻗﺭﻷﺍ
ﻰﻟﺇ
ﺺﻧ
ﺎًﻘﺒﻃ
ﺔﻠﺴﻠﺴﻟ
ﻖﻴﺴﻨﺘﻟﺍ
ﺓﺩﺪﺤﻤﻟﺍ
.
SUM
)
ﻢﻗﺭ
1
,
ﻢﻗﺭ
2
(...,
ﻒﻋﺎﻀﻳ
ﻝﻭﺍﺪﻟﺍ
ﺔﺻﺎﺨﻟﺍ
ﻡﺎﻗﺭﻷﺎﺑ
.
SUMPRODUCT
)
ﺔﻓﻮﻔﺼﻣ
1
,
ﺔﻓﻮﻔﺼﻣ
2
,
…
(
ﻲﻄﻌﻳ
ﻲﻟﺎﻤﺟﺇ
ﺕﺎﻓﻮﻔﺼﻤﻟﺍ
ﺔﻔﻋﺎﻀﻤﻟﺍ
.
ﺔﻗﺭﻭ
ﻞﻤﻋ
Copyright © 2004 Nokia. All Rights Reserved
.
٥٠
SUMSQ
)
ﺔﻓﻮﻔﺼﻣ
1
,
ﺔﻓﻮﻔﺼﻣ
2
(
ﻲﻄﻌﻳ
ﻲﻟﺎﻤﺟﺇ
ﺕﺎﻌﺑﺮﻤﻟﺍ
.
SYD
)
ﺔﻔﻠﻜﺘﻟﺍ
,
ﺾﻳﻮﻌﺘﻟﺍ
,
ﺓﺎﻴﺤﻟﺍ
,
ﻞﻜﻟ
(
ﻲﻄﻌﻳ
ﻲﻟﺎﻤﺟﺇ
ﺽﺎﻔﺨﻧﺍ
ﻡﺎﻗﺭﺃ
ﺕﺍﻮﻨﺴﻟﺍ
ﺔﺻﺎﺨﻟﺍ
ﺪﺣﺄﺑ
ﻝﻮﺻﻷﺍ
ﺓﺮﺘﻔﻟ
ﺓﺩﺪﺤﻣ
.
T
)
ﺔﻤﻴﻗ
(
ﻡﻮﻘﻳ
ﻞﻳﻮﺤﺘﺑ
ﻝﺍﻭﺪﻟﺍ
ﺔﺻﺎﺨﻟﺍ
ﻡﺎﻗﺭﻷﺎﺑ
ﻰﻟﺇ
ﺺﻧ
.
TAN
)
ﻢﻗﺭ
(
ﻲﻄﻌﻳ
ﻞﻣﺎﻌﻟﺍ
ﺹﺎﺨﻟﺍ
ﺪﺣﺄﺑ
ﻡﺎﻗﺭﻷﺍ
.
TERM
)
(
ﻡﻮﻘﻳ
ﺏﺎﺴﺤﺑ
ﺩﺪﻋ
ﺕﺎﻋﻮﻓﺪﻤﻟﺍ
ﺔﺻﺎﺨﻟﺍ
ﺪﺣﺄﺑ
،ﺕﺍﺭﺎﻤﺜﺘﺳﻻﺍ
ﻊﻣ
ﺩﻮﺟﻭ
ﺔﻴﻤﻛ
ﻊﻓﺪﻟﺍ
ﺔﻳﺭﻭﺪﻟﺍ
P
،
ﻝﺪﻌﻣﻭ
ﺓﺪﺋﺎﻔﻟﺍ
R
،
ﺔﻤﻴﻘﻟﺍﻭ
ﺔﻴﻠﺒﻘﺘﺴﻤﻟﺍ
FV
.
TIME
)
ﺖﻗﻭ
(
)
،ﺔﻋﺎﺳ
،ﺔﻘﻴﻗﺩ
ﺔﻴﻧﺎﺛ
(
ﻲﻄﻌﻳ
ﻢﻗﺮﻟﺍ
ﻲﻠﺴﻠﺴﺘﻟﺍ
ﺦﻳﺭﺎﺘﻟ
ﺩﺪﺤﻣ
.
TIMEVALUE
)
ﺖﻗﻭ
,
ﺺﻧ
(
ﻡﻮﻘﻳ
ﻞﻳﻮﺤﺘﺑ
ﺖﻗﻮﻟﺍ
ﻱﺬﻟﺍ
ﺔﻐﻴﺼﺑ
ﺔﻴﺼﻧ
ﻰﻟﺇ
ﻢﻗﺭ
ﻲﻠﺴﻠﺴﺗ
.
TODAY
)
(
ﻲﻄﻌﻳ
ﻢﻗﺮﻟﺍ
ﻲﻠﺴﻠﺴﺘﻟﺍ
ﺦﻳﺭﺎﺘﻠﻟ
ﻲﻟﺎﺤﻟﺍ
.
TRIM
)
ﺺﻧ
(
ﻑﺬﺤﻳ
ﺕﺎﻓﺎﺴﻤﻟﺍ
ﻦﻣ
ﺺﻨﻟﺍ
.
TRUE
)
(
ﻲﻄﻌﻳ
ﺔﻤﻴﻘﻟﺍ
ﺔﻴﻘﻄﻨﻤﻟﺍ
TRUE
.
TRUNC
)
ﻢﻗﺭ
,
ﺩﺪﻋ
_
ﻡﺎﻗﺭﻷﺍ
(
ﻡﻮﻘﻳ
ﺭﺎﺼﺘﺧﺎﺑ
ﻢﻗﺮﻟﺍ
ﻰﻟﺇ
ﺩﺪﻋ
ﺢﻴﺤﺻ
.
TYPE
)
ﻞﻘﺣ
(
ﻲﻄﻌﻳ
ﻢﻗﺭ
ﺪﻤﺘﻌﻳ
ﻰﻠﻋ
ﻯﻮﺘﺤﻤﻟﺍ
ﺹﺎﺨﻟﺍ
ﻞﻘﺤﻟﺎﺑ
ﺩﺪﺤﻤﻟﺍ
.
UPPER
)
ﺺﻧ
(
ﻡﻮﻘﻳ
ﻞﻳﻮﺤﺘﺑ
ﺺﻨﻟﺍ
ﻰﻟﺇ
ﻑﺮﺣﺃ
ﺓﺮﻴﺒﻛ
.
VALUE
)
ﺺﻧ
(
ﻡﻮﻘﻳ
ﻞﻳﻮﺤﺘﺑ
ﺔﻟﺍﺩ
ﺺﻨﻟﺍ
ﻰﻟﺇ
ﻢﻗﺭ
.
VAR
)
ﻢﻗﺭ
1
,
ﻢﻗﺭ
2
(...,
ﺭﺪﻘﻳ
ﻑﻼﺘﺧﺍ
ﺭﺎﻴﻌﻤﻟﺍ
ﺪﻤﺘﻌﻤﻟﺍ
ﻰﻠﻋ
ﺪﺣﺃ
ﺝﺫﺎﻤﻨﻟﺍ
.
VARP
)
ﻢﻗﺭ
1
,
ﻢﻗﺭ
2
(...,
ﻡﻮﻘﻳ
ﺏﺎﺴﺤﺑ
ﻑﻼﺘﺧﺍ
ﺭﺎﻴﻌﻤﻟﺍ
ﺪﻤﺘﻌﻤﻟﺍ
ﻰﻠﻋ
ﻲﻟﺎﻤﺟﺇ
ﺩﺍﺪﻌﺘﻟﺍ
.
VLOOKUP
)
ﺚﺤﺑ
ﻦﻋ
_
ﺔﻤﻴﻘﻟﺍ
,
ﻝﻭﺪﺟ
_
ﺔﻓﻮﻔﺼﻤﻟﺍ
,
ﻢﻗﺭ
_
ﺩﻮﻤﻌﻟﺍ
_
ﺱﺮﻬﻔﻟﺍ
(...,
ﺚﺤﺒﻳ
ﻦﻋ
ﻯﺪﺣﺇ
ﻢﻴﻘﻟﺍ
ﻲﻓ
ﺩﻮﻤﻌﻟﺍ
ﻲﻘﺒﺘﻤﻟﺍ
ﺪﺣﺄﺑ
ﻝﻭﺍﺪﺠﻟﺍ
ﻡﻮﻘﻳﻭ
ءﺎﻄﻋﺈﺑ
ﺔﻤﻴﻘﻟﺍ
.
YEAR
)
ﻢﻗﺭ
_
ﻲﻠﺴﻠﺴﺗ
(
ﻡﻮﻘﻳ
ﻞﻳﻮﺤﺘﺑ
ﻢﻗﺭ
ﻲﻠﺴﻠﺴﺗ
ﻰﻟﺇ
ﺔﻨﺳ
.
ﺔﻗﺭﻭ
ﻞﻤﻋ
Copyright © 2004 Nokia. All Rights Reserved
.
٥١
١٠
.
ﺽﻭﺮﻌﻟﺍ
ﺔﻴﻤﻳﺪﻘﺘﻟﺍ
ﻚﻨﻜﻤﻳ
ﻦﻣ
ﻝﻼﺧ
Presentations
،
ﺢﺘﻓ
ﺽﺮﻋﻭ
ﻞﻳﺪﻌﺗﻭ
ﻆﻔﺣﻭ
ﺽﻭﺮﻌﻟﺍ
ﺔﻴﻤﻳﺪﻘﺘﻟﺍ
ﺓﺄﺸﻨﻤﻟﺍ
ﺔﻄﺳﺍﻮﺑ
ﺞﻣﺎﻧﺮﺑ
Powerpoint 97
ﺔﻛﺮﺸﻟ
Microsoft
ﻭﺃ
ﺕﺍﺭﺍﺪﺻﻹﺍ
ﺙﺪﺣﻷﺍ
.
ﻚﻨﻜﻤﻳ
ﺎًﻀﻳﺃ
ءﺎﺸﻧﺇ
ﺽﻭﺮﻋ
ﺔﻴﻤﻳﺪﻘﺗ
ﺓﺪﻳﺪﺟ
.
ﻆﺣﻻ
ﻪﻧﺃ
ﻻ
ﻢﺘﻳ
ﻢﻴﻋﺪﺗ
ﻞﻛ
ﺎﻳﺍﺰﻤﻟﺍ
ﺕﺎﻘﻴﺴﻨﺘﻟﺍﻭ
ﺔﺻﺎﺨﻟﺍ
ﺕﺎﻔﻠﻤﻟﺎﺑ
ﺔﻴﻠﺻﻷﺍ
.
ﺐﻫﺫﺍ
ﻰﻟﺇ
Desk
→
Office
→
Presentations
.
ﺽﺮﻋ
ﺽﻭﺮﻌﻟﺍ
ﺔﻴﻤﻳﺪﻘﺘﻟﺍ
ﺢﺘﻔﻟ
ﺪﺣﺃ
ﺽﻭﺮﻌﻟﺍ
ﺔﻴﻤﻳﺪﻘﺘﻟﺍ
،ﺓﺩﻮﺟﻮﻤﻟﺍ
ﻂﻐﺿﺍ
ﻰﻠﻋ
Menu
)
ﺔﻤﺋﺎﻘﻟﺍ
(
،
ﺩﺪﺣﻭ
File
→
Open
...
ﻭﺃ
ﻂﻐﺿﺍ
ﻰﻠﻋ
Ctrl+O
.
ﻢﻗ
ﺢﻔﺼﺘﻟﺎﺑ
ﻝﻮﺻﻮﻠﻟ
ﻰﻟﺇ
ﺔﻈﻓﺎﺤﻟﺍ
ﻲﺘﻟﺍ
ﻱﻮﺘﺤﺗ
ﻰﻠﻋ
ﻒﻠﻤﻟﺍ
.
ﻚﻨﻜﻤﻳ
ﻚﻳﺮﺤﺗ
ﺔﺤﻳﺮﺸﻟﺍ
ﻰﻠﻋﺃ
ﻭﺃ
،ﻞﻔﺳﺃ
ًﻻﺎﻤﺷﻭ
ﺎًﻨﻴﻤﻳﻭ
ﺔﻄﺳﺍﻮﺑ
ﻡﺍﺪﺨﺘﺳﺍ
ﺡﺎﺘﻔﻣ
ﻞﻘﻨﺘﻟﺍ
.
ﺢﻴﻤﻠﺗ
:
ﺢﺘﻔﻟ
ﺽﺮﻋ
ﻲﻤﻳﺪﻘﺗ
ﻢﺗ
ﻪﺿﺮﻋ