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