Rabu, 27 April 2011

MIDDLE TEST SEMESTER II 2010/2011

Lesson : ICT Day/Date : Wednesday, 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 verion!
QUESTION :
1. Please, specify all the members of Microsoft Office 2007 !
2. Please, specify all the members of Pull Down Menu Microsoft 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 more than 76, than “SUCCESS”. Please write a formula that should be used !
Notice !
Strictly forbidden to operate a Laptop, Notebook, Netbook and similar !!!
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")

Tidak ada komentar:

Poskan Komentar