Middle Test/Semester 2/2010-2011

Kamis, 14 April 2011

Middle Test/Semester 2/2010-2011

Lesson : ICT
Day/Date : 3 16 2011
Class/Program: XI/IA & IS
Session : 2
Semester : 2(Even)
Hour : 08.40 - 10.10

Please, answer the following question, 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 the number of coloumns and rows in :

• Microsoft Excel 2007 !
• Microsoft Excel 2003 !

4. Wheater it's function in Ms. Excel 2007 ?

• Format Cells ?
• Sum ?
• Count Numbers ?
• Max ?
• Min ?
• COUNTIF ?
• VLOOKUP ?
• HLOOKUP ?
• MID ?
• ROUND 0, ROUND 1, ROUND 2

5. If the value is less than 76, then "FAIL" and if it's value is more than 76, then "SUCCES". Please, write a formula thatshould be used

Answer!

1. Ms. Word 2007 ; Ms. Excel 2007 ; Ms. Power Point 2007 ; Ms. Access 2007 ; Ms. Office Info Path 2007 ; Ms. Office One Note 2007 ; Ms. Office Outlook 2007 ; Ms. Office Publisher 2007 ; Ms. Office Groove 2007

2.

3. Ms. Excel 2003

• Rows : 65.536
• coloumns : 256

Ms. Excel 2007

• Rows : 1.048.576
• Coloumns : 16.384

4. Function Of :

• Format Cell : For edit the active cell(s)
• Sum : Used to find the amount of content data in a certain range
• Count Number : Used to find thenumber of data from one range
• Max : Used to find the highest value from a range
• Min : Used to find the lowest value from a range
• Countif : Used to calculate the amount of data on a range of tables that meet the criteria of the conditions required by the function parameters.
• VLOOKUP : used to read in a vertical table
• HLOOKUP : used to read in a horizontal table
• Mid : used to take the character in the middle string
• Round 0 : Used to round off the numbers from 0 digits behind the data point
• Round 1 : Used to round off the numbers from 1 digits behind the data point
• Round 2 : Used to round off the numbers from 2 digits behind the data point

5. =IF(Range<76;"FAIL";"SUCCES")