Middle Test Semester 2 2010/2011

Lesson : ICT Day/Date : Wednesday, 3-16- 2011
Class/Program: XI IA 4 Session : 2
Semester : 2 (even) Hour : 08.40-10.10


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)

Simak

Baca secara fonetik

• 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")