~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 !

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

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. *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. 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)

Rabu, 30 Maret 2011

MIDDLE TEXT

MIDDLE TEXT

QUESTION

1.Please, specify all the member of microsoft office 2007!
2.Please, specify all the member of pull down menu in Ms excel 2007!
3.Please, specify the number of coloumn 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"SUCCES".Please write a formula that should be used!



JAWABAN!!!!!

1.-Microsoft excel power point 2007
-Microsoft excel 2007
-Microsoft word 2007
-Microsoft acces 2007
-Microsoft publisher
2.Home : Clipboard, Font, Aligment, Number, Styles, Cells, Editing.
Insert : Tables, Illustrations, Charts, Links, Text
Page Layout : Themes, Page Setup, Scale to Fit, Sheet Options, Arrange
Formulas : Function library, Defined Names, Formula Auditing, Calculation.
Data : Get External Data, Connections, Sort & Filter, Data Tools, Outline.
Review : Proofing, Comments, Changes
View : Workbook Views, Show/Hide, Zoom, Window, Macros.

3.Microsoft excel 2007
-coloumns:16.384
-rows :1.048576
Microsoft excel 2003
-coloumns:256
-rows :65.536
4.4.a. Format Cells : To change cell or do formatting cell
b.Sum : To sum the data in range
c.Count Numbers : to sum the rows in one list
d.Max : The MAX function, one of Excel's statistical functions, is used to find the largest or maximum value in a given list of numbers
e.Min : The MIN function, one of Excel's statistical functions, is used to find the smallest or minimum value in a given list of numbers
f.COUNTIF : to calculate the more data in the list or range
g.VLOOKUP : to read yhe table with vertical
h.HLOOKUP : to read the table with horizontal
i.MID : The MEDIAN function, one of Excel's statistical functions, gives you the middle value from a list of numbers.
j.ROUND 0, ROUND 1, ROUND 2 : to round the numbers with decimal number who wanted
5.=if(F5<=76"FAIL";>=76"SUCCES")