MIDDLE TEXT

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 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, then “FAIL” and if its value is more than 76, then “SUCCESS”. Please, write a formula that should be used !

ANSWER…

1.Microsoft Office Access 2007
Microsoft Office Excel 2007
Microsoft Office Word 2007
Microsoft Office Power Point 2007
Microsoft Office Publisher 2007

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.a. Microsoft Excel 2007
Columns: 16.384 columns
Rows : 1.048.576 rows
b. Microsoft Excel 2003
Columns: 256 columns
Rows : 65.536 rows

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 (C7<=76;"FAIL";"SUCCESS")