QUESTION
1.Please, specify and fuction all the member of microsoft office 2007!
2.Please, specify and fuction 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 power point 2007 for To process the data in the form of presentation
-Microsoft excel 2007 for To process the data in the form of numbers
-Microsoft word 2007 for To process the data in text form
-Microsoft acces 2007 for a computer program a relational database application aimed at the home and small-to medium-sized companies
-Microsoft publisher for For use as a Desktop publishing
2.Home : Clipboard, Font, Aligment, Number, Styles, Cells, Editing.
This menu contains the commands used for file management
Insert : Tables, Illustrations, Charts, Links, Text.
This menu contains the commands used for editing
(Editing) documents
Page Layout : Themes, Page Setup, Scale to Fit, Sheet Options, Arrange
The menu serves to prepare the data to be printed
Formulas : Function library, Defined Names, Formula Auditing, Calculation.
The menu is used to process the data in the form of statistical
Data : Get External Data, Connections, Sort & Filter, Data Tools, Outline.
The menu is used to process data in such a way
Review : Proofing, Comments, Changes
The menu used to edit data in order to be seen
View : Workbook Views, Show/Hide, Zoom, Window, Macros.
This menu contains the commands used to display settings on the display and layout settings menu and additional icons
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 use tofind 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")
