midle examination

Please, answer the following questions, short and right! Please, use full English version!

QUESTION:

1.1. PLEASE, specify and function all the members of Microsoft office 2007 and each function !

2.2. PLEASE, specify and function all the members of pull down menu in Ms excel 2007 and each function !

3. 3.PLEASE, specify the number of coloum and rows in :

· Ms excel 2007 !

· Ms excel 2003 !

4.whether is function in Ms excel 2007 ?

a. format cell ?

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, than “ FAIL “ and if its value is more than 76, then “ SUCCESS” . please,

Write a formula that should be used !

ANSWER:

1 1. *MICROSOFT EXCEL 2007 : aspread sheet program for processing number

*MICROSOFT Word 2007: is a word sheet program for processing word ‘s document

*MICROSOFT POWER POINT 2007: used to prosenteting a document to make document prosenteting

*MICROSOFT OFFICE OUTLOOK 2007: used to send and deceive email

*MICROSOFT OFFICE PUBLISHER 2007:Used to make brochure poster and banner

*MICROSOFT OFFICE ACCESS 2007 : Used to processing date base

1. 2. a. file

b.edit

c.format

d. view

e.date

f.tools

g.help

3.Ms.excel 2007 :

a. colums : XED

b.rows : 1048546

Ms.excel 2003 :

a.colums : IV

b.rows : 65536

4. a. format cell ? arrange the columns and rows

b. sum ? used for total all number

c. count numbers ? used for count the number a range of cells

d. max ? to search max score in Ms.excel 2007

e. min ? to search min score in Ms.excel 2007

f. COUNTIF ? to count the same data in other the formula ‘s

g. VLOOKUP ? use to read the table in vertically

h. HLOOKUP ? read the table horrizontally

i. MID ? to search middle score in Ms. 2007

j. ROUND 0, ROUND 1, ROUND 2 ? make to fraction in data

5. for example the cells is located A1 IF (A1< 76”FAIL”,SUCCESS)