Middle Test Semester 2 Tahun 2010/2011

QUESTION :

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

2. Please, specify all the members and function of Pull Down Menu 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, 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 !

Answers...

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”)