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 !


Answer!

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.....