QUESTION
- Please . specify all members of Microsoft office 2007 !
- Please . specify all members of pull down menu in Ms Excel 2007
- Please . specify the number of columns and row in :
- Microsoft excel 2007 !
- Microsoft excel 2003 !
- Whether its function in Ms Excel 2007
- a.Format cells ?
- b.Sum ?
- c.Count number ?
- d.Max ?
- e.Min ?
- f.Count if ?
- g.Vlookup ?
- h.Hlookup ?
- i.Mid ?
- j.Round 0, round 1, round 2 ?
- If the value is less than 76, then “FAIL” and if its value is more tahan 76, then “SUCCESS”. 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")
