MIDDLE TEST

Jumat, 13 Mei 2011

QUESTION

1. Please, specify all the members of microsoft office 2007!
2. Please, specify all the members 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. Minf. 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”)