Solehuddin Ingind Setia

Please answer the following questions, short and right ! please use Full English Version !

Question !

1. Please, specipy all the member of microsoft office 2007 !
2. Please, specipy all the member of pull down menu in ms Exel 2007 !
3. Please, specipy the member of coloumn and rows in :
   a. Microsoft Exel 2007
   b. Microsoft Exel 2003
4. whether is function in Ms Exel 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 3 ?
5. If the value is less than 76, then "FAIL" and its Value is ore than 76, then "SUCCES". please,
   write formula that should be used !

Answer !

1. member of Microsoft office 2007 :
   1. Microsoft Word 2007
   2. Microsoft Exel 2007
   3. Microsoft Power Point 2007
   4. Microsoft Outlook 2007
   5. Microsoft Publisher 2007
   6. Microsoft Front Page 2007
   7. Microsoft Acces 2007
   8. Microsoft Info Patch 2007
   9. Microsoft Groove 2007

2. Specify of Menu Pull Down is:
a. Home:
i. Clipboard:
 Paste:( put the copy of text which copy)
 Cut: (for cut the selected text)
 Copy: ( for copy selected text)
 Format painter
ii. Font:
 Font: for chnge the font
 Font colour: for change the colour font
 Fill colour:give colour to the selected text
 Bottom border
 Underline: to give underline to the selected text
 Italic:to make the font italic
 Bold:the font bold
 Increase font size:to increase the size of font
 Decrease font size: to decrease the size of font

iii. Aligenment :
 Top align
 Middle align
 Bottom align
 Orientation
 Align text left
 Center
 Align text right
 Decrease indent
 Increase indent
 Wrap text
 Merge and center
iv. Number:
 Number format
 Accounting number format
 Percent style
 Comma style
 Increase decimal
 Decrease decimal
v. Styles:
 Conditional formatting
 Format as table
 Cell styles
vi. Cells:
 Insert cell
 Delete cell
 Format cell
vii. Editing:
 Sum
 Fill
 Clear
 Sort and filter
 Find and select
 3. a. Coloumn : A-XFD

      Rows    : 1048576
   b. Coloumn : 256 (A-IV)
      Rows    : 65536

4. a.Format Cells is a pulldown menu to do or change following cells
   b.Sum is to calculate total of selected cells
   c.Count Numbers is to sum the data in the list
   d.Max is to display the Maximum mark/scored of selected data in the cells
   e.Min is to display the Minimum mark/scored of selected data in the cells
   f.COUNTIF is to calculate the more data in the list
   g.VLOOKUP is to read the text/table vertically way of selected data in the cells
   h.HLOOKUP is to read the text/table horizontally way of selected data in the cells
   i.MID is to search text from middle and show the value of selected cells
   j.ROUND 0, ROUND 1, ROUND 3 is to round the number with decimal numbers who wanted.

5. =IF (range<76,"FAIL",IF(range>76,"SUCCES"))
   Eemple :