Midle Test Semester 2 Tahun 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 Menu in Ms Excel 2007 !
3. Please,specify the number of coloums 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, ROUND 2 ?
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. They are :
* Microsoft Office Access 2007, used to processing data base.
* Microsoft Office Excel 2007, is a spread sheet program for processing number.
* Microsoft Office Word 2007, is a word sheet program for processing word’s document.
* Microsoft Office PowerPoint 2007, used to presentating document, to make a document for presentation.
* Microsoft Office OutLook 2007, used to send and receive e-mail.
* Microsoft Office Publisher 2007, used to make a brochure, poster, and banner.
*

2. They are :
* New : to make a new document.
* Open : to open file, specially excel’s file.
* Save : to save the excel’s document.
* Save As: to save a file with another name or extention like*xlsx or *xls.
* Print: to printing document.
* Close: to exit from worksheet Microsoft Excel 2007.

3. a. Columns :XED
...>>>>> For Microsoft Excel 2007
Rows : 1048576
b. Columns : IV
......>>>>> For Microsoft Excel 2003
Rows: 65536

4. a. Format cells : Used to setting the place, size, font, aligment of word, size of cell or range.
b. Sum : used to total the number in the range of cell
c. Count Number: used to total the number in the range, of cells
d. Max : used to find the maximum in the range of cells
e. Min : used to find the minimum in the range of cells
f. COUNTIF : used to total number of data which agree with the logically formula’ settings.
g. VLOOKUP : used to read the table vertically
h. HLOOKUP : used to read the table Horizontally
i. MID : used to find text on the cell as from the middle
j. ROUND 0, ROUND 1, ROUND 2 : to make to fraction in data

5.=IF (data range <76, “FAIL”,”SUCCESS”)