Midle Test Semester II 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”)