Sabtu, 14 Mei 2011

Middle Test Semester 2 2010/2011

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

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 all the members of Columns and Rows in :
a. Microsoft Excel 2007 !
b. Microsoft Excel 2003 !
4. Wheter its function in Microsoft 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 !


Notice !

Strictly forbidden to operate a Laptop, Notebook, Netbook, and Similar !!!!!!!!!!!!

My Answer :

1. - Microsoft Office Excel 2007
- Microsoft Office Acces 2007
- Microsoft Office Words 2007
- Microsoft Office Power Point 2007
- Microsoft Office Publisher 2007
- Microsoft Office Picture Manager 2007
- Microsoft Office Diagnostics 2007
- Microsoft Office 2007 Language Settings
- Microsoft Clip Organizer 2007
- Digital Certificate for VBA Projects 2007

2. a. Office Button






















b. Home








c. Insert








d. Page Layout



e. Formulas



f. Data
g.Refiew
h.View

3.
  • Ms. Excel 2003
256 kolom (bertanda IV kalau abjad)
65.536 baris

  • Ms. Excel 2007
16.384 kolom bertanda XFD kalau abjad
1.048.576 baris
4
  • FORMAT CELLS :to reformat existing data
  • SUM: used to find the number of contents data in a certain range
  • COUNT NUMBER :
  • MAX: used to find the highest value from a range
  • MIN: used to find the lowest value from a range
  • COUNT: used to seek the wealth of data from one range
  • VLOOKUP: looking for value, where its provisions beberbentuk table vertical (down structured data)
  • HLOOKUP: looking for value, where its provisions beberbentuk horizontal table (data are arranged horizontally)
  • MID :a function that is used to take several characters from the data in Microsoft Excel starts from the middle.
  • ROUND 0, ROUND 1,ROUND 2 := ROUND (number, number of digits), number means the number / numbers (which may contain numbers or formulas) and "number of digits" digits behind the decimal is desired. For example, = ROUND (1 / 8, 2) will result in 00:13. This formula is useful in many areas of finance, especially the value of the transaction.
5.=IF(A10>=76,"SUCCES","LESS")

=IF(A10<=76,(IF(A2>=76,"Naik","Tidak Naik")),"Tidak Naik")