Middle Test Semester 2 2010/2011

Lesson : ICT Day/Date : Saturday, 3 16 2011

Class/Program : XI/IA & IS 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 the number of columns and rows in :

a. Microsoft Excel 2007 !

b. Microsoft Excel 2003 !

4. Whether is 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. Members of Microsoft Office 2007:

· Microsoft Acces 2007.

· Microsoft Excel 2007.

· Microsoft Outlook 2007.

· Microsoft PowerPoint 2007.

· Microsoft Publisher 2007.

· Microsoft Word 2007.

2. Members of Pull Down Menu in Microsoft Excel:

· Office Button.

· Home.

· Insert.

· Page Layout.

· Formulas.

· Data.

· Review.

· View.

3. Number of columns and rows :

a. Microsoft Excel 2007 : 1.048.576 rows dan 16.384 columns.

b. Microsoft Excel 2003 : 65.536 rows dan 256 columns.

4. Function of :

a. Format Cell : Change the row height or column width, organize sheets, or protect or hide cells.

b. Sum : used to find the amount of content data in a certain range.

c. Count Number : Use COUNT to get the number of entries in a number field that is in a range or array of numbers.

d. Max : used to find the highest value from a range.

e. Min : used to find the lowest value from a range.

f. COUNTIF : used to calculate / chopping a cell / range based on specific criteria.

g. VLOOKUP : to compute / retrieve values ​​from a reference table vertically and then inserted into the working table.

h. HLOOKUP : to compute / retrieve values ​​from a reference table horizontally and then inserted into the working table.

i. MID :

j. ROUND 0,ROUND 1,ROUND 2

5. For value is more than 76

=IF(<76,”SUCCESS”)

For value is less than 76

=IF(>76,"FAIL")