المفيد في الاكسلExcel -
16
XP , 2003 DR_ENG_MOHAMED@HOTMAIL.COM - Workbook Menu Bar Tool bar Columns Rows Sheet Workbook Cell A1
-
Upload
new-technet- -
Category
Art & Photos
-
view
54 -
download
13
Transcript of المفيد في الاكسلExcel -
XP , 2003
-
-SumA1A10
=sum(a1:a10)
-Average
A1A10
=average(a1:a10)
-Count
A1A10
=count(a1:a10)
-MaxA1
A10
=max(a1:a10)
-MinA1
A10
=min(a1:a10)
-Large
=large(a1:a10;2)
-Small
=small(a1:a10;2)
XP , 2003
-log=log(a1)
-Sin=sin(a1)
-cos=cos(a1)
-tan=tan(a1)
-Upper=upper(a1)
-Lower=lower(a1)
-if
B2
= if ";" ")
Format
Format Cells
Alignment
XP , 2003
Data Subtotals
Sort
Data Validation
-
Job
Sum
Salary
Whole number
Between
This document was created with Win2PDF available at http://www.daneprairie.com.The unregistered version of Win2PDF is for evaluation or non-commercial use only.