Middle Test/ Semester 2 2010/2011

Lesson : ICT Day/Date : Wednesday, 03 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 columns 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 "SUCCESS".
Please, write a formula that should 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")