## 24 Mar 2011

### Midle Test Semester 2 (2010-2011)

QUESTION :

1. Please, specify and function all the members of Microsoft Office 2007 !

2. Please, specify and function all the members of pull Down in Ms Excel 2007 !

3. Please, specify the number of columns and rows in :

a. Microsoft Excel 2007 !

b. Microsoft Excel 2003 !

4. Whether its function in Ms Excel 2007 ?

a. Format Cells ?

b. Sum ?

c. Count Numbers ?

d. Max ?

e. Min ?

f. COUNTIF ?

g. VLOOKUP ?

h. HLOOKUP ?

i. MID ?

j. ROUND 0, ROUND 1, ROUND2

5. If the value is less than 76, then " FAIL " and if its value is more than 76, then "SUCCESS". Please, write a formula that should be used !

1. a. Microsoft Word = program of word
b. Microsoft Excel = program of number
c. Microsoft Power Point = program of presentations with showing slide
d. Microsoft OutLock = program of processing date
e. Microsoft accer = program of processing database
f. Microsoft Publisher = program of publish the data.

2. a. File = to arrange manner of data
b. View = to show or hidden the toolbar
c. Edit = to editing the data
d. Format = to arrange the columns and rows
e. Tools = to corrected the data
f. data = to showing comparisson of data
g. Help = to help the dat for to corrected

3 a. microsoft Excel 2007:
Columns = XED
Rows = 1048576
b. microsoft Excel 2003:
Columns = V
Rows = 65536

4. a. Format cell = the function is arrange the columns and rows
b. Sum= the function is to get the total of data
c. Count Numbers = the function is to calculate of number in the data
d. Max = the function is to get the top score of data
e. Min = the function is to get the bottom (small) score of data
f. COUNTIF = the function is to total the number of data which agree with the
logic formula's setting
g. VLOOKUP = the function is to read the table Vertically
h. HLOOKUP = the function is to read the table Horizontally
i. MID = the function is to get the middle score of data
j. ROUND 0, ROUND 1, ROUND 2 = the function is Showing and to make to fraction
in data

5. The formula is
For example: the cell is A1
= if (A1<76"FAIL","SUCCESS")

alhamdulillah akhirnya selesai juga.....